Thank you all. You made my problem look so simple. Onca again thank you so much.

Yes, i got it. But do you think is there any other way?

thank you, that worked.

Thanks Garadin, but I need to join on Product table as I have to get few other fields like Description etc from it. For simplicity I didn’t add other fields...

Yes Garadin, I understood what you meant but I couldn’t see an other way to do it. I was thinking to create fake data and do it. But it is...

Create Table #tblSales

(CustomerNumber int, Productnumber int, Sales int, Date datetime)

Create Table...

Its not working Ken.

I tried then also its not working.

It worked for me when i changed the last part.

Select * From table

Where Case

When @NoSales...

As I couldn’t convert into separate columns, I will try in this way and I will talk to my user about it.

The same article was given my Amar, but...

Sorry, actually I posted in the wrong forum before. I didn’t find the option to delete the topic. Anyway Madhivanan helped me by giving me this article link.

http://sqlblog.com/blogs/adam_machanic/archive/2006/07/12/rowset-string-concatenation-which-method-is-best.aspx

Thank you Madhivanan, it worked.

Hi, I saw that article and tried but its not working. Its giving me null values.

Hi, I saw that article and tried but its not working. Its giving me null values.

Hi, I tried the first one but its not working. Its giving me null values. The other one I already tried but didn’t work as my database is in 2000,...