How to sum values based on HSN codes in mssql2000

Question

How to sum values based on HSN codes in mssql2000

raghuldrag

Hall of Fame

Points: 3160
More actions
December 21, 2017 at 9:50 am

#334167

Hi Friends,
I have a created one sample table and inserted some sample rows here
create table ram ( invoiceno varchar(20), cust_name varchar(20), invoice_docvalu number(10,2), taxable_value number(5,2), IGST_value number(5,2), CGST_value number(5,2), SGST_VALUE number(5,2), HSN varchar(20) )
insert into ram values ('Inv/01-1718','HH','180','32',0,'21.6','21.6','74') insert into ram values ('Inv/01-1718','HH','170','28',0,'20.4','20.4','74')
insert into ram values ('Inv/01-1718','HH','140','30',0,'16.8','16.8','54')
insert into ram values ('Inv/01-1718','HH','160','20',0,'18.8','18.8','54')
Expected Output is
Based on this hsn code i Have to display summarise value of invoice_docval,IGST_Value,SGST_Value,CGST_Value ,Taxable_value
Kindly Give suggestion

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 1

raghuldrag - Thursday, December 21, 2017 9:50 AM
Hi Friends,
I have a created one sample table and inserted some sample rows here
create table ram ( invoiceno varchar(20), cust_name varchar(20), invoice_docvalu number(10,2), taxable_value number(5,2), IGST_value number(5,2), CGST_value number(5,2), SGST_VALUE number(5,2), HSN varchar(20) )
insert into ram values ('Inv/01-1718','HH','180','32',0,'21.6','21.6','74') insert into ram values ('Inv/01-1718','HH','170','28',0,'20.4','20.4','74')
insert into ram values ('Inv/01-1718','HH','140','30',0,'16.8','16.8','54')
insert into ram values ('Inv/01-1718','HH','160','20',0,'18.8','18.8','54')
Expected Output is
Based on this hsn code i Have to display summarise value of invoice_docval,IGST_Value,SGST_Value,CGST_Value ,Taxable_value
Kindly Give suggestion

Based on the sample data what will the output look like.

raghuldrag Hall of Fame Points: 3160 More actions · Answer 2

my expected output is

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

Based on HSN code i have summarise

J Livingston SQL SSC Guru Points: 51550 More actions · Answer 3

use SUM with GROUP BY invoiceno, cust_name,HSN

________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 4

I agree, that's why I wanted to see the expected results.

raghuldrag Hall of Fame Points: 3160 More actions · Answer 5

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

John Mitchell-245523 SSC Guru Points: 148809 More actions · Answer 6

I don't remember "number" being a data type in SQL Server 2000. Is that really what you're using? If it is, please post correct table DDL.

raghuldrag - Thursday, December 21, 2017 9:40 PM
That code is working if my expected output is like below what do to

What code is that? Please post the query you have tried, so that we can show you where you're going wrong.

John

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 7

raghuldrag - Thursday, December 21, 2017 9:40 PM
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

What?

aaron.reese SSChampion Points: 13498 More actions · Answer 8

@rahoul
How have you managed to accumulate 1234 points on your profile when you can't even SUM and GROUP BY?

We are all for helping newbies and intermediate data wranglers but this worries me 🙁