Saturday, May 11, 2019

For Start New Promotion Sale Please Execute it all server


--- Aikhane apni connect er ip likhben r ai block chalaben


GO

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER PROCEDURE [dbo].[USP_Channel_Customer_List]
@ChID INT
AS
BEGIN

if @ChID!=0
BEGIN
IF @ChID=109
BEGIN
UPDATE SYSSETTING SET Channel_POS_BILL_OLD = Channel_POS_BILL, Channel_POS_BILL = 1
SELECT PInt_ID,
Partner_ID+'_'+PartnerName+' ('+[Address]+')' [PartnerName],
ChID,
CAST(ROUND(DiscAllowed, 0, 0) AS INT) AS DiscAllowed
FROM [POSX].[dbo].[PARTNER_MASTER]Where [ChID]=@ChID
END
ELSE
BEGIN
UPDATE SYSSETTING SET Channel_POS_BILL = Channel_POS_BILL_OLD
SELECT PInt_ID,
Partner_ID+'_'+PartnerName+' ('+[Address]+')' [PartnerName],
ChID,
CAST(ROUND(DiscAllowed, 0, 0) AS INT) AS DiscAllowed
FROM [dbo].[PARTNER_MASTER]Where [ChID]=@ChID
END
--109
--[SYSSETTING]
END
ELSE if @ChID=0

BEGIN
SELECT PInt_ID,
Partner_ID+'_'+PartnerName+' ('+[Address]+')' [PartnerName],
ChID,
CAST(ROUND(DiscAllowed, 0, 0) AS INT) AS DiscAllowed
FROM [dbo].[PARTNER_MASTER]Where [ChID] not in(0)
END
END

--uporer ta chalano hole chicher ta chalaben 


--

--- Aikhane apni connect er ip likhben
ALTER TABLE dbo.BILLING_HEADER
ALTER COLUMN INVOICENO nvarchar(100)


----DONE