Posted by SQL on 05/16/06 22:48

also take out the dot here
The code works but the dot shouldn't be there anyway
instead of this
FROM .'+@tbl+''
use this
FROM '+@tbl+''

Denis the SQL Menace
http://sqlservercode.blogspot.com/

• Next in forum: Putting attribute on root node using FOR XML PATH
• Prev in forum: Re: Create Status Table
• Thread view: Re: Create Status Table

[Reply to this message]