I want to thank everyone for there assistance.

DECLARE SALESNBR_Cursor CURSOR

FOR

SELECT DISTINCT OriginalHeaderNumber,

...

Thank you for the revised code. But the code isn't behaving correctly with the data.

I have tried various temp tables, but this is where it is tricky, which is why...

I'm using Sql Server 2005

I got the idea of converting my cursor into a CTE from this website:

http://sqlblogcasts.com/blogs/tonyrogerson/archive/2008/05/11/common-table-expressions-cte-s-how-it-works-how-recursion-works-using-with-adjacency-list.aspx

Here is my cursor logic:

DECLARE SALESNBR_Cursor CURSOR

FOR

SELECT DISTINCTOriginalHeaderNumber,

ModifiedHeaderNumber,

UseFlag,

OriginalCancellationDateid

FROM USER_STAGE.dbo.DW_REBOOK_CUSTOMER

WHERE OriginalCancellationDateid...

thank you

I have updated my code above, so that you can run it with sample code.

The creation of Tables: temp, Customer and Rebook_Customer have been added to original code above.

that code inserts 0 rows. let me put some sample data in there so you can see what I'm talking about.

i dont think something is write let me do somemore...

Would it be best not to use the temp table I created at the beginning:

INSERT INTO temp

SELECT OHNumber

,MHNumber

...

I'm not quite sure if I understand how you are combining things for the INSERTing of Process Type 1. that table doesnt have a MSalesNbr as a column

I'm still testing the code, and going thru it line by line, it's kind of tricky. When I first wrote this code I thought inner join would be the way,...

The @iMto1Flag gets set under the piece that says this:

--This is where you perform your detailed row-by-row processing.

The rest of the other insert/updates stmts are lengthy, I didn't include it...

Thank you.

I was just reading thru this thread and I have a similar issue. I'm trying to extract the number string from a StarRating of Hotels column. For example the column...