If I used an instead of trigger, and deleted records on the table that has an instead of trigger from the instead of trigger, then the instead of trigger would...

Sorry, forgot to mention we are on SQL Server 2008 SP 3

But the good thing is, you can go live in places where it's really cheap to live, have adventures, and make the same salary you make here.

Funny, constantly learning...

I was in exactly the position that Steve describes in his blog. I took 3 years off to be with my son - 3 years that were priceless. ...

It was hard getting back in -- I had to sort of sneak in the back door, using other experience and convincing my new employer to let me do database...

My employer does not discriminate against women. Outside of the manager, the highest ranking employees in my department are women. We did have a woman manager and she...

I took a 20 year break from technology before coming back to it. I went back to school for two years before returning, and have found my colleagues are...

It's a string field in the flat file. The CTE in the stored procedure is converting the value from money to char(). If the money amount is negative,...

No, once I removed the fVoidRequestDate() function, everything (including the negative sign) flowed through just fine. The flat file is a text file, it takes whatever you give it.

I used to have problems with BETWEEN until I wrote my earliest and lastest functions. That's because the latest datetime returned by MAX(datetime_value) is 23:57 something, so any...

Yes, it must be, because I also tried substituting

AND CONVERT(varchar(10),oc.void_dtt,101) = CONVERT(varchar(10),@ExportDateString,101)

in the tvf and again, when I executed the stored procedure, I got the correct values, but...

Removing the function and using BETWEEN to check the date is working for all users. I haven't solved the mystery, but now the SSIS package is creating the correct...

Yes, but ... I'm going to try a few other things first. It'd take me a couple of hours to script it all out and I'd end up editing...

Since I'm running the SSIS package on the same machine I ran the SMS query on, I'm not thinking it's the date format, but I'll check it.