I see - that explains.

>>>I figured it out. Thanks
>>>
>>What was it - just curious.
>
>In the script below I had .sql in the view name
>
>

>USE PKDEMO5
>GO
>SET ANSI_NULLS ON
>GO
>SET QUOTED_IDENTIFIER ON
>GO
>EXEC sp_DropView 'v_SalesForecastBookedQtyByPeriod.sql'
>GO
>
>CREATE VIEW v_SalesForecastBookedQtyByPeriod.sql
>AS
>
>	SELECT	RQ.RQ_MOCNUMBER, 
>			RQ.RQ_MOCREFNO, 
>			RQ.RQ_IMKEY, 
>			RQ.RQ_DATE_REQ, 
>			RQ.RQ_DATE_PROM, 
>			SUM(CASE WHEN sf.BookedQty IS NULL THEN 0 ELSE
>				CASE WHEN sf.RQ_DATE_REQ >= RQ.RQ_DATE_REQ AND sf.RQ_DATE_REQ <= RQ.RQ_DATE_PROM THEN sf.BookedQty ELSE 0 END
>				END) AS PeriodOrderedQty
>		FROM OH
>		INNER JOIN MOC ON OH.OH_NUMBER = MOC.MOC_OHNUMBER
>		INNER JOIN RQ ON MOC.MOC_REF_NO = RQ.RQ_MOCREFNO AND
>						 MOC.MOC_OHNUMBER = RQ.RQ_MOCNUMBER  
>		LEFT JOIN v_SalesForecastBookedQtyByDate sf ON RQ.RQ_IMKEY = sf.RQ_IMKEY
>		GROUP BY RQ.RQ_MOCNUMBER, RQ.RQ_MOCREFNO, RQ.RQ_IMKEY, RQ.RQ_DATE_REQ, RQ.RQ_DATE_PROM
>		HAVING RQ.RQ_MOCNUMBER LIKE 'FCST*'
>
>