you can return multiple results from sp as

create sp test as

select * from a

select * from b

select * from c

.

.

Then use...

Is it not possible then, to use multiple results from a stored procedure in DTS 2000? Cant seem to properly use rs.nextrecordset.

I'll try that with a little assist from our dba to make sure to target any suspect process. I'm afraid that running on a dev box, not much activity we...

Sorry for the confusion.

I'm looking for gaps in the sequence. The ID and Code are just record fields, and I need to know if someone skipped a sequence number. I...

My Mistake.

The duplicate's orgininate in Table_A, which is ok. The fact they are getting adsigned max(price) looks right.

Thanks.

Randy.

This is bringing back dup's. The right price, but assigned for number of dates found in table B.

Thats genius.

Thanks.

Randy.

after-thought;

just update all eff_end_date with 1/1/2009 prior. Then I don't have to worry about that in the logic.

Randy.

Back to square one.

I'm pulling one of the original feeds from the archives. It appears all the other fields outside of the Key fields/summed fields are default values. I knew...

It's probably me..

There are 28 fields to be inserted. 15 fields make up primary key. Only 2 fields are summed the rest are inserted as is. Basically an hrs/wages feed...

Got It.

What was going on was that the inner select was grouped, but NOT to the lowest (single) record. In otherwords, the grouping for the payment sums was not to...

Yes.

"From Parent

Left Join child on parent.key = child.key"

However, I beleive this falls apart if you implicitly filter on the child -

" Where Child.Filed_name = value "

I never realized this until I...

It has  to do 'null' records on the child left-join. Because here I'm aggregating the values on the child records, it's throwing out the parent when no child found.

I need...

Will do. Interogating piece-by-piece. I'll either let you know what I find, or your going to see a much 'longer' post!

Found an error , running new structure....