Home Forums SQL Server 2008 T-SQL (SS2K8) How to sum values based on HSN codes in mssql2000 RE: How to sum values based on HSN codes in mssql2000

  • Hi friends,

    That code is working if my expected output is like below what do to

    invoiceno   cust_name invoice_docvalu      taxable_value   IGST_value               CGST_value          SGST_value    HSN
    Inv/01-1718      HH      650                             50              0                    35                         35         54
    Inv/01-1718    HH      650                               60             0                    43                            43         74

    here  i have to show summarise  value of invoice_docvalu based invoiceno