Thanks, we'll give that a try and post the results

Good question! Can't wait until Christmas!

8k = buffer...

http://msdn.microsoft.com/en-us/library/aa337525(SQL.90).aspx

... and there's my 2 points back!

I agree with everyone else. How am I supposed to know that "sales" is a float?

... there's 1 point back

Since writing this post, have you found a way to eliminate the warning message? Seems a little short sighted of Microsoft to think that the various environments that companies...

Yes, its the .rdl file that will point you to the correct stored procedure. Open it in VS, and click on the Data tab.

Been busy, just checked on this thread. Should have figured it was the db setting.

@usman.tanveer ... For some reason apparantly not every install has the same options...

Sounds like a client side issue. If you are using SMSS, do you have Tools > Options > Scripting > "Script for server Version" ... make sure its...

You could look at this post too, if you wanted some direction on how to avoid the dynamic sql...

http://www.sqlservercentral.com/Forums/Topic475805-338-1.aspx#bm476235

I haven't worked with common table expressions much, but wondering if you are trying to get the values into array variables?? The only way I've done that is through table...

Looks like raycollins2 has your answer, but depending on if your updating 1 row at a time, its probably faster (appears performance isn't and issue since you are using...

Christian Buettner (7/9/2008)

---

Nice one!

And I also have a question: During execution of the batch, I get a warning:

XML DTD has been stripped from one or more XML fragments. External...

I'm sure you've moved on by now, but looks like you are trying to pass a string into to the getavariables in order to retreive the one you want. ...

If I understand what the point of the original question was correctly, all you want to do is returen a table from a a column with values. I had...