I have this scalar function:
create function [Headlines].[HeadlineCount]()
returns int
as

Im having difficulty in using the HAVING statement with more than 1 criteria
and would like to know how I might find the following?
I have a table (fullres2) with horse racing details over numerous columns but
need to find out..

I would like to create a table that will relate an account to its parent(s).
1 account can have multiple parents, and 1 parent can have multiple
accounts.
And, a parent can have a master parent.

I am looking at a procedure that does a FULL OUTER JOIN on 2 views.
SELECT ...
FROM vw1 WS1
FULL OUTER JOIN vw2 as WS2 ON WS1.WorkSpaceID = WS2.WorkspaceID

I want to update with same tables an online sql server with local data of a
software.
The online and local tables structures are the same, the name of the table
also.

Via a calculation, how do you truncate to 2 decimal places ?
.678952  should be .67
I have seen where people have suggested Round(.678952 , 2 , 1)
But I got an error message when i tried that....

What are some [good/useful] was to use triggers? I need concrete examples so
I can evaluate my reasons for using triggers. So far, I have 2 of them:
1. Return all of, or part of the resultset that was modified (insert/delete
tables).

i have a table purchaseorders linked by ponumber to poitems table
which contains the price an item was bought for.
i need to knwo the last time the itme was purchased and the price
paid.

Does anybody know where I can find the sample Adventureworks database? I
need the most recent one for sql server 2008 sp1.

Imagine a database with a bad naming convention you wish to clean up -
having some columns with the same names as the table and the
identifier columns named as ID_<table name>.
Writing a script to rename tables, columns and constraints using

having a table in SQL Server 2000 with a DateTime field and some values like:
ReferenceDate
2009-05-26 22:30:00.000
2009-05-27 12:30:00.000

CREATE TABLE tblA (
       Symbol               varchar(50) NOT NULL,
       APIFormat      varchar(50) NULL,
       DataFormat      varchar(50) NULL

Is it possible to ensure that a particular object - in this case a table -
resides on a particular file in a particular file group.
I am able to place a table on a particular filegroup - however I have no
idea which file it resides on in that particular file group.

Hi, using SQL2005. I want to replace a function and can't because the
function is being referenced by an object. I have tried to drop it first and
then create the function. This has the same error result.
Is there a way to ignore any referenced object and drop a function (and ...

I have a table that has only 275 records that has a composite primary key
(not my table).
CREATE TABLE MyTable
(