First, you probably don't need a cursor. Just based on your original post, however, there isn't much we can do to help.

First, I'd like to suggest that you read...

I'm sorry, but I really can't follow what your are asking or what you are trying to accomplish. Nothing in your post really makes any sense to me. ...

Flo...

Since there was no production problem I had, after this input I could show my chief some really great new things and it causes that some parts of our applications...

twdavis (4/27/2009)

---

First it does not matter if this is peoplesoft are not we are not writing this in peoplesoft query.

what I am looking for.

each load(LOAD_ID) has multiple stops (TMS_EXT_REF_ID) now...

JJ B (4/27/2009)

---

the vendor has designed their application to force a row-by-row approach because they don't know any better. So as you say, you don't really have a choice other...

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...