Thank you very very much. You guys save my day. I am very grateful. Thanks again.

I looked at various cross join methods but they require two tables but in my case I have only one so, are there any easy solutions for one table.

I...

Great it works! Thank you very much for your help.

I need to change only DATALENGTH in place of LEN.

Thanks again.

Your code does work well for the given example but if I change the table as below then it gives the following error.

"Argument data type text is invalid for argument...

Thank you very very much I will try this and let you know my result. Thanks again

Thank you very much. Very appreciated. From now on I will try to post as per the instruction. Thanks again

Sorry about my ignorance.

The solution query is as follow:

SELECT Item, Name, COUNT(Amt), MIN (Amt), MAX(Amt), MIN (Date), MAX (Date) FROM Table1 GROUP BY Name, Item

Thanks again.

Thank you very much I have figured it out. It was quite easy. Thanks for advice regarding datatype. now I have to work on datatype of Table1. Due to datatype...