Solved my own problem. I re-engineered the query to eliminate the need for a DELETE statement by taking that criteria into the INSERT INTO SELECT query with a...

I don't know about the evaluation order, but why are you having to use any kind of fancy calculations? If you perform your query correctly, there's no...

I have to agree with GSquared, unless you feel up to writing your own OLE DB driver... Perhaps the larger issue is the TRUE cost of continuing...

Turns out I had a small error in my script. Here's the corrected version:

SELECT CAST(YEAR([date] AS char(4)) + '_' + RIGHT('0' + LTRIM(RTRIM(CAST(MONTH([date]) AS varchar(2)))),2) AS YR_MTH,

...

I agree with Michael. Investigate "Data Driven Subscriptions", as I think that might be exactly what you need. Then you can create your letter as a...

Great that you have a solution. However, I'd like to make a couple of suggestions that might help generalize the solution, making it easier to re-use and perhaps...

Yes, actually. The OP wanted to exclude any non-date values by using a check for being a date, but was trying to do that at the same time...

Apparently... it seems we only:

SELECT SELF

INTO SKIRTS

FROM AVAILABLE_WOMEN

WHERE BODY_CHARACTERISTICS = 'DESIRABLE'

:D:D:D

P.S. perhaps "SELECT" should be read as "INFLICT"...

Just a thought, but while the application(s) are down, could the foreign key reference constraints be dropped, then the delete done, then the foreign key reference constraints be put back?...

I think the problem is the order of when things take place. If you ask SQL Server to CAST something as part of the query in which...

If that's too HARD, then just TRIGGER DELETE AFTER INSERT...

:D:D:D

Yes, but while doing one's thinking "outside", one's objective is usually to eventually find one's way "inside"...

:D:D:D

Looks like I've missed the link to the Labor Day Bloopers, as all I can find so far is this comment topic and the editorial page where it says Steve...

Just another way to approach this, but Microsoft makes a FANTASTIC migration tool for migrating Access databases to SQL Server 2005 or 2008. I've used the 2005 version,...

Sorry folks - false alarm. I just had a senior moment and forgot about a reversed sign that was needed for the comparison. Once I tried...