Nice work. I don’t think I'd make it as complex, but I like it, I put in the briefcase for future reference. Thanks!

Something like this?

create table #item

(dates datetime, color varchar(50), size varchar(50), shape varchar(50), material varchar(50))

insert into #item (dates, color , size , shape , material)

select '1/1/2012','black', '50', 'sqaure', 'iron'...

The previous examples output does not change if you tweak the workstart, workend “minutes” in other words the output is the same if the workend is 2012-03-01 14:00:00 or 2012-03-01...

I like Grasshoppers idea if you sending the same email to multiple recipients. However, if you are sending a lot of emails too many recipients and the email address, subject...

Thanks!

No, we do have SMTP server we just dont have "MS Exchange Server". I send emails out of SQL all the time. I WAS TOLD that Without Exchange Server you...

Not sure if you tried this yet, but in your procedure, try using BIGINT instead of int.

Ok, that seems right. I was just told that the reason our organization does not use reporting services is because exchange server, which we do not have, is a requirement...