Reusing code

[againstTheWind]

I have a query that I will have to reuse several times and I am wondering what the most elegant way to do this usually is - perhaps declaring a variable to store the SELECT statement?

If so, how would I use this variable?

Thanks!

 

[jbenson001]

Put the query inside of a stored procedure.

Jim

 

[againstTheWind]

Jim - thanks for the suggestion. I was hoping more for something like declaring a variable for the SELECT statement and then using it a few times. The code isn't long enough to make a stored procedure.

Any suggestions?

Thanks!

 

[NathanGriffiths]

There is no minimum length requirement for stored procedures. The fact that you need to reuse the code is enough. You could also consider a user defined function.

Otherwise you are looking at storing the sql in a variable and using EXECUTE or sp_executesql to run it as required.

 

[againstTheWind]

I'm not an administrator on this specific server so I think that leaves creating a stored procedure out.

Any other ideas?

 

[jbenson001]

Did you try creating a stored procedure?

 

[againstTheWind]

Ok - it worked and I feel a bit stupid. Thanks for the help guys!

 

[yetanotherjo]

Don't feel stupid, againstTheWind - you learned something. Stupid people don't ask questions and don't learn.