Viewing 7 posts - 1 through 7 (of 7 total)
UMG Developer (7/6/2010)Nice question, thanks!I'm a little surprised that so many people have gotten it correct so far, but that may be because of the copy, paste, F5 syndrome. 😉
UMG Developer (7/6/2010)
I'm a little surprised that so many people have gotten it correct so far, but that may be because of the copy, paste, F5 syndrome. 😉
July 6, 2010 at 11:54 pm
Well, I think I found a work around... If [destAll] is defined as a table, and not a view, and nothing else is changed, everything seems to execute correctly.
June 11, 2010 at 9:18 am
Dan Guzman - Not the MVP (11/18/2009)
November 18, 2009 at 1:55 pm
Since the WITH clause goes before the query, the example above would be:
with xmlnamespaces('http://ww.w3.org/TR/html4/' as h)
select getDate() as '@timestamp',
( select name as '@name', xtype as 'data/@xtype'
July 27, 2009 at 8:30 am
My only question is why I thought that when n wasn't specified in a cast/convert it was 50... good thing I never leave out those pesky optional variables in production...
March 17, 2009 at 9:04 am
Using Dan's method of building the root tag manually, I got everything to work with the path() command as well. It's really just a "Nested FOR XML Query" (that's...
October 5, 2007 at 7:41 am
Thanks for the response, but that wasn't quite what I was looking for.
DECLARE @xml VARCHAR(4000)
SELECT @xml = (SELECT name as '@name', xtype as 'data/@field1' FROM sysobjects FOR XML PATH('object'),...
October 3, 2007 at 11:23 am