SQL in the mean whilst

[mole999]

I am trying to resolve a problem that I have in SQL, for the meantime I need a quickish fix on the excel output

I have unique IDs, with different dates

just need a code to look at the unique and put a mark in a helper column of the earliest date. The range is about 3500, and they are all sorted on ID, with date descending

Excel Workbook
	B	C	D
1	duplicate IDs	Date	marker
2	A	01/07/2014
3	A	01/09/2013
4	A	02/06/2012	x
5	B	13/05/2029
6	B	17/02/1964	x
7	B	01/01/2009
Sheet1

Thoughts most welcome

 

[RoryA]

=IF(A2<>A3,"x","")
and fill down.

 

[mole999]

I better make sure my dates are sorted fully then (my example wasn't) just what I need though (I think)

 

[Joe4]

I am trying to resolve a problem that I have in SQL,

Do you need any help with the underlying SQL part?
I write quite a bit of SQL for my job.

 

[mole999]

I tried to PM but the code is 26000 characters longer than allowed LOL

 

[Joe4]

I tried to PM but the code is 26000 characters longer than allowed LOL

Wow! That's some long code.
Do you know, in general, what the issue is?
Or do you know the area of concern in the code?

 

[mole999]

it is basically a Rank over Partition to get a unique person, then add in some extra values and this is where i discovered the additional values are not singular, so considering a further rank wrapped round the outside to give the individual unique ID associated with the lowest value, hence the fudge in excel until I have a working example. My SQL skills are as good as my Excel (all self taught, trial and error)

 

[Joe4]

My SQL skills are as good as my Excel (all self taught, trial and error)

I think we are both in the same boat there (and Access too)!

 

[mole999]

i used to do access years back, and never knew you could join tables (trying to force data into only 256 columns when I needed more) was only discovered when i ventured into SQL. I found a way to send a fax from access, when I had been told it wasn't possible