|
CraigBFG -> 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
|
|
|
|
