I have wrote my own stored procedures for various reasons and the development staff here has used them.  They are very rude and crude (not a graphical display) but they...

Surprisingly enough, I'm disappointed in the pay offered in "my" preferred regions which include the Rockies.  The mere mention of the cost of living differences between potential job locations and...

If my memory serves me well, this topic was about parameter sniffing.  You asked for an example of my method which I provided.  Oddly enough "its not good enoough" .......

OK, I've simplified this for purposes of length...don't wanna bore anyone.

First create the stored procedure that will create and execute another stored procedure.  This...

I have used a method to pass parameters to a stored procedure which in turn dynamically creates another (Static) stored procedure from which I run to obtain my results.  The...