You can use the unpivot operator in SQL Server 2005 to do this:

declare @config table (id int, name varchar(10), type varchar(10))

declare @vehicle table (id int, make varchar(10), model varchar(10), color...

I believe that is true - both reporting services and notification services are not cluster aware and need to be installed on both the nodes separately.

Read up BOL for fn_get_sql()  (this was introduced in SP3 for SQL 2000).

There is a lot of good information regarding waitresource on this site - you can search for it, here is one URL from a previous discussion on the same topic...

As Jaideep mentioned, this is a datetime data-type.  You can use the CONVERT function to do manupulations on it.

Synonyms are only for the schema objects.

DECLARE @T1 TABLE (A INT, B INT, C INT)

INSERT INTO @T1 VALUES (4955, 123, 100)

INSERT INTO @T1 VALUES (4955, 123, 200)

INSERT INTO @T1 VALUES (4955, 124, 100)

INSERT INTO @T1 VALUES...

If you cannot modify the insert statement from the feed because it is not under your code control, you can have an interface table in which the feed inserts the...

Ok - if that is the case, then you do not need to have LocationID in the CLIENT table.  The relationship is 1:N then instead of M:N.  So, you will...

You have two logical entities : Client and Location.  These two have a many-to-many relationship between them since a client can have 1-N locations and a location can be serviced...

ROWID has no equivalent. ROWNUM can be simulated and the above link gives you some of those options.

(CASE

WHEN CLIENTBOXNUMBER IN ('0096028', '0096076') THEN '0096064'

ELSE ''

END)

PL/SQL is Oracle lingo...SQL Server's language is T-SQL.

If your stats are up-to-date, then you can do this:

select  substring(o.name, 1, 30) Table_Name ,i.rows  Number_of_Rows

from  sysobjects o 

inner join sysindexes i ...

You can use DTS and set global variable values based on the select from the table and then just use the "Execute Process Task" to run the command for copying...

Can you post the schema definition, some sample data for this issue ?

Is EFF_DTE a datetime/smalldatetime data-type column ? If so, then it has to "exactly" match in all those...