It depends.

What if there are ties? Do you want the fifth record, even if there are five ties for highest?

Two questions:

1. How many tables are you adding triggers to? Dozens? Hundreds? Five?

2. Why a "generic" trigger? Why not a specific trigger per table?

I've found Unpivot useful for normalizing data out of spreadsheets and such. Pivot, so far as I can tell, has negative value.

Generally speaking, SQL Server uses tempdb instead of the page file.

Are both servers on the same service pack/update level?

Insert all of your data into temp tables. Return them at the end of the Try block. You won't reach that if you end up in the Catch...

It's not a bug in SQL Server. It's a network issue.

If they don't resolve the problem, let me know, and I'll gladly clarify them for you.

Chad Crawford (7/18/2008)

---

Sounds to me like they've just placed it outside the firewall. Although this does make it visible everywhere, it also... well... makes it visible everywhere. I'd...

A) The forum can take attachments.

B) If you click my name in the forum (where it says, "GSquared" above and to the left of my posts), there's an option to...

Create a dev/test copy of your database, change the compatibility level to 90, then run this on it:

use [database] -- Please remember to fill this in!!

go

dbcc UPDATEUSAGE (0) WITH...

You can avoid creating one, but I recommend creating one. Highly recommend it....

Excel, like SQL, stores dates and times as integers (dates) and decimals (time).

For example, right now, on my computer, getdate() = 39645.66645625

That's the number of days and the number of...

Well, I hadn't played with that, so I tested it.

declare @NV nvarchar(max), @V varchar(max)

select @NV = NChar(0641), @V = 'a'

select @NV, @V

select @NV = @NV + @V

select @NV

The result of...

The nested Case statements might also be a minor problem. Look at changing to a complex Case with multiple conditions instead of multiple nested Cases.

Try this, see if it...