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, November 10, 2014 9:37 AM
Points: 1,343, Visits: 7,187
Comments posted to this topic are about the item FOR XML PATH

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


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 2:07 AM
Points: 4,100, Visits: 5,456
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


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Today @ 12:45 PM
Points: 17,947, Visits: 15,941
Nice question.



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


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Post #868789
Posted Friday, February 19, 2010 12:31 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Sunday, November 2, 2014 11:03 PM
Points: 2,099, Visits: 371
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: Friday, November 7, 2014 8:25 AM
Points: 894, Visits: 179
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: Yesterday @ 9:26 AM
Points: 1,802, Visits: 6,571
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: Yesterday @ 10:26 AM
Points: 1,125, Visits: 1,506
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 @ 1:49 AM
Points: 1,567, Visits: 2,626
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: Friday, November 14, 2014 7:14 AM
Points: 487, Visits: 261
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