How do I translate this into SQL Server:
select
-Sum((12=[GroupNum])*[BoardStatus]) AS G12
FROM
QryAllBoardsByPacketIDs
INNER JOIN
tBsReportGroups
ON QryAllBoardsByPacketIDs.NominalLengthMetric=tBsReportGroups.NomLenMet
GROUP BY
QryAllBoardsByPacketIDs.ParentPacketID,
QryAllBoardsByPacketIDs.GradeID,
QryAllBoardsByPacketIDs.NominalWidthMetric,
QryAllBoardsByPacketIDs.NominalThicknessMetric;
Kind regards,
Martin
(12=[GroupNum])*[BoardStatus]
. It looks like you are summing all rows whereGroupNum
is12
. If that is a case then you could usesum(BoardStatus)
and add a where clausewhere GroupNum = 12
. – Mikael Eriksson Jun 18 '14 at 5:21