If you MUST use the table structure defined above then you'll need something to define a unique record (PK)

I've added it for demonstration purposes.

DECLARE @CH TABLE

(nDex...

Please post what you've tried already. 🙂

Only a slight bit more "bulky" ...

DECLARE @test-2 TABLE

(

id INT IDENTITY(1, 1),

string_with_date VARCHAR(100)

...

I would suggest, use UNPIVOT in your query/proc along with your normal data collection to add in the string combination of your values. Search this site, there are many examples....

You mean you don't work on the same issue for...

I know this is NOT addressing your problem, but in case you didn't already know about this nifty tool from MS. If you're just planning on synching them once in...

A Soft Delete would be the case if your records had a column that defined the state of the record. i.e. an isActive bit column or an endDate column. Something...

M10.May10_Ad4 is repeated twice?

Krasavita

Please check the article linked in my signature to get better responses from user on this site.

Please define "Not Working Properly"

That really depends on your system. Do you have the ability to "soft delete" or mark records inactive. How are these records tied to other data? Will you be creating...

Pardon me for stepping in here, but going directly to '08 is a bigger can of worms than going to SP4. :hehe:

EDIT: Not that it's a bad idea, just more...

Try this 🙂

Since you want columns not included in the MIN function, you'll need to use a subquery to get those min values by material ID then join to that to get...

bopeavy (7/19/2011)

---

opc.three

That at least helps give some sort of direction, Thanks.

@jason

It may have but what opc provide will help me see the pattern yours was alittle...

Am I wrong or doesn't my "solution" above find these patterns?