Access to SQLServer SQL problem

	Home Register Search Help Login

Sponsors

Shopping Cart Software
Ecommerce software integrated into Frontpage, Dreamweaver and Golive templates. No monthly fees and available in ASP and PHP versions.

Website Templates
We also have a wide selection of Dreamweaver, Expression Web and Frontpage templates as well as webmaster tools and CSS layouts.

Frontpage website templates
Creative Website Templates for FrontPage, Dreamweaver, Flash, SwishMax

Search Forums

Recent Posts

Todays Posts
Most Active posts
Posts since last visit
My Recent Posts
Mark posts read

Access to SQLServer SQL problem

View related threads: (in this forum | in all forums)

Logged in as: Guest

Users viewing this topic: none

Printable Version

All Forums >> Web Development >> ASP and Database >> Access to SQLServer SQL problem

Page: [1]


CraigBFG Posts: 211 Joined: 7/25/2003 From: UK Status: offline	Access to SQLServer SQL problem - 9/12/2005 6:47:58 Hi all I'm migrating a web app from Access to SQL as a backend, but I've hit a snag. I have a query which shows : Category, total number of jobs against that category and total number which have been closed against the category - all on the same line. My Access SQL query works fine, but SQL Server doesn't like it. Can anyone please assist. The part in question is : SELECT tblDefCat.DefCat, Count(tblDefect.DefID) AS Total, Sum(Right([Status]='closed',1)) AS QClosed