Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.
Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.
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)
|Using SQL Server 2008, why do I get the following error 'Explicit value must be specified for identity column in table 'tbl_CSL_CSLRpts' either when IDENTITY_INSERT is set to ON or when ?||8||39|
|Please help with the below query - SQL Server||11||28|
|RESTORE DATABASE -- same name, same files physical and logical -- the files cannot be overwritten||9||26|
|Master DB with Masterkey||1||34|