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 «««1234

GO Part 1 Expand / Collapse
Author
Message
Posted Friday, September 7, 2012 5:38 PM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 1:11 PM
Points: 4,322, Visits: 3,509
This is a good one - ending the week on a high note. Thanks, Kenneth!
Post #1356304
Posted Saturday, September 8, 2012 7:59 PM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Thursday, March 26, 2015 2:47 AM
Points: 9,928, Visits: 11,242
Good question, thanks Kenneth.



Paul White
SQLPerformance.com
SQLblog.com
@SQL_Kiwi
Post #1356438
Posted Sunday, September 9, 2012 2:04 PM


SSC Eights!

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

Group: General Forum Members
Last Login: Wednesday, January 28, 2015 3:16 AM
Points: 955, Visits: 1,512
Richard Warr (9/7/2012)
I looked at the first option and was disappointed that the second one wasn't
Collect $200 for parsing GO.




Loved the question BTW. No catch, just expected behavior.


Best regards,

Andre Guerreiro Neto

Database Analyst
http://www.softplan.com.br
MCITPx1/MCTSx2/MCSE/MCSA
Post #1356505
Posted Monday, September 10, 2012 9:17 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Thursday, March 26, 2015 5:10 AM
Points: 571, Visits: 382
good question, caught me out!
Post #1356818
Posted Wednesday, September 12, 2012 5:38 PM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Wednesday, January 14, 2015 12:24 PM
Points: 582, Visits: 454
The benefit of replying a few days later and fully caffeinated. :D

Even so, I almost missed the INSERT ... SELECT part.

Fun question, and yes, a helpful technique for populating tables with large amounts of test data.
Post #1358270
Posted Tuesday, September 18, 2012 12:40 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, March 12, 2015 7:24 AM
Points: 316, Visits: 185
Damn!
Got the go part right, but didn't read the select closely enough.
But good to remember this way to create an exponentially rising number of records in a hurry.

Thank you for the question.
Post #1360580
Posted Tuesday, September 18, 2012 5:38 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: Tuesday, February 10, 2015 3:19 AM
Points: 763, Visits: 523
Great question thanks.

"Be brave. Take risks. Nothing can substitute experience."
Post #1360703
Posted Saturday, September 29, 2012 1:36 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Friday, March 20, 2015 4:43 PM
Points: 2,784, Visits: 805
Nice that you can't "GO" in a T-SQL statement. What a nightmare that would be for anyone trying to avoid SQL Injection issues.

Jamie
Post #1366212
Posted Friday, February 6, 2015 8:47 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Thursday, March 26, 2015 6:55 AM
Points: 252, Visits: 164
Sorry, but i got this error:

Server: Msg 170, Level 15, State 1, Line 3
Line 3: Incorrect syntax near '5'.

I`m using Query Analyzer
Post #1658400
Posted Friday, February 6, 2015 9:21 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 8:54 AM
Points: 13,751, Visits: 13,338
lcajui (2/6/2015)
Sorry, but i got this error:

Server: Msg 170, Level 15, State 1, Line 3
Line 3: Incorrect syntax near '5'.

I`m using Query Analyzer


Notice this question is nearly 3 years old. When you don't offer anything other than "I got an error" it doesn't really help much in the discussion. Are you really using Query Analyzer...as in sql 2000??? IIRC that didn't work in 2000.


_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Moden's splitter.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs
Understanding and Using APPLY (Part 1)
Understanding and Using APPLY (Part 2)
Post #1658421
« Prev Topic | Next Topic »

Add to briefcase «««1234

Permissions Expand / Collapse