Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.
i=1 do while i<=12 sql2013 = "SELECT Count(ID) AS CountID FROM Compliments where year("OccDate")='2013' and month("OccDate")=i" Set rs2013 = conn.Execute(sql2013) compliments= rs2013("CountID") response.write MonthName(i) & rs2013("CountID") i=i+1 loop j=1 do while j<=12 sql2014 = "SELECT Count(ID) AS CountID FROM Compliments where year("OccDate")='2014' and month("OccDate")=j" Set rs2014 = conn.Execute(sql2014) compliments= rs2014("CountID") response.write MonthName(i) & rs2014("CountID") j=j+1 loop
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|SQL: Pulling all records from one table using join data from 2 other tables||5||42|
|SQL Convert rows to columns||5||33|
|How to sort columns on a continuous form populated by resetting the recordet, as when a recordset is returned from a stored procedure?||5||48|
|Creating Scalar Function||3||17|
Join the community of 500,000 technology professionals and ask your questions.