Yes, that should work. I assume you call the SP from within another SP.

My solution has a simpler execution plan and lower query cost so it might perform faster. But of course both them work and it's your call. 🙂

IF EXISTS (SELECT * FROM table)

EXEC StoredProc

I don't know if this is going to work for you. If you displaying the data in a report you should have the report to deal with it. If you...

You can not have it like this.

Let it accept the NULL on @TermPeriodId param

Then the first thing you do in your procedure is check if value passed in matches the...

Thanks a bunch.

By the way, my compliments on the Tally thread. It has been fascinating to follow. I haven't thought of any alternatives worth adding to the thread, but it has been...

Hold a second...

This the big IF. This sp is a strange...

I am just adding my 2 cents to the discussion. I am afraid that if the sp_reset_connection is dropping all temp objects the profiler may not give you an answer...

By Murphy's law - right in the middle of the searched text....

Do you take the Prod Db offline while you doing this? Otherwise potentially any changes to the data go bye, bye.

I personally have a bit different approach.

I restore the backup...

Lowell (4/15/2009)

---

this finds any object that references a specific string...just limit it to procedures int he where statement:

DECLARE @PhraseToFind varchar(250)

SET @PhraseToFind='syscolumns'

select obj.name,obj.xtype,

case obj.xtype

when 'TR' then 'Trigger'

when 'P' then...

I am a bit worried about the sp_reset_connection executed by another app. (mentioned in the original post)

According to this: http://www.sqldev.net/misc/sp_reset_connection.htm

all temporary objects will be dropped.

So if there...

I do not know if you are using C# or VB so I used VB because I found out it is easier for C# folks to read the VB syntax...