We value your feedback.
Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
SELECT Count(distinct W03EU999S.INXFLD03) as Volume FROM AWDPROD..W03EU999S W03EU999S inner JOIN AWDPROD..W20U999S W20U999S with (nolock) ON W03EU999S.CRDATTIM = W20U999S.CRDATTIM inner join AWDPROD..W01U999S W01U999S with (nolock) on W01U999S.CRDATTIM = W20U999S.CRDATTIM WHERE (W20U999S.ENDWRKTYPE = 'PAYOUTAPP') and (convert(datetime,convert(char(10),W03EU999S.CRDATTIM))) between convert(char(10),GETDATE()-1,120) and convert(char(10),GETDATE(),120) AND (W01U999S.DATAVALUE IN ('Prepaid','flexibond'))
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|PERFORMANCE OF SQL QUERY||13||85|
|How to query LOCK_ESCALATION||4||43|
|Updating statistics with error notification email in SQL server||4||131|
|How to resolve SQL Server DB deadlock which makes my application hangs ?||6||75|
Join the community of 500,000 technology professionals and ask your questions.