Found it. Although the view was a datetime datatype, the undelying table was changed to nvarchar. I scripted the changes from the staging db and forgot this crucial difference......

An anti join is not called explicitly with 'Anti Join' syntax. it is how you use it. Specifically, if you want all records in one table where not in...

I know I'm late to the party but here is how i would call a stored proc with parameters in vba

Sample Proc

alter procedure usp_testProc

@param1 int = NULL,

@param2 int = NULL,

@param3...

Despite the hints, it's beyond my ken. I have got round it by leaving the where clause off and not having a totals column all together. The subtle...

Jeff

I think you have not quite got what I am saying. Apologies, I didn't explain it clearly 😉

Running the code above works as you say, producing zeroes in week 49....

I have noticed if you do put the date range in the where clause, and you...

I have to admit I do not know SSIS at all! But I do know DTS, and I'm sure the equivalent steps I'm about to outline are there.

A. Turn...

I would import the file intro an empty staging table. It would then be a 3 step operation

1. Update existing rows with an inner join between destination & staging

2....

Jeff

do we not need the following in the last part of dynamic SQL?

+ 'WHERE (BusinessDate >= ''' + CONVERT(CHAR(10),@FiscalYearStartDate,101) + ''' and BusinessDate <=...

I can't agree more with all of the above, good article. I posted a reply to an how do I move to a cluster once, let me find it....

Here...

RJ (4/14/2009)

I would like to see how you can eliminate using a CURSOR or WHILE loop for sending emails using "msdb.dbo.sp_send_dbmail". My requirement would be to send email notifications to...

Cracked it, thanks to GSquared and Marks help. I noticed that Mark results differed from mine by one on 3 age groups, 41-50, 61-70 and 71-80, and frankly as...

Thanks to both of you. Marks solution is interesting as it uses a 2005/08 feature I've seen but never used. This is my first position where SQL >...

I too liked this script 🙂

I modified it a little so that any single quotes are replaced, the results are put into the last column and it prompts you for...

Aha! Many thanks Hugo....