Breaking a SP into smaller modules

Question

Breaking a SP into smaller modules

Viewing 7 posts - 16 through 21 (of 21 total)

You must be logged in to reply to this topic. Login to reply

Jack Corbett SSC Guru Points: 184394 More actions · Answer 1

Jeff Moden (9/24/2008)
Folks, please... go back and look at the original post... the queries are identical except for the IF and the WHERE... just move the IF to the WHERE and be done with it.

Whenever someone posts generic code like in th original post I always assume they have over simplified so I try to provide an answer that will work in a more complex situation.

Hey, if the logic can be moved to the where clause with CASE or some other method great, but if not then "child" procs are the only other way to do it.

Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question

Matt Miller (4) SSC Guru Points: 124210 More actions · Answer 2

Jeff Moden (9/24/2008)
Hey MATT! Congrats on becoming a proud member of the over 5k crowd!

Is it just me or is the air thinner up here????:D

----------------------------------------------------------------------------------
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?

Jeff Moden SSC Guru Points: 1004304 More actions · Answer 3

There's air?

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Masood Ali-854067 SSC Enthusiast Points: 190 More actions · Answer 4

Create a table with queries and conditions,

Loop through the cursor and match the condition with the condition value from the table and get the query

something like

declare c cursor for

SELECTcondition,[QUERY_NAME] from dbo.table

open c

fetch next from c into @condition , @QUERYNAME

while @@fetch_status=0

BEGIN

if @yourcondition_in_code = condition

begin

select @QUERYNAME

end

FETCH NEXT

END

Dave-3000 SSCertifiable Points: 6186 More actions · Answer 5

Wait for it...

🙂

There is no "i" in team, but idiot has two.

anjali.vishwakarma Ten Centuries Points: 1112 More actions · Answer 6

Thanks for all the help Guys !! Will try to find out the best solution for my scenario...

Jeff Moden SSC Guru Points: 1004304 More actions · Answer 7

Dave (9/25/2008)
Wait for it...
🙂

Heh... too easy... not even going to bother. 😛 I just shake my head and wonder. :Whistling:

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)