To be honest, I'd be happy with anything. When I worked at a for-profit, I got nothing, well, that's not true the first couple of years we got a...

Interesting editorial. I really think companies should have and enforce internet use policies. I've never worked for one that does, but I know I need to more judicious...

I'm definitely against any government regulation in this area, but I do think that an organization like PASS should develop and publish guidelines for continuing education. I'd tie that...

I don't. I can barely include a screenshot....

Good post Paul, as expected. Clear, concise, and good examples. Looking forward to part 2.

So you want to have 1 visible and 2 hidden when you click a single hyperlink? There is no way to know which one is currently visible, so I...

I think the first method is better then the second with the unions because you are only scanning the source table once. If you have to cross tab/pivot it,...

For SQL Server 2005 on XP it would be "Documents And Settings\User\Application Data\Microsoft\SQL Profiler\9.0\Templates\Microsoft SQL Server\90". Basically user templates are stored in the user profile, wherever that may be...

I think logically that Gus's query using a CTE and your query using the derived table are the same.

I think you have the best way to do this.

Based on your original query you would expect to get multiple rows per person...

I had to ask the warehouse question because it does make a difference.

Are the inserts/updates typically single row or sets?

Does the application use stored procedures or ad hoc sql?

Is this...

The issue with putting the logic in a stored procedure that is called from within a trigger is that you then need to loop through the inserted table and call...

Could you post an image of a mock-up of what you want the report to look like? I'm still not sure exactly what you want to accomplish. I...

When you say warehouse application, do you mean an application that runs a warehouse facility or a data warehouse?

It sounds like your queries are doing clustered index scans, which means...