Case sensitive server?

Compatibility level maybe?

Only the order by can apply to the unioned set without using a derived table.

SELECT COUNT(*) FROM (

Select name from sys.columns where name like '%e%'

UNION ALL

SELECT name from sys.tables where...

Almost impossible to write with efficient query. More to the point, no a job to do in sql server.

Just grab everything and manage that in the presentation layer.

calvo (5/4/2011)

I don't really care one way or the other. I was just hoping someone would have some super inside knowledge of the English language and would be able to...

timestamp is NOT a datetime. Yes, bad choice for type name.

timestamp is a binary that can be converted to date but it has no date meaning... you just...

yes it is.

I think you should both get over yourselves and stop trying to be right... but I'm just an outside observer :hehe:.

Just my 0.02$

No need to cross join.

make a list of all years / months in your date range. I personnally use a calendar table and a Years/months tables as well.

Then in...

That's a nice one too.

http://www.sqlservercentral.com/articles/Stairway+Series/72464/

You know there's a search button top right on this page...

http://www.sqlservercentral.com/articles/SQL+Server+2005/64547/

No, the missing where in the first query will give different results... and performance is never an issue with wrong results :w00t:.

Check the default trace. (nice articles here on the subject).

What culture is he from?

I personnally wouldn't be offended... but I'm from around here :-D.

Actually a FK might actually help, but I can't confirm without seeing the queries!

Ok final version for today

Added more instructions, better reporting and removed noise in the script and output.

Note the self commenting column names in the output script so that a real...