Hi Everyone I keep getting ,
MSG 241 Level 156 State 1 error: Conversion failed when converting Date and/or time
from character string when trying to print out my Dynamic SQL Query String to see
if it will print out correctly. I was curious I had quotes wrong or if my variables
for startdate and enddate which are datetime is incorrect and causing issues etc?
SET @SQLQUERY =
'
select * from
{
SELECT DISTINCT
QUOTENAME(CONCAT(YEAR(SHP.RECEIPT_DATE),''-'',FORMAT(MONTH(SHP.RECEIPT_DATE),''00''))) RECEIPT_MONTH
,QUOTENAME(CONCAT(YEAR(SHP.STATEMENT_START_DATE),''-'',FORMAT(MONTH(SHP.STATEMENT_START_DATE),''00''))) INCURRED_MONTH
,SHP.RBO_INST_ENCOUNTERS INST_ENCOUNTERS
FROM #TEMPSHP SHP
LEFT OUTER JOIN #TEMPHHR HHR ON SHP.CLAIM_HCC_ID = CLAIM_CLAIM_HCC_ID
WHERE RECEIPT_DATE BETWEEN ' + @STARTDATE + ' AND ' + @ENDDATE + ') AS BaseData
PIVOT
(SUM(INST_ENCOUNTERS)
FOR INCURRED_MONTH
IN (' + @PIVOTCOLUMN +') AS PIVOTTABLE'
PRINT @SQLQUERY
