I don't think you'd need the DISTINCT in your NOT IN clause. It won't matter anyway if there'd be more than one row returned per id. This would eliminate a...

You define an XML parameter in your sproc and send your parameter list as a valid xml string.

In the sproc you transform the xml data into either a relational table...

If you go there will be trouble. An’ if you stay it will be double.

So, in order to minimize trouble: RUN, Jason,...

Something like the following code?

(Side note: untested due to the lack of ready to use sample data)

SELECT Part,DATEDIFF(dd,MAX(DATE),'20100810') AS age

FROM Inv_Warehouse

WHERE Status IN('InHouse', 'Delivered', 'Returned')

GROUP BY Part

Not if you also need to know the value of the AppId attribute and not as long as your pkg nodes are not nested within a root node.

If you don't...

Please have a look at the CrossTab article referenced in my signature for an alternative way.

The CrossTab method will also make it a lot easier to return dynamic yearmonth columns...

Let's assume you have the file stored as c:\Temp\SSC.txt.

Then you could use the following code (assuming you'd like to store the data in a xml column):

/*

CREATE TABLE T (IntCol int,...

Here's an example of what I think Wayne is talking about:

DECLARE @xml XML

SET @xml=

'<requests AppId="1">

<pkg attribute1="a" attribute2="w"/>

<pkg attribute1="b" attribute2="x"/>

<pkg attribute1="c" attribute2="y"/>

<pkg attribute1="d" attribute2="z"/>

</requests>'

/*-- or, alternatively

SET @xml=

'<pkg attribute1="a" attribute2="w" AppId="2"/>

<pkg attribute1="b"...

@mike-2: The quirky update method should not be used on joined tables. See Jeff's revised article[/url] for details.

Other than that: as just confirmed the target system is SS2K5. No need...

Now it starts to get confusing...

You posted in a SS2K forum.

When Jeff mentioned it regarding Mike's solution you didn't reply to clarify.

And now you're posting a query that won't work...

So would do others (like me) 🙂

We might be able to find a solution without using joined tables when performing the...

Why don't you use the "old-fashioned" CASE statement?

SELECT

SiteID,

ServDate,

SUM(CASE WHEN Meal=1 THEN FreeCnt ELSE 0 END) as Meal1FreeCnt,

SUM(CASE WHEN Meal=1 THEN Reduced ELSE 0 END) as Meal1Reduced,

SUM(CASE WHEN Meal=1...

@@ROWCOUNT will return the affected rows based on the statement before @@ROWCOUNT.

You don't have to look for batch terminator.

Other than that, yes, you'd have to look for each statement where...

I would start running a profiler trace on "SQL batch starting/complete" to see if the duration of the statements will increase over time and which statement that would be.

It depends.

Is the system still able to run? If not, what error message do you get?

When was the last transaction log backup? Is there any schedule for log backups? If...