See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.
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)
|SQL Server R2 Stored procedure make faster||7||31|
|Sql Stored Procedure||26||27|
|SQL Syntax Error subtracting two select statements.||5||14|
|How to simplify my SQL statement?||9||10|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
9 Experts available now in Live!