One of the beauties of SQL is how flexible it is. You can (practically) use 'anything anywhere', with very few exceptions. Naturally, this agility also comes with responsibility - take...

When you're dealing with outer joins, it becomes very important where you place your criteria - in the ON clause or in the WHERE clause. Depending on placement, the actual...

AFAIK you can't do that. You either need to create a clean new table, or 1) add a new column with the identity property and 2) drop the old column.

Which...

There is a certain limit as how far you can 'parallellillize' it this way. In the end, you're bound to face a bottleneck somewhere. The most likely place I'd guess would...

I really doubt you would have to resort to dynamic SQL just in order to be able to mail a number of random adresses, or with a 'dynamic' mail body....

Without digging too deep into the why's of this kind of behaviour - for which there may be many reasons, ranging from source table locking behaviour to UMS scheduling for...

You're absolutely on the right track with that notion

BTW, I want people to read that link, not as an encouragment, but rather the opposite....

BOL is an essential source of information - not only occassionally, but on a daily basis. I urge you to begin using it - you won't regret it, I'm sure....

Agreed Transact SQL is fun.

Though the only way to do what you want there, is to resort to dynamic SQL, and I don't...

Sukhoi, no offense in any way, we are all beginners from the beginng, so here's some advice to you.

Open up BOL (Books On Line) and start there everytime you wonder about...

It's hard to say, you don't say what error is, or what the trigger and sproc are supposed to do.

In general, there is...

I doubt that you can use SQL Mail with hotmail as the server. I believe you need an Exchange server of you own.

/Kenneth

There is no optimized way to do pivoting in Transact SQL - if you want it to be as optimal as possible, this should be done at the client. SQL...

Could you explain a bit about why you want to do this? What kind of 'problem' will it solve for you?

/Kenneth

Well, personally, I feel that every suggestion always should be both 'reliable' and 'atomic' - what good would it be otherwise?

Assuming that what...