ofc

 select * from CommonDatabase

select * from PDXLogTable where RequestCode='0220'

SELECT MONTH(CURRENT_TIMESTAMP);

select TranDate from PDXLogTable where MONTH(TranDate)= DATEPART(month,CURRENT_TIMESTAMP);

select RequestCode,SourceMainCode from PDXLogTable where MONTH(TranDate)=MONTH(CURRENT_TIMESTAMP)

---------------------------------------------------------------------------------------------------------------------------

select left(TranDate,11) from PDXLogTable

select PPIVLumbiniBBL.dbo.f_GetLocalDate(GetDate(),2)

select left(PPIVLumbiniBBL.dbo.f_GetLocalDate(current_timestamp,2),4)

select current_timestamp

alter table PDXLogTable alter column NepaliTranDate varchar(20)

truncate Table PDXLogTable

select left(NepaliTranDate,4) from PDXLogTable

Declare

@NepaliCount int,

@PAN varchar(max),

@NepaliGetDate varchar(max)

select @PAN=4030191245789456123

select @NepaliGetDate= left(PPIVLumbiniBBL.dbo.f_GetLocalDate(current_timestamp,2),4)

select @NepaliCount=(select COUNT(*) from PDXLogTable where CardNo=@PAN and left(NepaliTranDate,4)=@NepaliGetDate and ResponseCode='00')

print(@NepaliCount)

select * from PDXOLDLogTable where Message like '%Already%'

select * from PDXOLDLogTable where RequestCode='0220'

select * from PDXBinTable

update PDXBinTable set TermChargeLoro = 8

select * from PDXTerminals

-----------------------------------------------------------------------------------------------------------------------------

---------------------------------------------------------------------------------------------------------------

USE [PWCIVLumbiniBBLSCT]

GO

DECLARE @return_value int

EXEC @return_value = [dbo].[s_PDXInfoCaller]

@MessageCode = N'0220',

@ProcessCode = N'010000',

@PAN = N'4067500031209456',

@SourceBranchCode = N'999',

@SourceMainCode = '91601201005',

@DestBranchCode = NULL,

@DestMainCode = NULL,

@TerminalId = N'VIBR0103',

@Amount = 10,

@CyCodeISO = N'524',

@RetrievalRef = N'006459652458',

@MerchantName = NULL,

@MerType = N'6011',

@Description = NULL,

@TraceNo = N'455926',

@TranDateTime = N'7874562134',

@AcquirerId = N'606098',

@IsPartial = NULL,

@OTraceNo = NULL,

@OTranDateTime = NULL,

@OMessageCode = NULL

SELECT 'Return Value' = @return_value

GO