Jeff's SQL Server Blog

Random Thoughts & Cartesian Products with Microsoft SQL Server
posts - 138, comments - 1711, trackbacks - 64

My Links

SQLTeam.com Links

News

Welcome to my weblog. My name is Jeff Smith, and I am a software developer in Boston, MA. Check in frequently for tips, tricks, commentary and ideas on SQL Server and .NET programming.


Subscribe





Archives

Post Categories

Programming

Sports

SQL

ASP

Old-School ASP. Don't expect to see much new stuff here, but if you are still using ASP there's a handy "ReportClass" that you may find useful.
ASP and ADO Pivots -- Old School CrossTabs

Jumping back a bit, I thought I'd also post a bit of code for those still using good old ASP and/or ADO. This is a function writen in VBScript that works much in the same way as the GetRows() method of an ADO recordset -- it returns the entire contents of the recordset in a 2-dimensional array. The difference with this one, of course, is that it will also do a pivot for you.

posted @ Sunday, May 15, 2005 9:26 PM | Feedback (2)

ASP Report Class Northwind Sample

posted @ Thursday, November 20, 2003 5:22 PM | Feedback (4)

ASP - Report Class with Grouping, Headers, Footers and more

If you use ASP, ADO and SQL Server, check out my new article. It includes code for a VBScript class which makes writing HTML reports based on an ADO recordset with group headers, footers, and subtotals extremely easy.

read more...

posted @ Monday, November 17, 2003 1:36 PM | Feedback (1)

Powered by: