beercat2
asked on
ALTER VIEW/Stored Procedure Problem
I'm getting a "Syntax Error Near Keyword View" Error when I check the syntax of this Stored Procedure. Can anyone tell me why? Thank you so much!
Brian
CREATE PROCEDURE spGenerateReportData
@StartTimeWindow DATETIME,
@EndTimeWindow DATETIME,
@Line varChar,
@LineStatus varChar,
@CauseType varChar,
@Shift varChar,
@Team varChar,
@Lot varChar,
@Product varChar
AS
BEGIN
IF EXISTS (SELECT NAME FROM objSystems WHERE NAME = 'qrySearchCriteria1')
ALTER VIEW qrySearchCriteria1 (Process_Area, Machine, Unit_Op, Auto_Cause, Occurrences)
AS
SELECT Process_Area, Machine, Unit_Op, Auto_Cause, Count(Start_Time) AS Occurrences
FROM qrytblMachineDT
WHERE (Start_DateTime > @StartTimeWindow) AND (Start_DateTime <= @EndTimeWindow)
AND (Line IN (@Line)) AND (Line_Status IN (@LineStatus)) AND (Cause_Type IN (@CauseType))
AND (Shift IN (@Shift)) AND (Team IN (@Team)) AND (Lot IN (@Lot)) AND (Product IN (@Product))
GROUP BY Process_Area, Machine, Unit_Op, Auto_Cause
END
Brian
CREATE PROCEDURE spGenerateReportData
@StartTimeWindow DATETIME,
@EndTimeWindow DATETIME,
@Line varChar,
@LineStatus varChar,
@CauseType varChar,
@Shift varChar,
@Team varChar,
@Lot varChar,
@Product varChar
AS
BEGIN
IF EXISTS (SELECT NAME FROM objSystems WHERE NAME = 'qrySearchCriteria1')
ALTER VIEW qrySearchCriteria1 (Process_Area, Machine, Unit_Op, Auto_Cause, Occurrences)
AS
SELECT Process_Area, Machine, Unit_Op, Auto_Cause, Count(Start_Time) AS Occurrences
FROM qrytblMachineDT
WHERE (Start_DateTime > @StartTimeWindow) AND (Start_DateTime <= @EndTimeWindow)
AND (Line IN (@Line)) AND (Line_Status IN (@LineStatus)) AND (Cause_Type IN (@CauseType))
AND (Shift IN (@Shift)) AND (Team IN (@Team)) AND (Lot IN (@Lot)) AND (Product IN (@Product))
GROUP BY Process_Area, Machine, Unit_Op, Auto_Cause
END
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.