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

Busy Work Expand / Collapse
Author
Message
Posted Wednesday, March 31, 2010 10:17 PM
SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Friday, May 18, 2007 3:36 PM
Points: 10,039, Visits: 1
Comments posted to this topic are about the item Busy Work
Post #894400
Posted Thursday, April 1, 2010 2:01 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: Yesterday @ 8:07 AM
Points: 938, Visits: 1,142
aha! make sure "results to text" is selected

Wilfred
The best things in life are the simple things
Post #894494
Posted Thursday, April 1, 2010 6:12 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, September 15, 2011 6:06 AM
Points: 34, Visits: 30
I copied and pasted the entire contents into query analyzer but when I try to run this all I get is the following errors:

Server: Msg 156, Level 15, State 1, Line 5
Incorrect syntax near the keyword 'WITH'.
Server: Msg 170, Level 15, State 1, Line 10
Line 10: Incorrect syntax near ','.
Server: Msg 170, Level 15, State 1, Line 16
Line 16: Incorrect syntax near ','.
Server: Msg 170, Level 15, State 1, Line 42
Line 42: Incorrect syntax near 'PIVOT'.

what do I need to do to get it to run??
Post #894651
Posted Thursday, April 1, 2010 6:18 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, September 15, 2011 6:06 AM
Points: 34, Visits: 30
OK - it won't run in the query analyzer in SQL Server 2000. I was able to run it in SQL Server Management Studio.
Post #894660
Posted Thursday, April 1, 2010 6:22 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, September 11, 2014 5:43 AM
Points: 48, Visits: 203
Pretty cool, but what is it? Could it be the famous sculpture made famouse by Marie Barrone?
Post #894662
Posted Tuesday, April 6, 2010 9:47 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: Tuesday, May 7, 2013 11:00 AM
Points: 517, Visits: 209
Dennis Wagner-347763 (4/1/2010)
Pretty cool, but what is it?


It is pretty cool . It's a text representation of the Mandelbrot Set.

I ran it in SSMS, then right clicked the results to Select All & Copy. Then pasted it into Notepad (make sure Word Wrap is off). Then you can see the whole picture.
Post #897657
Posted Thursday, April 22, 2010 11:13 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: Tuesday, September 16, 2014 5:48 AM
Points: 3,241, Visits: 5,002
Cool...

----------------------------------------------------------------------------------------------------------------------------------------------------------------------

Sometimes, winning is not an issue but trying.

You can check my BLOG here

Post #909189
Posted Monday, May 3, 2010 2:01 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Monday, November 15, 2010 4:02 PM
Points: 374, Visits: 266
nigelg99 (4/6/2010)
Dennis Wagner-347763 (4/1/2010)
Pretty cool, but what is it?


It is pretty cool . It's a text representation of the Mandelbrot Set.

I ran it in SSMS, then right clicked the results to Select All & Copy. Then pasted it into Notepad (make sure Word Wrap is off). Then you can see the whole picture.


Cheers, was just running this now and was wondering if it was meant to be the Bat symbol (e.g. Batman) sideways!
Post #914519
Posted Monday, May 10, 2010 1:43 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, July 12, 2011 5:09 AM
Points: 28, Visits: 50
very coo!
Post #918846
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse