And, if you want to make sure it's a table...

IF Object_ID('tempdb..#fred','U') IS NOT NULL

What?  You got beer?

Heh... yeah... I've run into this a couple of times my own self... most of the time, I pummeled the vendor until they provided correct data.

When all hope was lost,...

And, people wonder why I didn't spend the money to go to PASS.  S²D² if you know what I mean

Sorry it worked out...

One of the easiest and fastest ways is to dump the query results into a temp table that has a "line ID" column that is an IDENTITY column... in ACCESS,...

Or, the OP could post the offending code, sans password, so we can actually try to troubleshoot the command for him

That was the key, Serqiy... thanks ol' friend.

Hey there, Greg!  You finally made it!  Welcome to the "mosh pit"

Heh... Thanks for the nice compliment, Chris...

First off and as a bit of a side bar... you don't need the BEGIN/COMMIT pair because the default settings for SQL Server are to treat each UPDATE as an...

Peter,

Do you have an example of how to use your fine split function to find dates in a table of strings like the original OP posted?

What's the maximum number of roles?

Just curious... What does the DTS package do?

It sure would be nice if you shared what you did to solve it... this is a forum, you know?