I looked up "AT" in Windows "Help"... and they have a command that is "AT" on sterioids! It's called SCHTASKS... take a look... too much to post here...

Dear Site Owners,

Go to a look at the code for this one... appears that something was lost in this last weeks "translation" 😉

Ok... I know it's an old post... but that's COOL! I had no idea about the DOS "AT" command. Would have saved my previous company some serious heart-ache...

Zee,

The reason I asked the questions is because the solution you're so happy with (thank you for posting it) does 4 table scans... if the right indexes are present, it...

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?