January 14, 2010 at 12:23 am
IF EXISTS (SELECT * FROM sys.views WHERE object_id = OBJECT_ID(N'[dbo].[ACC_VW0054]'))
BEGIN
ALTER VIEW [dbo].[ACC_VW0054]
AS
SELECT T0.TransNum, T0.TransType, T0.CreatedBy, T0.DocLineNum, T0.TaxDate, T0.CardCode, T0.CardName, T0.Ref1, T0.Ref2,
T0.ItemCode, T0.Dscription, T0.InQty, T0.OutQty, T0.ApplObj, T0.AppObjAbs, T0.AppObjType,
T1.Quantity PDN_Quantity, T1.Price PDN_Price, T1.AssblValue PDN_AssblValue, T1.DocEntry PDN_Entry, T1.LineNum PDN_Line,
T2.Quantity RIN_Quantity, T2.Price RIN_Price, T2.AssblValue RIN_AssblValue, T2.DocEntry RIN_Entry, T2.LineNum RIN_Line
FROM OINM T0
LEFT JOIN PDN1 T1 ON T0.CreatedBy = T1.DocEntry AND T0.DocLineNum = T1.LineNum AND T0.TransType = T1.ObjType
LEFT JOIN RIN1 T2 ON T0.CreatedBy = T2.DocEntry AND T0.DocLineNum = T2.LineNum AND T0.TransType = T2.ObjType
END
ELSE
BEGIN
CREATE VIEW [dbo].[ACC_VW0054]
AS
SELECT T0.TransNum, T0.TransType, T0.CreatedBy, T0.DocLineNum, T0.TaxDate, T0.CardCode, T0.CardName, T0.Ref1, T0.Ref2,
T0.ItemCode, T0.Dscription, T0.InQty, T0.OutQty, T0.ApplObj, T0.AppObjAbs, T0.AppObjType,
T1.Quantity PDN_Quantity, T1.Price PDN_Price, T1.AssblValue PDN_AssblValue, T1.DocEntry PDN_Entry, T1.LineNum PDN_Line,
T2.Quantity RIN_Quantity, T2.Price RIN_Price, T2.AssblValue RIN_AssblValue, T2.DocEntry RIN_Entry, T2.LineNum RIN_Line
FROM OINM T0
LEFT JOIN PDN1 T1 ON T0.CreatedBy = T1.DocEntry AND T0.DocLineNum = T1.LineNum AND T0.TransType = T1.ObjType
LEFT JOIN RIN1 T2 ON T0.CreatedBy = T2.DocEntry AND T0.DocLineNum = T2.LineNum AND T0.TransType = T2.ObjType
END
Above query shows error near the keyword View - Incorrect syntax.
I need to run this query from VB - to create or alter the view.
Regards
Rahul Jain
January 14, 2010 at 2:48 am
See BOL ---> Batches - CREATE VIEW has to be alone in its batch...
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply