Hi there, I need to debug this query which is causing us problems and it's been awhile since I've written any SQL. I'll continue to hammer away at this but I'm missing some fundamental concept ...

Product Reviews Debugging SQL DevPartner DB might soon become your SQL toolbox fave. By Mike Gunderloy 12/18/2002 DevPartner DB provides a standalone environment for testing SQL Server 7.0 and 2000 ...

PHP and SQL Server can be made to get along, too, if you want to go that route, and the mssql_* functions have supported stored procedures for a long time. I generally use embedded with PHP+MySQL.