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...

I just tested Ryan Randall's code on SQL 2005, and it appears to work just fine. Is there some issue with it?

Steve

(aka smunson)

:):):)

Sounds like you haven't populated your tally table. Try my code using the table variable and see if that helps you. You can adapt it to...

By the way, the execution time on that query, including creating the table variable with the tally numbers, was less than 1 second.

Steve

(aka smunson)

:):):)

It's too late for me to look at it today, but I'll look at it in the morning and see what I can accomplish.

EDIT: Ignore that... I just found my...

You can name it whatever you want. Just remember to edit the name as appropriate when you go in to adapt Jeff's code that references it. ...