----------------------------]
DEBUG
----------------------------]
<>
]
Procesar fecha: [2026-01-16]
]
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
						   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
						  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-16'
							AND t.med_codigo NOT IN (64,88,113,121,89,74)]
]
turnos encontrados a procesar: [1]
>> TURNOS A PROCESAR[1]
 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
						   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
						  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-16'
							AND t.med_codigo NOT IN (64,88,113,121,89,74)
>>POD TOTAL[1]
]
Actualizar destinatario a procesar: [   UPDATE  dbo.turnos  SET  turRecoWht = 1,tur_RecoWhtFechaEnvio=GETDATE(),turRecoWhtRechazado=1 WHERE tur_numero = 924606]

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