How to create a Stoerprocedure?

Priyank Khare13y ago

Accepted answer

You can create procedure like this:-

create procedure proc1

as

begin

select * from

(select Itemvalues,tax,addtax from dbo.PurchaseMaster

union

select Itemvalues,tax,addtax from dbo.salesMaster ) d

end

then You can call this:-

exec proc1

Priyank Khare13y ago

You can replace Select query with following query:-

select * from

(select 'Purchse',Itemvalues,tax,addtax from dbo.PurchaseMaster

union

select 'Sales',Itemvalues,tax,addtax from dbo.salesMaster)

From this, you can get your expected result.

Hardik Bhavsar13y ago

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