Script sql para planificación por fechas
Desarrollo de un script en lenguaje SQL , adaptado a SqlServer, que permita generar en una única consulta los registros correspondientes a una planificación en fechas, o agenda. En funciónde unas columnas de entrada y configuración, este script devolverá las fechas de la siguiente ejecución de un determinado proceso.
Resultado
SELECT Author,
NullIf(SubString(',' + Phrase + ',' , ID, CharIndex(',' , ',' + Phrase + ',' , ID) - ID) , '') AS Word
FROM Tally, Quotes
WHERE ID <= Len(',' + Phrase + ',') AND SubString(',' + Phrase + ',' , ID - 1, 1) = ','
AND CharIndex(',' ,',' + Phrase + ',' , ID) - ID > 0
select z, CAST(GETDATE()-DAY(GETDATE()) +MIN(CASE WHEN Dia>DAY(GETDATE()) THEN Dia ELSE DAY( CAST(CAST(YEAR(GETDATE()) as CHAR(4)) + RIGHT('0' +cast(MONTH(GETDATE())+1 as varchar(2)),2) + '01' as DateTime)-1) +Dia END) as Date) as FechaSiguienteEjecucion
from
(
select z, NullIf(SubString(',' + y + ',' , ID , CharIndex(',' , ',' + y + ',' , ID) -ID) , '') AS Dia
from
(select number as ID FROM master..spt_values WHERE Type = 'P' and number<200) Tally
,(select 'a' as z, '1,16,20' as y union all select 'b' as z, '10,28' as y unionall select 'c' as z, '12,14' as y) x
where ID <= Len(',' + y + ',') AND SubString(',' + y + ',' , ID - 1, 1) = ','
and CharIndex(',' , ',' + y + ',' , ID) - ID > 0
) VISTA
group by zSELECT number FROM master..spt_values WHERE Type = 'P' and number<200
select DAY( CAST(CAST(YEAR(GETDATE()) as CHAR(4)) + RIGHT('0' + cast(MONTH(GETDATE())+1 as varchar(2)),2) + '01' asDateTime)-1)
select CAST(CAST(YEAR(GETDATE()) as CHAR(4)) + RIGHT('0' + cast(MONTH(GETDATE())+1 as varchar(2)),2) + '01' as DateTime)-1
and NullIf(SubString(',' + y + ',' , ID , CharIndex(',' , ',' + y +',' , ID) - ID) , '')
>=DAY(GETDATE())
select CAST(YEAR(GETDATE()) as CHAR(4)) + RIGHT('0' + MONTH(GETDATE()),2) + '01', CAST(cast(YEAR(GETDATE()) + RIGHT('0' + cast(MONTH(GETDATE() as...
Regístrate para leer el documento completo.