selvi subramanian

selvi subramanian

  • NA
  • 799
  • 574.5k

need store procedure in sql server 2008.

Aug 18 2013 3:31 AM
need to insert two table at a time and delete one table.like

after i click the button in front end 
need to insert two table at a time 

example 

table1


date 18.8.13
productname  cement
price 300

extra 10 (price+extra)=310
total=310
vat 14.5/100   (310*14.5/100)=44.95


netamount=total price+vat as 310+44.95=354.95


the total is 354.95






now table 2

have to save date,productname,price,vat,totalamount


date 18.8.13



productnamee  closeup


pricce  50

vat 14.5/100

total=price *14.5/100=57.25 rupees








Answers (4)