yuvarajupadhyaya

LoadCustomerDetailsOnBill

Sep 11th, 2021
221
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.28 KB | None | 0 0
  1. CREATE proc LoadCustomerDetailsOnBill
  2. @invoiceNumber nvarchar(MAX)
  3. AS
  4. BEGIN
  5.  
  6. SELECT invoice_number,customer_name,customer_address,net_amount,net_discount,payment_method,paid_amount,remaining_amount,tender,CHANGE,customer_number,invoice_datetime_bs FROM BillingRecord
  7. END
  8.  
  9.  
  10.  
Advertisement
Add Comment
Please, Sign In to add comment