Hi Markus,

Here is the Query :

EXECUTE

msdb.dbo.sp_send_DBmail

  @Profile_name

= 'DB_Mail'

, @recipients...

Check out the SQL server Books Online Help file > Search for 'Pivot' and you will get a basic overview of what you can do with Pivots in SQL Server.

Hope...

All 563 of them?

That is a rather large package....

In response to "The FinalSQL"'s question:

Yes it is possible to pump data to multiple Tabs in a excel file.

The trick? There is none. Just simply Create Table's for each...

RGR'us & sushila,

Understood that there was no harm intended.

None done.

Remi, I just wanted to set a "boundary" before things "may" have gotten out of hand (although I am sure...

While your knowledge on the subject is undoubtedly at a high level, your ability to convey this in a condescending manner is far higher..

If you want to share your thoughts,...

RGR'us,

Thanks for the example. It really is a lot simpler than having to go through all the coding for a cursor (Although the Cursor did work too).

Much appreciated.

Please EXPLAIN how to use a set based approach, if There's just no need for a cursor in that select...

I suppose "newbie' says it all for my label.....

tx for the help...

gex

Addict,

Your cursor worked like a charm!

Ta for the example.

gex