Hi,

I implemented using functions.Anyhow Thanks a lot for spending your valuable time.

Thank you,

Regards,

Deepa.

Hi,

        Thanks a lot for your suggestion.

Regards,

Deepa.

Hi Ken,

          I'm sorry for brief summary of the requirement.

      tbl_processmetrics.

                       distributorid          selection1            selection2          selection3         selection%

                               1001               yes                      yes                      no

                                1002               yes                      no                       yes   

 I need to get the selection...

Hi,

 I've just gone with this follwing stored procedure for the above requirement specified.Might be the Query is not so efficient,its meeting the requirement.But I couldn't retrieve the records for the...

Hi,

 Can I know the logic to build upon this stored procedure?

  Thank you,

              Sincerely,

              Deepa

Hi,

 Well,I do need changes that differ from previous stored procedure.Before the stord procedure was bit straight forward.

     Now,I retrieve the CustName from Customer Table using the relation between TblCustomer and...

Hi David,

 Thats really great to note from you.Bye

          Thank you Once again.

                      Sincerely,

                       Deepa.