I get the error

"Syntax error converting the nvarchar value 'Feed Screw' to a column of data type int"

But my field "ToolTypeDesc" is not an int, so what is going on?

ALTER PROCEDURE dbo.spDataValidation_NotEntered_Screw
(@BeginDate nvarchar(20),
@EndDate nvarchar(20))
AS SELECT dbo.T_SetupSheetHistoryProduction.QuoteID, dbo.T_SetupSheetHistoryProduction.ECN, dbo.T_SetupSheetHistoryProduction.WONum,
                      dbo.T_SetupSheetHistoryProduction.Revision, MIN(dbo.T_SetupSheetHistoryProduction.Date) AS MinDate,
                      MAX(dbo.T_SetupSheetHistoryProduction.Date) AS MaxDate, MIN(dbo.T_Tooling.ToolTypeDesc) AS [Screw?],
                      SUM(dbo.T_SetupSheetHistoryProduction.TotalSetup + dbo.T_SetupSheetHistoryProduction.TotalRun + dbo.T_SetupSheetHistoryProduction.TotalDown +
                       dbo.T_SetupSheetHistoryProduction.TotalScrapTime + dbo.T_SetupSheetHistoryProduction.TotalTearDown) AS TotTime
FROM dbo.T_SetupSheetHistoryProduction LEFT OUTER JOIN
                      dbo.T_SetupSheetHistoryToolDetail ON dbo.T_SetupSheetHistoryProduction.Revision = dbo.T_SetupSheetHistoryToolDetail.Revision AND
                      dbo.T_SetupSheetHistoryProduction.ECN = dbo.T_SetupSheetHistoryToolDetail.ECN AND
                      dbo.T_SetupSheetHistoryProduction.WONum = dbo.T_SetupSheetHistoryToolDetail.WOID AND
                      dbo.T_SetupSheetHistoryProduction.QuoteID = dbo.T_SetupSheetHistoryToolDetail.QuoteID LEFT OUTER JOIN
                      dbo.T_Tooling ON dbo.T_SetupSheetHistoryToolDetail.ActualToolID = dbo.T_Tooling.ToolID
WHERE (dbo.T_SetupSheetHistoryProduction.Date BETWEEN @BeginDate AND @EndDate) AND (dbo.T_Tooling.ToolTypeDesc LIKE N'Feed Screw')
GROUP BY dbo.T_SetupSheetHistoryProduction.QuoteID, dbo.T_SetupSheetHistoryProduction.ECN, dbo.T_SetupSheetHistoryProduction.WONum,
                      dbo.T_SetupSheetHistoryProduction.Revision
HAVING (MIN(dbo.T_Tooling.ToolTypeDesc) IS NULL) OR
                      (MIN(dbo.T_Tooling.ToolTypeDesc) = 0) AND
                      (SUM(dbo.T_SetupSheetHistoryProduction.TotalSetup + dbo.T_SetupSheetHistoryProduction.TotalRun + dbo.T_SetupSheetHistoryProduction.TotalDown +
                       dbo.T_SetupSheetHistoryProduction.TotalScrapTime + dbo.T_SetupSheetHistoryProduction.TotalTearDown) > 0)
ORDER BY dbo.T_SetupSheetHistoryProduction.WONum

__________________
Mitch

Looks like it objects to this line:
HAVING ... MIN(dbo.T_Tooling.ToolTypeDesc) = 0

That would be consistent with the error "Syntax error converting the nvarchar value 'Feed Screw' to a column of data type int"

hth
Phil

Phil, you beat me to it; I was just loging back in to update my post as say that after playing with it I dicovered that it was the Min line and not the where line.

If I take the "=0" away then it runs. Now I jsut got to see what the imnportance of the "=0" line was in the first place. (I'm converting this from an Access query)