----------------------------]
DEBUG
----------------------------]
<>
]
Procesar fecha: [2026-01-17]
]
Query a procesar: [ SELECT TOP 1 tur_numero
								,c.cli_tel as telefono
								,c.cli_nombre as nombre,
								c.cli_dni as doc
								,m.med_nombre AS Med
								,tt.tit_abrev AS Tit
								,DATEPART(dw,tur_fecha) as diaSemana
								,DATEPART(dd,tur_fecha) as diaFecha
								,DATEPART(mm,tur_fecha) as mesFecha
								,t.tur_hora AS Hora
								,ISNULL(t.tur_confirmado,0) as confirmado
								,t.esp_codigo as turespcod
								,(CASE WHEN espt.esp_denom IS NULL THEN '' ELSE espt.esp_denom END) as turespdenom
								,(CASE WHEN espm.esp_denom IS NULL THEN '' ELSE espm.esp_denom END) as medespdenom
						   FROM dbo.turnos as t
					 INNER JOIN dbo.clientes as c 	ON c.cli_codigo = t.cli_codigo
					 INNER JOIN dbo.medicos as m 	ON m.med_codigo = t.med_codigo
					 INNER JOIN dbo.tbl_titulos tt 	ON tt.tit_codigo = m.tit_codigo
					  LEFT JOIN dbo.especial as espt ON espt.esp_codigo = t.esp_codigo
					  LEFT JOIN dbo.especial as espm ON espm.esp_codigo = m.esp_codigo
						  WHERE t.cli_codigo > 1
						    AND t.turRecoWht = 0
							AND ISNULL(t.tur_confirmado,0) = 0
							AND FORMAT (t.tur_fecha, 'yyyy-MM-dd') = '2026-01-17'
							AND t.med_codigo NOT IN (64,88,113,121,89,74)]
]
turnos encontrados a procesar: [0]
>> TURNOS A PROCESAR[0]
 SELECT TOP 1 tur_numero
								,c.cli_tel as telefono
								,c.cli_nombre as nombre,
								c.cli_dni as doc
								,m.med_nombre AS Med
								,tt.tit_abrev AS Tit
								,DATEPART(dw,tur_fecha) as diaSemana
								,DATEPART(dd,tur_fecha) as diaFecha
								,DATEPART(mm,tur_fecha) as mesFecha
								,t.tur_hora AS Hora
								,ISNULL(t.tur_confirmado,0) as confirmado
								,t.esp_codigo as turespcod
								,(CASE WHEN espt.esp_denom IS NULL THEN '' ELSE espt.esp_denom END) as turespdenom
								,(CASE WHEN espm.esp_denom IS NULL THEN '' ELSE espm.esp_denom END) as medespdenom
						   FROM dbo.turnos as t
					 INNER JOIN dbo.clientes as c 	ON c.cli_codigo = t.cli_codigo
					 INNER JOIN dbo.medicos as m 	ON m.med_codigo = t.med_codigo
					 INNER JOIN dbo.tbl_titulos tt 	ON tt.tit_codigo = m.tit_codigo
					  LEFT JOIN dbo.especial as espt ON espt.esp_codigo = t.esp_codigo
					  LEFT JOIN dbo.especial as espm ON espm.esp_codigo = m.esp_codigo
						  WHERE t.cli_codigo > 1
						    AND t.turRecoWht = 0
							AND ISNULL(t.tur_confirmado,0) = 0
							AND FORMAT (t.tur_fecha, 'yyyy-MM-dd') = '2026-01-17'
							AND t.med_codigo NOT IN (64,88,113,121,89,74)

**************]
<>
]
Procesar fecha: [2026-01-17]
]
Query a procesar: [ SELECT TOP 1 tur_numero
								,c.cli_tel as telefono
								,c.cli_nombre as nombre,
								c.cli_dni as doc
								,m.med_nombre AS Med
								,tt.tit_abrev AS Tit
								,DATEPART(dw,tur_fecha) as diaSemana
								,DATEPART(dd,tur_fecha) as diaFecha
								,DATEPART(mm,tur_fecha) as mesFecha
								,t.tur_hora AS Hora
								,ISNULL(t.tur_confirmado,0) as confirmado
								,t.esp_codigo as turespcod
								,(CASE WHEN espt.esp_denom IS NULL THEN '' ELSE espt.esp_denom END) as turespdenom
								,(CASE WHEN espm.esp_denom IS NULL THEN '' ELSE espm.esp_denom END) as medespdenom
						   FROM dbo.turnos as t
					 INNER JOIN dbo.clientes as c 	ON c.cli_codigo = t.cli_codigo
					 INNER JOIN dbo.medicos as m 	ON m.med_codigo = t.med_codigo
					 INNER JOIN dbo.tbl_titulos tt 	ON tt.tit_codigo = m.tit_codigo
					  LEFT JOIN dbo.especial as espt ON espt.esp_codigo = t.esp_codigo
					  LEFT JOIN dbo.especial as espm ON espm.esp_codigo = m.esp_codigo
						  WHERE t.cli_codigo > 1
						    AND t.turRecoWht = 0
							AND ISNULL(t.tur_confirmado,0) = 0
							AND FORMAT (t.tur_fecha, 'yyyy-MM-dd') = '2026-01-17'
							AND t.med_codigo NOT IN (64,88,113,121,89,74)]
]
turnos encontrados a procesar: [0]
>> TURNOS A PROCESAR[0]
 SELECT TOP 1 tur_numero
								,c.cli_tel as telefono
								,c.cli_nombre as nombre,
								c.cli_dni as doc
								,m.med_nombre AS Med
								,tt.tit_abrev AS Tit
								,DATEPART(dw,tur_fecha) as diaSemana
								,DATEPART(dd,tur_fecha) as diaFecha
								,DATEPART(mm,tur_fecha) as mesFecha
								,t.tur_hora AS Hora
								,ISNULL(t.tur_confirmado,0) as confirmado
								,t.esp_codigo as turespcod
								,(CASE WHEN espt.esp_denom IS NULL THEN '' ELSE espt.esp_denom END) as turespdenom
								,(CASE WHEN espm.esp_denom IS NULL THEN '' ELSE espm.esp_denom END) as medespdenom
						   FROM dbo.turnos as t
					 INNER JOIN dbo.clientes as c 	ON c.cli_codigo = t.cli_codigo
					 INNER JOIN dbo.medicos as m 	ON m.med_codigo = t.med_codigo
					 INNER JOIN dbo.tbl_titulos tt 	ON tt.tit_codigo = m.tit_codigo
					  LEFT JOIN dbo.especial as espt ON espt.esp_codigo = t.esp_codigo
					  LEFT JOIN dbo.especial as espm ON espm.esp_codigo = m.esp_codigo
						  WHERE t.cli_codigo > 1
						    AND t.turRecoWht = 0
							AND ISNULL(t.tur_confirmado,0) = 0
							AND FORMAT (t.tur_fecha, 'yyyy-MM-dd') = '2026-01-17'
							AND t.med_codigo NOT IN (64,88,113,121,89,74)

**************]