hi experts,
in my following query
SELECT TOP (100) PERCENT
OWTR_2.docentry AS 'internal number',
OWTR_2.U_Loc AS 'From Location',
OCST_1.Name AS 'From State',
--OWTR_2.U_tinno as 'Tin No.1',
dbo.OWHS.U_whtin AS 'Tin No.1',
--dbo.WTR1.StockPrice as 'Stock Price',
OWTR_2.U_dtype as 'Document Type',
OWTR_2.TaxDate AS 'DocDate',
OWTR_2.CardCode as 'To Location',
dbo.OCST.Name AS 'To state',
--dbo.OWHS.State AS 'LocState',
--dbo.OCRD.State2,
OWTR_2.U_tinno as 'Tin No.2',
--dbo.OWHS.U_whtin AS 'Tin No.2',
dbo.WTR1.ItemCode as 'Item Code',
dbo.WTR1.Dscription as 'Description',
dbo.WTR1.Quantity as 'Quantity',
(dbo.WTR1.StockPrice * dbo.WTR1.Quantity) as 'value' ,
OWTR_1.DocDate AS 'Closing date',
dbo.[@ITMG].Name AS 'MAG',
OWTR_2.U_C_Name as 'Carrier Name',
OWTR_2.U_V_Number as 'Vehicle Number ',
OWTR_2.U_lrno as 'LR No.',
OWTR_2.U_LR_Date as 'LR Date' FROM dbo.OCST AS OCST_1 RIGHT OUTER JOIN
dbo.OWHS INNER JOIN
dbo.OWTR AS OWTR_2 INNER JOIN
dbo.WTR1 ON OWTR_2.DocEntry = dbo.WTR1.DocEntry INNER JOIN
dbo.OITM ON dbo.WTR1.ItemCode = dbo.OITM.ItemCode ON dbo.OWHS.WhsCode = OWTR_2.Filler LEFT OUTER JOIN
dbo.[@ITMG] ON dbo.OITM.U_itmg = dbo.[@ITMG].Code ON OCST_1.Country = dbo.OWHS.Country AND
OCST_1.Code = dbo.OWHS.State LEFT OUTER JOIN
dbo.OCST INNER JOIN
dbo.OCRD ON dbo.OCST.Code = dbo.OCRD.State2 AND dbo.OCST.Country = dbo.OCRD.Country ON
OWTR_2.CardCode = dbo.OCRD.CardCode FULL OUTER JOIN
dbo.WTR1 AS WTR1_1 INNER JOIN
dbo.OWTR AS OWTR_1 ON WTR1_1.DocEntry = OWTR_1.DocEntry ON cast(OWTR_2.DocNum as nvarchar)= OWTR_1.U_stno AND
dbo.WTR1.ItemCode = WTR1_1.ItemCode AND OWTR_1.FinncPriod >= OWTR_2.FinncPriod AND OWTR_1.CANCELED = OWTR_2.CANCELED WHERE OWTR_2.U_dtype = 'Stock Transfer OUT'
if i wish to select OWTR_2.U_dtype = [%0] then it show error
incorrect syntax near 'where'.2
pls help me in this regard
ketan
SAP b1