Do they have the same Drive letter/name on all three nodes? Is there any Full Text indexing on this database?

Thanks for the feed back, Tony.

R. van Laake (12/15/2008)

---

I have to grab a number of salesmen's agenda's (lets say 20), that cover 30 - 60 days, and find the spots where I can add a...

Bigint is the largest data type that you can do bit-wise operations on directly and/or atomically.

I think that you've got more than one trigger there.

I agree with you Johan, it is important to remember that unlike their corresponding DDL events, DDL triggers do execute synchronously and in the source execution context. Consequently they...

Hmm, I wonder if starting a local transaction and then committing it before the trigger exited would have resolved this?

One thing that I have started to do in the last two years that I have found to be very helpful is to include test commands in the comments for...

Yeah, I always just type my tags in manually.

Michael Artz (12/15/2008)

---

ok the statement reads:

CASE WHEN dbo.Races.rSealed = 0 THEN (dbo.Results.rTime - dbo.Results.rHandicap) ELSE (dbo.Results.rTime + dbo.Results.rHandicap)

...

Yellow is the default highlight color.

priyanka.scholar (12/14/2008)

---

Is there any other soln without the use of temp tables?

I mean, can I use the SP and pass the parameters and directly use the Output columns to join...

It's pretty hard to understand what is happening to you.

Could you provide the code that you are using or some example code that can demonstrate the problem?

On SQL Server 2005 and higher, there should not be any difference between these two. However, it is unlikely that either will perform consistently well.

You could create a temporary table and then INSERT the output of the EXEC into it:

Create table #temp(

...

)

INSERT into #temp

EXEC spFubar