Posting same reply as in other same post..

Hi, Thanks for the replies.. yep, I've already converted MACAddr yesterday using almost the same statements that you provided. However, for the second...

Hi, Thanks for the replies.. yep, I've already converted MACAddr yesterday using almost the same statements that you provided. However, for the second part of my question, do you have...

Thanks R.Brush! I am getting the right data through the statement that you provided.

To everyone who participated (Koji, etc.), thanks also!

😉

Thanks Koji for your big help..

And yep, I've read quite a lot of articles pertaining to use of cursors especially performance-wise.

Anyways, can anyone convert the cursor statement that Koji created...

Hi Koji,

Yeah I've changed the @Source to my table name and it works! Thanks to that...

kindly explain to me what the statement is doing from the declaration of a cursor...

Hi Koji, thanks for the help! I tried it and it works.

Anyways, can you explain to me what happens in the statement that you created?

Also, in the Insert Into...

Also for APAXSG2, the 4/1/2007 - 5/1/2007 and 4/15/2007 - 6/30/2007 should be marked as one record only with date 4/1/2007 - 6/30/2007

Hi SSC Rookie!!

Thanks for the help.

The statement was a bit correct but there was a problem with the first two records...

As you see from the BEFORE screenshot, first entry for...