Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.
Somewhere in the data there is null value for the entered field and so its returning no data,but if I comment the where condition on the entered field its returning data.How to handle this?
SELECT 'VA', CONVERT(char(10),Entered,101),COUNT(RXNO) FROM HRXS WHERE -- AND NewRx=1 AND PharmID ='VA' and TransType not in('Q','B') and (CCType IS NULL OR CCType ='C') and Entered is not null and CONVERT(char(10),Entered,101) between CONVERT(char(10),GETDATE()-31,101) and CONVERT(char(10),GETDATE(),101) GROUP BY CONVERT(char(10),Entered,101)
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.