Yes, it can be done pretty easily...

When you open the table in EM, instead of selecting all rows, tell it to select the TOP 1. Makes the "end" you're...

You can certainly loop if you want... but let's try to avoid that in a relational database if we can. 😉

You say you want the top 6 transactions for each...

Yep... it does depend... but indexing on INT will be faster than just about anything else including SmallInt and TinyInt because of the way the operating/disk systems work... INT is...

Uh huh... who fixes the auditing system if it breaks or causes any performance problems? 😉 And who's going to do all the other checking you suggested when...

In other words, the following works...

CREATE TABLE #MyHead

(

ColA INT, ColB INT, ColC INT

)

CREATE...

I agree... now's the perfect time to begin exploring Books Online... and when someone gives you a hint like what Serqiy did, don't just stop at the hint... look for...

Heh... they won't be able to keep the appointment for the interview because their dates will be all haywire...

Actually, it's worse than nothing... leads folks into a false sense of security even though their data is flapping in the breeze 😉

Heh... yeah... please, hire me before you install it as a trigger 😉

Like what?

And, Yes, I know that inserting into the "middle" of a clustered index may not cause data movement right then, but it does take extra time to do the...

Hi there, ol' friend...

Just a quick question... how would you use your fine function to split a whole table of data... or is that beyond the scope of the code?

Zee,

Couple of questions... trying to help a bit, if needed...

First, how long does it take your final code (thank you for posting it) to run on all of those rows?...

You can't... you would be sending unencrypted data over the wire. Defeats one of the two purposes of encryption altogether.

More generally the question is "when does a transaction end"? When the triggers on Table A are done processing or when all triggers on all tables touched by the insert...

Sheeeooottt... what I'm really amazed at is how many people ask for help, get it, use an answer to write a fix, and then don't share. :exclamation: I know...