Hey-O

I got Luis suggestion first and implemented it and it worked like a charm! Since my rows are interspersed I tried it on my larger data set and used a...

No worries people. I just many times like to make sure something is true before I add it to my knowledge. We are on good terms but the...

I see what you are saying now.

Makes sense to me. I just didn't understand what the advantage is but it is catching it within the loop so...

Yes that is it.

I just don't see the benefit in doing it and it adds to code complexity.

Oh and before anyone asks This is a fairly complicated grouping issue I am workin on and even with the nested cursor the query time is single digit miliseconds with...

My Senior DBA who reviews my code. I just wanted to know if it was true or not. I need to follow the sr. DBA standard but wanted...

Well it took an act of God for to get a sequence number on one particular table and we were depending on BCP to keep the data in the correct...

yes we have the order by statements. Not sure why the reluctance other than in the past the other non dba developer relied on static data to be in...

I have the same problem. If I find a resolution I will let you know.

SwePeso knocked it out of the park. Good work. I learned something. I will certainly add cross apply to my tool kit and I am a huge...

how about no overlapping date ranges and no nested date ranges

so for example if I was looking for CRATES for 07/01/2001 and I wanted to select * from @overlap where...

I should have said overlapping ranges. You can't have a date range of rates that overlap another date range of rates with the same infoname

make sense?

ARATES

BRATES

CRATES

I completely appreciate all the responses. SSCertifiables approach will resolve my issue completely. The codes I could range from are always in three possible formats

4 numerals and...

Thanks to everyone. I need to read and digest what you wrote and I will let you know what approach I take.

To answer the question the codes are not...