December 10, 2011 at 9:51 am
SQLRNNR (12/10/2011)
Revenant (12/9/2011)
Ninja's_RGR'us (12/9/2011)
Dev (12/9/2011)
crookj (12/9/2011)
WOTD - RecursiveLoop
Sounds about right 😀
As long as it is not infinite
Loop
lets have an infinte loop.
Loop.
Tom
December 10, 2011 at 9:53 am
L' Eomot Inversé (12/10/2011)
SQLRNNR (12/10/2011)
Revenant (12/9/2011)
Ninja's_RGR'us (12/9/2011)
Dev (12/9/2011)
crookj (12/9/2011)
WOTD - RecursiveLoop
Sounds about right 😀
As long as it is not infinite
Loop
lets have an infinte loop.
Loop.
To infinity and beyond
infinite loop
loop
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
December 10, 2011 at 11:21 am
SQLRNNR (12/10/2011)
L' Eomot Inversé (12/10/2011)
SQLRNNR (12/10/2011)
Revenant (12/9/2011)
Ninja's_RGR'us (12/9/2011)
Dev (12/9/2011)
crookj (12/9/2011)
WOTD - RecursiveLoop
Sounds about right 😀
As long as it is not infinite
Loop
lets have an infinte loop.
Loop.
To infinity and beyond
infinite loop
loop
Break
Kill <@@correct spid(s)>
December 11, 2011 at 4:52 am
Ninja's_RGR'us (12/10/2011)
SQLRNNR (12/10/2011)
L' Eomot Inversé (12/10/2011)
SQLRNNR (12/10/2011)
Revenant (12/9/2011)
Ninja's_RGR'us (12/9/2011)
Dev (12/9/2011)
crookj (12/9/2011)
WOTD - RecursiveLoop
Sounds about right 😀
As long as it is not infinite
Loop
lets have an infinte loop.
Loop.
To infinity and beyond
infinite loop
loop
Break
Kill <@@correct spid(s)>
If SUSER_NAME() = ‘Ninja''s_RGR''us’ OR SUSER_NAME() = ‘Remi’
BEGIN
PRINT ‘Do Nothing... Ignore’ :-P
END
Else
BEGIN
PRINT ‘Keep Looping’ :hehe:
LOOP
END
December 11, 2011 at 4:55 am
That takes dbo access, which none of y'all got on this server 😉
Proc <will always> fails DBA verification.
December 11, 2011 at 5:02 am
Ninja's_RGR'us (12/11/2011)
That takes dbo access, which none of y'all got on this server 😉Proc <will always> fails DBA verification.
I will ask Steve to run it... ROFL 😀
December 11, 2011 at 2:13 pm
Hubbard
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
December 11, 2011 at 2:22 pm
SQLRNNR (12/11/2011)
Hubbard
cupboard
Tom
December 11, 2011 at 4:29 pm
L' Eomot Inversé (12/11/2011)
SQLRNNR (12/11/2011)
Hubbardcupboard
pantry
December 11, 2011 at 7:20 pm
Revenant (12/11/2011)
L' Eomot Inversé (12/11/2011)
SQLRNNR (12/11/2011)
Hubbardcupboard
pantry
I thought Steve banned Pantry Matters from the thread - perhaps that should apply here too?
If not, pantry -> pantr -> pant -> pants
Alternatively (despite Remi): LOOP
Tom
December 12, 2011 at 8:02 am
L' Eomot Inversé (12/11/2011)
Revenant (12/11/2011)
L' Eomot Inversé (12/11/2011)
SQLRNNR (12/11/2011)
Hubbardcupboard
pantry
I thought Steve banned Pantry Matters from the thread - perhaps that should apply here too?
If not, pantry -> pantr -> pant -> pants
Alternatively (despite Remi): LOOP
To give her old (PANTINGS) dog a bone :Whistling:
+--------------------------------------------------------------------------------------+
Check out my blog at https://pianorayk.wordpress.com/
December 13, 2011 at 1:13 pm
Late
December 13, 2011 at 1:35 pm
Daniel Bowlin (12/13/2011)
Late
Better than never...
December 13, 2011 at 2:09 pm
ciao
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
December 13, 2011 at 2:37 pm
SQLRNNR (12/13/2011)
ciao
, bambino!
Viewing 15 posts - 5,581 through 5,595 (of 21,190 total)
You must be logged in to reply to this topic. Login to reply