Works a charm. Thanks!

Forgot to include the updated [IsBusnessDay] for what it is worth:

WAS:

, CASE WHEN rh.[CALENDER_DATE] IS NULL THEN 1 ELSE 0...

Perfect!

I'll tailor the [IsBusinessDay] field to ignore Sat / Sun values and I'm sorted.

Thanks, Brian.

Great Post - This will save me a lot of effort !

I'm still SS2005 - The icing on the cake would be to see the ISO week calculated as well,...

Is there an RSS feed for this comic strip that I can tap into? Thanks!

Hi guys, late post but this might help someone else...

I got OPENQUERY to work with variables using the code below. The main problem I had was that I couldn't use...

Try MS-Access' Help and key in 'Open Exclusive'... It's pretty basic. When you go to open an MS-Access file you have the option to open as multi-user or 'exclusive'. The...

Try google the fault code with the text of the error you are getting, just delete your specific filename. Google is my best friend when it comes to these problems....

Has anyone documented a database that was for a Medical Device / Phara environment application and how did you achieve it? Tks.

It is a temp table I going with so will use #tmptablename (or ##tmptablename) so I'm 'good-to-go'. Thanks for the help on this one, its truely appreciated.

Now - can you...

Are the only logistial issues that I might try to drop a table that doesn't exist after SQL is (re-)started... ?

Is a good workaround to use the IF OBJECT_ID(....) IS...

This might be releated to the same original problem...

I have a stored procedure that runs fine under my (dbo) account, but gives errors from basic users where I have...

How about SeaQL?

Matt / Gialuca / Ian:

Thanks for your very prompt responses.

In particular I have looked at the two articles identified by Gialuca and Ian and though tempted by the DynamicSQL option...