Tried this before, you get:
Msg 6819, Level 16, State 3, Line 3
The FOR XML clause is not allowed in a ASSIGNMENT statement.
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,...
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.