I have a co-worker who is also a professional musician. He sent out a Christmas Song this year. You can find this song here

I'm not a musician, but my co-worker is also a professional musician. Here is a Christmas Gift song he sent out this year. If you like that song,...

Please read the first article I have referenced in my signature block below regarding asking for assistance. Please follow the instructions for posting code and sample data. You...

Probably, but then how would you learn how to do it if we do it for you? Give it a try first, and as you have problems, ask for...

I'b build a clustered index. You may want to analyze the usage on the table. There may be a useful index that may benefit from being a clustered...

Not sure if this is relavent, but an INDEX scan on a clustered index is a table scan.

Lookup xp_logininfo in BOL (Books Online).

The balance may be a rolling balance, but if you...

Magy (12/15/2009)

---

But it didn't order the data according to my ORDER BY clause...that's why I'm confused.

When I run the cursor, and then check the table, it is not...

Also, Jeff asked a question in the other thread that you still should answer.

What you may need to do is write quesries that recalc the balances as of a certain...

It depends.

Also, remember that, if for any reason, you have to restore the database you will have to drop all your snapshots.

one-1016367 (12/15/2009)

---

Nope, no table variables. I'm not at work at the moment, and I didn't write the stored procedure myself so I don't remember the details. I'll paste the...

When initially created, it will be empty. It will start occupying space as your database is updated as it needs to retain a copy of the data as it...

Totally Cute!!

Spot On!!