greatheep (4/27/2009)

---

So, I have to agree with some of the thoughts I've seen on the board - namely, so far, the article(s) have not shown a case where I would...

Jack Corbett (4/27/2009)

---

If I understand you correctly, which I'm not sure I do, I think this query will work:

SELECT DISTINCT

A.BUSINESS_UNIT,

A.LOAD_ID,

...

Scott Roberts (4/27/2009)

---

Lynn Pettis (4/27/2009)

---

As stated in later posts, i personally think there is more to the DEDUPE requirements, and based on the what the OP provided, we both have...

Run this and let us know the values for size.

use [tempdb]

go

select * from sys.database_files

select * from sys.master_files where database_id = 2

go

I don't think so. I think we are just confusing each other.

If you are talking about the trivial data,...

Scott Roberts (4/27/2009)

---

Thank you both very much for your solutions. I will definitely give both of them a try on larger data samples.

As for row sequencing, is it not invalid...

Try running this query and see what is out there in tempdb:

select * from tempdb.sys.all_objects

where is_ms_shipped = 0;

Bob Hovious (4/27/2009)

---

I provided the trivial data, but mine still works if they aren't in sequence. That was omitted from the original specs, so I didn't want...

Bob Hovious (4/27/2009)

---

I provided the trivial data, but mine still works if they aren't in sequence. That was omitted from the original specs, so I didn't want...

If you modify the clustered index to include the BILLED flag as DESC, the code will once again work.

/****** Object: Table [dbo].[CallDetailRecords] Script Date: 04/27/2009 12:10:02...

Made a simple change to the data and broke my own code. This requires additional information regarding he requirements. If the data is inserted as specified by the...

Scott Roberts (4/27/2009)

---

Actually, it doesn't.

Check your results against the "expected results" in post...

Actually, its broke, something was missing. Ignore the current code, i need to rework it a bit.

Possibly, but based on the trivial data, table structure, and expected results provided, it...

How about this?

EDIT: Code posted here was removed as it failed!

I noticed that your table def had RawData defined as varchar(5000) but your cursor function had it defined as varchar(300)....