Excellent thanks that was it!

Steve

Early versions of tables caused such odd performance problem, I developed an aversion to them. Please tell me more about the table returning functions, they seem not to have...

I agree with your second paragraph. Code reviews are helpful and knowledge of the environment is important. I even think the idea of one-off coding is correct. ...

That was my first reaction - show me the benchmark.

😎

our bi team insists on converting all dates to integers and they say they are easier to use. I as the DBA thought what you just wrote but I...

lowell the second one 20100604 as an integer over just a datetime column

advantage. Is it easier to use? Take up less space? Create better indexes?

so instead of storing '06/04/2010 14:06' as a date time or small date...

Thanks to all this is why I subscibe to learn something and I learned a lot from this article and subsequent discussion.

steve

Thanks for the reply and I would agree those constants would be a great additions!

Nice and helpful article - Thanks. Just Curious...

To select eligible candidates in the first select you say

select * from @Candidates where MeetsEligibility = convert(bit,1);

Why do you convert the...

Thanks Steve. Exactly the info I needed.

Happy New Year to you and all at SQL Central.

I'm curious why you used the data type text and not varchar(255) or a smaller value? Is there a need for very large character data and that's why text....

Is this a virtual or real server? We had some slowdowns on Virtual Servers. It is Windows 2008 SQL Server 2008 SP1.

Also, On another install that...

Beware of combining zip codes and county codes the boundaries are different. 19010 is Bryn Mawr Pa. It is located in Delaware (FIPS 42045) and Montgomery (FIPS 42091)...

Thanks for the response and some comfirmation of what I was seeing. I need to create Data driven subscription and I don't know that wizard works on web site,...