I honestly don't know the size of the data. I write stored procedures and do reports, but no DBA stuff. I'd say our volume is low because it's...

OK, I've been enlightened here. I didn't even know about Intersect, so I immediately went to BOL to read about it and Except. I can definitely use these!...

I get around this problem by putting a couple of rows at the top of my report table to hold my "header" variables or expressions. I put them above...

I resisted SN for a long time, but eventually got dragged into Facebook. I didn't do much with it for a while until an old friend starting sending me...

Thanks, Steve. I'm afraid I'm totally inept with video. My T'ai Chi instructor did those with his camera. If there's a particular one you want, I'm sure...

Wow, we can't even have alcohol on the premises here or we lose our jobs immediately.

I am on YouTube. Search for Liz Henry Richardson. I'm singing and playing...

That said, I really despise people singing when they have headphones on in the next cube. I mean, I do it... but when others do it drives me crazy. It...

I get peeved when someone is working with me at my desk and rearranges everything in Visual Studio so I have to put everything back the way I want when...

Well, once again, I've been enlightened. I've printed this article, and I bet I use it soon.

Thanks.

Hey, this is great stuff! I eagerly await the articles on using an external stylesheet and also using styles values stored in the DB.

Thank you so much for these...

I haven't yet seen Slumdog Millionaire or Gran Torino, which I've heard are great. They're on my short list.

I'm surprised that no one has mentioned Milk. This is...

Congratulations! And what a wonderful way to celebrate! Many thanks to Steve and all the great people on this site.

Hi Niraj,

Thanks for the input. I will definitely consider that for the next report, but it's too much like a complete rewrite for this one.

I'd much rather be singing:cool:

I use a query like this:

select lastname + ', ' + firstname AS EmployeeName,

EmployeeID

FROM UserProfile

UNION ALL

SELECT '*All Employees', 'ALL'

ORDER BY 1

I stick in an asterisk to make the All appear...

Oracle has better date functions. 😛