Are you making a stored procedure call here? I'd recommend it and then make the first line "set nocount off" and the last "set noucount on". This stops...

Get rid of the square brackets after the word constraint. So instead of "CONSTRAINT [] PRIMARY KEY CLUSTERED " have "CONSTRAINT PRIMARY KEY CLUSTERED "

Just a thought, dynamic SQL, selecting the table names into a variable and loop through the resulting set of table names excecuting the count query for each.

conceptually ...

select the table...

The key thing with a break is the length. Two weeks is the minimum you need to clear your head of work, so only the subsequent weeks ae true...

Just quickly off the top of my head, and without looking in detail at the query, have you looked at left and right joins instead of the inner join?

Give me...

I agree with jscott, the customer creates a lot of these problems. How often do you deliver a quote to add some additional fields and the customer says, "we...

Are you looking at these in an SMS grid window? If so check your settings as SMS default is to only display 255 characters so change these settings and...

Have a look at the Books link, Grant has a great free eBook on SQL server execution plans and how to read them and there's Tim Ford and Louis Davidson's...

That sounds logical if you don't want a true relational database. Remember the database engine is designed to work well with joins. When you have to keep adding...

Ok it looks like I have a work around solution that came from a previous post that works. I have done a single test and all looks good.

I did forget to mention that it was whilst running in debug mode that the problem made itself visible. I changed the connections and then ran a test on...

I'm not an expert here by any means but have you look at a data transformation task to explicitly convert the date to date time adn then use the converted...

IS there any specific reason you are using "DAY" within the datediff or did you mean to use d or dd?

You stated "with two decimal values" so its not an integer but numeric(x,2)

All the hash means is the table scope. A has means the table would only be available to the session that created it so its a temporary table.