Viewing 15 posts - 91 through 105 (of 375 total)
Yes, that should work. I assume you call the SP from within another SP.
---------------------------------------------
[font="Verdana"]Nothing is impossible.
It is just a matter of time and money.[/font]
April 16, 2009 at 1:32 pm
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. 🙂
---------------------------------------------
[font="Verdana"]Nothing is impossible.
It is just a matter of time and money.[/font]
April 16, 2009 at 1:29 pm
IF EXISTS (SELECT * FROM table)
EXEC StoredProc
---------------------------------------------
[font="Verdana"]Nothing is impossible.
It is just a matter of time and money.[/font]
April 16, 2009 at 1:17 pm
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...
---------------------------------------------
[font="Verdana"]Nothing is impossible.
It is just a matter of time and money.[/font]
April 16, 2009 at 12:50 pm
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...
---------------------------------------------
[font="Verdana"]Nothing is impossible.
It is just a matter of time and money.[/font]
April 16, 2009 at 10:49 am
Thanks a bunch.
---------------------------------------------
[font="Verdana"]Nothing is impossible.
It is just a matter of time and money.[/font]
April 16, 2009 at 7:48 am
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...
---------------------------------------------
[font="Verdana"]Nothing is impossible.
It is just a matter of time and money.[/font]
April 16, 2009 at 7:35 am
ruchika thapa (4/15/2009)
Global temporary tables are doesn't dropped as long as session is open so how can sp_reset_connections from another application can drop global temp table?
Hold a second...
---------------------------------------------
[font="Verdana"]Nothing is impossible.
It is just a matter of time and money.[/font]
April 16, 2009 at 7:18 am
Lynn Pettis (4/15/2009)
If sys.sp_reset_connection being executed by one application is causing your global temporary table to be dropped for another application
This the big IF. This sp is a strange...
---------------------------------------------
[font="Verdana"]Nothing is impossible.
It is just a matter of time and money.[/font]
April 15, 2009 at 1:30 pm
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...
---------------------------------------------
[font="Verdana"]Nothing is impossible.
It is just a matter of time and money.[/font]
April 15, 2009 at 1:05 pm
Lowell (4/15/2009)
i wonder just where exactly they split in the code....
By Murphy's law - right in the middle of the searched text....
---------------------------------------------
[font="Verdana"]Nothing is impossible.
It is just a matter of time and money.[/font]
April 15, 2009 at 11:11 am
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...
---------------------------------------------
[font="Verdana"]Nothing is impossible.
It is just a matter of time and money.[/font]
April 15, 2009 at 11:05 am
Lowell (4/15/2009)
DECLARE @PhraseToFind varchar(250)
SET @PhraseToFind='syscolumns'
select obj.name,obj.xtype,
case obj.xtype
when 'TR' then 'Trigger'
when 'P' then...
---------------------------------------------
[font="Verdana"]Nothing is impossible.
It is just a matter of time and money.[/font]
April 15, 2009 at 10:55 am
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 are multiple...
---------------------------------------------
[font="Verdana"]Nothing is impossible.
It is just a matter of time and money.[/font]
April 15, 2009 at 9:12 am
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...
---------------------------------------------
[font="Verdana"]Nothing is impossible.
It is just a matter of time and money.[/font]
April 15, 2009 at 8:28 am
Viewing 15 posts - 91 through 105 (of 375 total)