Craig

Thank You so very much. This is extremely close. Yes, I agree, my description of what the data needed to be coming out was not so good.

I will try again...

Thanks, but I do not need to process them in any order like that. And I do have a RowID column that is the table Pri Key column.

I need them...

Thanks Lowell

Just as I posted, I thought of something. Just script the objects in the database, and select only that one table, with data. That works perfectly.

I am always doing...

Very nice, thank you.

I appreciate that, I too am just trying to learn.

Andrew SQLDBA

Why not simply create a SSIS Package and pump the data out to an Excel Spreadsheet? It would be much easier, you can use a stored procedure to create the...

Thanks Everyone, especially Ninja

I have a couple big Ninja motorcycles, they are just wicked fast.

Andrew SQLDBA

I am not getting it, would you mind giving an example please?

It has been a rough monday already for me, and I am a little slow.

Andrew SQLDBA

Ok, I have added a ROW_Number AS refnumber to that table variable, how would I code this to use the MAX(refnumber) as the row to delete if there is a...

There are other columns involved, and the Distinct has already been used to query the data from the first table into the table variable. Unfortunately, none of the other columns...

Thanks Jeff

Andrew SQLDBA

That is perfect.

Thank You very much.

As you can see from my UserName, I am more of an Admin and not so much as a Developer. I am learning, and...

On this one, I got lucky, my SSIS package is the only thing that is performing INSERTs, so I do not have to worry too much about that.

I think the...

Thank You so very much, that works perfectly.

Andrew SQLDBA

So sorry to everyone for not posting properly. My thought was to post it that way, and I knew the answer would be very simple. But if not, I would...

i am having issues with a multi part delimiter. One delimiter "$", is at the end of the string. The other delimiter "|", separates the 8 different values so that...