Thanks once again. I was figuring out that and your post helped me.

I have tweaked it a bit as max is working fine for date's stored in nvarchar column

here is the final one.

SELECT DATATYPE,ISNULL(MAXNUMBER,'')+ISNULL(MAXVALUE,'')

FROM

(

SELECT

DataType,

CAST(

MAX(

CASE WHEN DataType in ('CURRENCY','NUMBER') THEN CAST(Value AS DECIMAL(18,2))

ELSE NULL END)

AS NVARCHAR(MAX)

)

AS MaxNumber,

MAX(CASE WHEN DataType NOT in ('CURRENCY','NUMBER') THEN VALUE ELSE NULL END) as MAXVALUE

FROM GetMaxValues

GROUP BY DataType

) A

Thanks,

Ravi