Thanks Ramesh & Matt & All :cool:,

That helped me to understand about the pivot operator and now I 'm clear 🙂

Hi Guys 🙂

Thanks for looking into my issue.

ALZDBA

...

Yes David Wasy,

                   U r right...Performance is the key issue we are facing. More peoples suggested me to index the table on...

Hello David Wasy,

Thank you for your interest in looking into my problem and helping to solve that. Actually you can see from my...

Hello Robert Cary,

The max width of the comment column is 75 and the following is the schema of the two tables

tblOrderComments (table...

Hello Robert Cary and Antares686,

  Thanx for looking into the issue. Unfortunately guys, I'm in need...

My mistake John,

                       That was solution Thanks man

Regards,

Hemant

Hi John,

          Here is the output of the query you have requested. I have taken one customer (code = 100012)

Code      DateTime                            Amount

100012 2006-04-01 00:00:00.000 162914

100012 2006-03-01 00:00:00.000 160042

100012 2006-02-02...

Hai John Mitchell,

       I tried your following query to attain the result but unfortunatly i didn't worked as expected. I took only a...

Thanx John,

That was a wonderful piece of information and i liked the way you explained and i'm convinced to...

Thanx John Mitchell and Vladan,

Sorry for not making my question clearer and i totally agree with your data type suggestions....

Thanx Philip Yale for your directions and guidance . I will look more deeply into your thoughts...

Thanx colin Leversuch-Roberts for your directions I don't know anything about this covering index but will...

Hi Chris Lockhart,

Thanx for looking into the issue

As far as no performance gain.. I'd...

Thanx Jo Pattyn for your reply

               I have tried your query and on the average of...