ssismaddy (11/9/2010)

pauled2109 (11/9/2010)

SELECT Item = convert(int, ds.Item)

FROM dbo.DelimitedSplit8k(@IDList, ',') ds;

Click here for the latest Delimited Split Function.

rajg (11/9/2010)

I have a table with two columns i.e. ChangeDate and StepId. I need a third column 'status' at run time based on the data in this table.

Records can...

Use the second method - you'll be able to utilize available indexes. The first method will end up with scans on both tables.

Using Cluster Administrator, go to the resource group for the SQL Services. Right-click "SQL Server", and select "Take Offline". This will also take the SQL Server Agent offline.

I had no problems with your sample data and update statement in this code:

DECLARE @XMLCargo XML;

SET @XMLCargo = '<root><row orderid=''323936'' ordernumber=''125924'' cargoready=''01/11/2010 00:00:00'' estpallets=''1'' estweight=''2'' estvolume=''3''/><row orderid=''326695'' ordernumber=''128176'' cargoready=''01/21/2010 00:00:00''...

Forget the online text editor... put it into a word document. Steve will convert it.

I recently ran into an issue where a server's diff backups were failing. DB set to full weekly, diffs daily (test db, so no t-logs). On the third day after...

@craig-2: +1

SELECT DISTINCT

attribute_id,

Val = stuff((SELECT ', ' + Val

...

Would you mind posting your solution, so that we can see how it differs?

How does this work for you?

declare @date1 datetime,

@date2 datetime,

@SwapDate datetime;

SELECT @Date2 = GetDate(),

...

Interesting - I always thought that when creating a procedure with parameters, that all of the parameters were to be in a set of parenthesis. I...

CONVERT(nchar(23), <FieldToConvert>)