Thank you for your suggestion.

Gillian

Thanks for your help. I did see that before. And I just can't quite find out how to make it work because it also affects my grouping....

Thank you Keith. You're awsome. Now I can build my BIDS without hiccups. Thanks so very, very much.

G

Hi Keith.

Thanks for the information. I have to keep that update in my stored procedure and have it run when BIDs runs. But it will make the Bids...

Hi Chris.

I have another question. The update works great, thank you, but is there anyway I can use no echo or something so that this result isn't returned to...

Thank you so very much Chris for your help. You are awesome.

G

Thank you very much, I will give that a try right now. I really appreciate your help and quick response.

G

Thank you so very much. For some reason when I moved everything from the #temp table over to a @temp table and applied your logic....

;WITH cte as

(

SELECT *,

ROW_NUMBER() OVER(PARTITION...

Yes, I was try to remove duplicates based on Co_num. Thank you.

Thank you.

I must not be having good luck today. I've added it as a docx, and a .txt

My posts look fine in preview then get messed up when I post it. Sorry. I have included an attachment.

Thanks for all of your help.

For some reason, my preview looks good but when I post it, everything looks garbled.

I've sent an attachment. Thank you.

Thank you so much. That worked really well, but for some reason, there remain a few randon duplicate co_nums rows showing up. But I truly appreciate your help....

Thanks very much Jeff. I appreciate all of your help.

Gillian