Viewing 13 posts - 1 through 13 (of 13 total)
I want to thank everyone for there assistance.
August 5, 2008 at 1:27 pm
DECLARE SALESNBR_Cursor CURSOR
SELECT DISTINCT OriginalHeaderNumber,
August 5, 2008 at 12:31 pm
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...
August 4, 2008 at 2:24 pm
I'm using Sql Server 2005
I got the idea of converting my cursor into a CTE from this website:
Here is my cursor logic:
August 1, 2008 at 7:53 am
July 23, 2008 at 8:43 am
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.
May 31, 2008 at 12:52 pm
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...
May 30, 2008 at 9:37 am
Would it be best not to use the temp table I created at the beginning:
INSERT INTO temp
May 30, 2008 at 8:57 am
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
May 30, 2008 at 8:47 am
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,...
May 29, 2008 at 3:19 pm
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...
May 29, 2008 at 12:20 pm
November 15, 2007 at 8:23 pm
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...
November 15, 2007 at 1:22 pm