January 18, 2008 at 8:24 am
Bad news. I just ran this little in 2008:
goto MyLabel
exec sp_who
Mylabel:
It's STILL there. I'm planning on being in Seattle in November for PASS... I'll brink an Ozark Tire Thumper and we'll find the guy.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
January 18, 2008 at 8:28 am
Grant - since you "mentioned" it, does that mean you're taking a sabbatical from the boards? 😀
We'll talk to you in September!
----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?
January 18, 2008 at 8:43 am
D'oh!
Did Steve see?
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
January 20, 2008 at 9:38 pm
Hey Grant,
Thanks for your trying,
did you get any way to solve this?
Cheers!
Sandy.
--
January 20, 2008 at 11:38 pm
I still don't understand what you're trying to accomplish. Can you perhaps give some background to the story? Is it homework or just a boss who says "it must be done this way and this way only"? I'm going for option A 😀
I think you want to have one stored procedure call one or many other stored procedures based on its parameter input. Is this right? If so, what's going slow for you? Are you calling it from an application or running in SSMS? If from an application, is it being called many times or just once. What do you do in the procs - select lots of data, perform transactions, etc?
January 21, 2008 at 6:17 am
Sandy (1/20/2008)
Hey Grant,Thanks for your trying,
did you get any way to solve this?
Cheers!
Sandy.
I'm sorry, no, becuase, I think like everyone else, I still don't understand what you're trying to accomplish here.
You said you wanted to execute procedures multiple times based on a condition. That could be a recursive query (look at CTE's for the solution), a WHILE loop, IF statements, CASE statements... Other than that, I'm flummoxed.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 6 posts - 16 through 20 (of 20 total)
You must be logged in to reply to this topic. Login to reply