ssismaddy (11/9/2010)

---

Thank you all for the quick replies. I know the table which gives the output. But my concern is, I am not supposed to access the table directly,...

pauled2109 (11/9/2010)

---

As it turned out the table being updated has got a couple of triggers on it (it's a legacy database so I am still finding things like this hidden...

SELECT Item = convert(int, ds.Item)

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

Click here for the latest Delimited Split Function.

rajg (11/9/2010)

---

Hi,

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 Farrell (11/8/2010)

---

cte's are guaranteed to be pre-processed by the optimizer...

I would suggest getting all of the fields in a CTE, then doing the DateDiff in the final select:

WITH CTE AS

(

SELECT cv.currentlocation,

cv.ClientDisplayName,

...

@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(),

...