Tried this before, you get: Msg 6819, Level 16, State 3, Line 3 The FOR XML clause is not allowed in a ASSIGNMENT statement.
Hello, I'm having trouble with a simple assignment to a string variable from a select clause using the FOR XML construction. This works on sql 2005,...
Hi Background: My company is in the process of upgrading our sql 2000 server to 2005 on new server hardware. In this process I'm charged with the...
Separate names with a comma.