Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 123»»»

FOR XML PATH Expand / Collapse
Author
Message
Posted Thursday, February 18, 2010 9:31 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, July 21, 2014 8:27 AM
Points: 1,343, Visits: 7,176
Comments posted to this topic are about the item FOR XML PATH

bc
Post #868752
Posted Thursday, February 18, 2010 10:34 PM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Today @ 7:50 AM
Points: 3,859, Visits: 5,001
good question

____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”
Post #868765
Posted Friday, February 19, 2010 12:27 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 11:08 PM
Points: 21,230, Visits: 14,940
Nice question.



Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #868789
Posted Friday, February 19, 2010 12:31 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Monday, June 30, 2014 2:51 AM
Points: 1,972, Visits: 369
thanks for the question.. good one!
Post #868790
Posted Friday, February 19, 2010 1:25 AM
Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Saturday, March 29, 2014 11:41 AM
Points: 753, Visits: 133
Not sure if it was a browser issue but couldn't copy the script to paste into Query Analyser, anyone else have that problem?

Glen Parker
Post #868818
Posted Friday, February 19, 2010 2:30 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Today @ 4:34 AM
Points: 854, Visits: 171
Great question made me remember to re - read the question a couple of times before shouting "Errggghhhh!!!"
Post #868850
Posted Friday, February 19, 2010 3:02 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Today @ 8:38 AM
Points: 1,713, Visits: 6,249
GlenParker (2/19/2010)
Not sure if it was a browser issue but couldn't copy the script to paste into Query Analyser, anyone else have that problem?


It's an image rather than text, presumably to prevent people just copying and pasting into SSMS to find the answer - ie to make us think!

I got it right, but only because I was expecting an error that wasn't in the list*, so assumed it must be valid after all

(* I thought it would object to Colors being in the select list but not the group by)
Post #868877
Posted Friday, February 19, 2010 4:28 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 3:31 AM
Points: 1,025, Visits: 1,392
I liked it like that. It was nice to know that short of copying it letter for letter or using OCR to read the text back, everyone answering should have been answering based on how they understood it rather than because they simply ran the code themselves and put the correct answer

Thanks

Paul
Post #868930
Posted Friday, February 19, 2010 4:56 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Yesterday @ 10:34 PM
Points: 1,504, Visits: 2,528
Good question..I was confused with ans. 1 & 3, went for a toss and lost it. I give too many wrong answeres now a days..Need to be thorough with wot I learn...Questions like this remind me of that fact.

Thanks.
Post #868944
Posted Friday, February 19, 2010 7:23 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Wednesday, July 23, 2014 12:27 PM
Points: 487, Visits: 253
I like the question but more importantly I enjoyed the fact that it was an image. Forcing users to think it out.

I was a little thrown off because I thought it would come back with 4 rows. So I assumed the answer meant to say 4 rows of data returned with row 4 = 'black&white,gray'

Great question though. Here comes the debate on why some user couldn't copy the question and then answer it...
Post #869073
« Prev Topic | Next Topic »

Add to briefcase 123»»»

Permissions Expand / Collapse