I am not getting by denserank so plz help me

Thanks

Ok

'RO04381',

'RO04052',

'RO04210'

The above three values are placed in my database but i dont know the column name and Table name but i need to track these 3 values

No in excel sheet all are varchar but in table some are datetime and int and some are varchar

Thanks but

b.value column is not availabe in any table so it is throwing an error

Thanks

i used convert

now problem got solved

The datatype of the column is varchar(50)

Sorry...

Plz check now and i posted correctly