SELECT

ATTENZIONE al BETWEEN!

la data completa à gg/mm/aaaa 23:59:59:99

datPrest BETWEEN '" & Data1 & "' AND '" & Data2 & "' errato
datPrest BETWEEN DATEADD(d,-1,'" & Data1 & "') AND DATEADD(d,1,'" & Data2 & "')" ' errato



CONVERT(char(12),datNascita,103) as datan
CONVERT(char(12),tblChemioValTerapiePrescrizioni.datData,103) as DataPrescrizione

convert(varchar(7),datDataInizio,126) 

substring(convert(char(24),datPrestInizio,113),13,5)

convert(varchar(11),ord_date)

convert(varchar(7),datData,126) 

CONVERT(char(8),tblModelliValori.datDataIns,114)



WHERE (month(datData)='1' OR month(datData)='2' OR month(datData)='3') AND
year(datData)=@Anno



datepart(hour,datPrestInizio) as Inizio
datepart(HH,datPrestInizio) 
datepart(MI,datPrestFine) as Fine



DATEDIFF(Month,datData,datmorte) as tempo

tblPrenotazioni.datPrest BETWEEN DATEADD(d,-1,'" & Data1 & "') AND DATEADD(d,1,'" & Data2 & "')  OR DRIC BETWEEN DATEADD(d,-1,'" & Data1 & "') AND DATEADD(d,1,'" & Data2 & "') )"  



MyQuery = "BEGIN DECLARE @dtNow DATETIME SET @dtNow = GETDATE() SELECT TOP 10 * FROM [dbo].[fnStatusStats] (@dtNow, '20070501','20070530', 1, 0, 0) ORDER BY strCognomeNome, intRowIdPaziente END "

C:\COM\Com.NET.Statistiche\NuovoStatus\3 reader.aspx




<select name="Mese1">
<% for i=1 to 12
Mese=i
if i<10 then Mese="0" & i
Response.Write ("<option value=" & Mese) 
if i=MeseCorrente-1 then Response.Write (" selected ") 
Response.Write (">" & Mese & "</option>")
next
%>
</select>





procedure interessanti
-------------------------------------------------------------------------------------
Ematologia/DH.apsx