khowpa pharmacy print

Alter proc [dbo].[Company_getCompanyDetailsforprint]
as
begin
    select companyName as mailingName,mailingName as companyName,[address] ,phone ,mobile,pan as PAN, tin as Licences,getdate() as 'Current Date',logo from tbl_Company
    --select companyName,mailingName,[address] ,phone ,mobile,pan as PAN, tin as Licences,getdate() as 'Current Date',logo from tbl_Company
end
go
Alter proc [dbo].[Company_getCompanyDetailsforpharmacy]
as
begin
    --select companyName as CompanyName,mailingName,Address,phone  ,mobile,pan as PAN, tin as Licences,getdate() as 'Current Date' from tbl_Company_ph
    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
end
go
Alter Procedure InvoicePageSettingGetForPharmacy
AS
Select * from tblinvoicePageSetting where intid=6
go