How to create a Stoerprocedure?

Question

I have two different tables 1 PurchaseMaster and 2 SalesMaster.

PurchaseMaster Columns-> Month ItemValues Tax AddTax

salesMaster columns -> Month ItemValues Tax AddTax

same columns in both table.

how to get output in repoerting service in follwing type :

ItemValues Tax AddTax

Purchase 10000.00 50 1000

sales 20000.00 10 100

Reply me Fast please

Thanking You,

Hardik Bhavsar

Priyank Khare · Answer

You can create procedure like this:- create procedure proc1 as begin select * from (select Itemvaluestaxaddtax from dbo.PurchaseMaster union select Itemvaluestaxaddtax from dbo.salesMaster ) d end then You can call this:- exec proc1

Priyank Khare · Answer

You can replace Select query with following query:- select * from ( select 'Purchse'Itemvaluestaxaddtax from dbo.PurchaseMaster union select 'Sales'Itemvaluestaxaddtax from dbo.salesMaster) From this you can get your expected result.

HARDIK BHAVSAR · Answer

But how to record diaplay in Report? i neet output in this format. Itemvalues tax addtax purchase 50000 100 10000 Sales 20000 100 20000 how it posible? Thanking You Hardik Bhavsar