Ranish666

khowpa pharmacy print

Apr 15th, 2021
823
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. Alter proc [dbo].[Company_getCompanyDetailsforprint]  
  2. as  
  3. begin  
  4.     select companyName as mailingName,mailingName as companyName,[address] ,phone ,mobile,pan as PAN, tin as Licences,getdate() as 'Current Date',logo from tbl_Company  
  5.     --select companyName,mailingName,[address] ,phone ,mobile,pan as PAN, tin as Licences,getdate() as 'Current Date',logo from tbl_Company
  6. end
  7. go
  8. Alter proc [dbo].[Company_getCompanyDetailsforpharmacy]
  9. as
  10. begin
  11.     --select companyName as CompanyName,mailingName,Address,phone  ,mobile,pan as PAN, tin as Licences,getdate() as 'Current Date' from tbl_Company_ph
  12.     select companyName as mailingName,concat('AN UNDERTAKING OF ', phone) as CompanyName,Address as phone, mailingName as Address  ,mobile,pan as PAN, tin as Licences,getdate() as 'Current Date' from tbl_Company_ph
  13. end
  14. go
  15. Alter Procedure InvoicePageSettingGetForPharmacy  
  16. AS  
  17. Select * from tblinvoicePageSetting where intid=6
  18. go
RAW Paste Data

Adblocker detected! Please consider disabling it...

We've detected AdBlock Plus or some other adblocking software preventing Pastebin.com from fully loading.

We don't have any obnoxious sound, or popup ads, we actively block these annoying types of ads!

Please add Pastebin.com to your ad blocker whitelist or disable your adblocking software.

×