SELECT tbl_IVR_Output_Temp.phoneno, tbl_IVR_Output_Temp.loc, tbl_IVR_Output_Temp.mrn, tbl_IVR_Output_Temp.pat_name, tbl_IVR_Output_Temp.reason,
tbl_IVR_Output_Temp.state, tbl_IVR_Output_Temp.callback, tbl_IVR_Output_Temp.Langu, tbl_IVR_Output_Temp.id1, tbl_IVR_Output_Temp.id2,
tbl_IVR_Output_Temp.id3, repeatation.month AS Expr1
FROM tbl_IVR_Output_Temp CROSS JOIN
(SELECT CAST(LEFT(SUBSTRING(loc, 2, 8), 4) + RIGHT(SUBSTRING(loc, 2, 8), 4 + '-' + '01 00:00:00' ) AS smalldatetime) AS month
FROM tbl_IVR_Output_Temp AS tbl_IVR_Output_Temp_1
WHERE (phoneno LIKE '99999%')) AS repeatation
WHERE (tbl_IVR_Output_Temp.phoneno NOT LIKE '99999%')