Hi All,
i want help in declaration this query gives where clause error in query generator
/SELECT FROM [owtr] owtr_3/
declare @fromdate as datetime
/* WHERE */
set @fromdate = /* owtr_3.DueDate */ '[%0]'
/SELECT FROM [owtr] owtr_4/
declare @tilldate as datetime
/* WHERE */
set @tilldate = /* owtr_3.DueDate */ '[%1]'
SELECT TOP (100) PERCENT
owtr_1.docentry as 'Internal Number',
OWTR_2.DocNum as 'Document Number',
OWTR_1.U_dtype as 'Document Type',
WTR1_1.u_location as 'To Location',----
for to loc
dbo.OCST.Name AS 'To State',--2
OWTR_2.U_tinno as 'TIN No.2', --3
OWTR_2.U_Loc as 'From Location',--4
OCST_1.Name AS 'From State',--5
dbo.OWHS.U_whtin as 'Tin No.1',
6
--
ketan
OWTR_1.U_tinno AS 'TinNo1',--6
OWTR_1.DocNum AS 'STN No.',--7
OWTR_1.DocDate AS 'DOC Date',--after 7
dbo.WTR1.ItemCode as'Item Code',--8
dbo.WTR1.Dscription as'Description',--9
dbo.WTR1.Quantity,
dbo.WTR1.StockPrice as 'Old Stock Price',
(dbo.WTR1.StockPrice * dbo.WTR1.Quantity) as 'OLD Value',
WTR1_1.StockPrice as[StockPrice],
(WTR1_1.StockPrice * dbo.WTR1.Quantity) as 'NEW Value',
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 Number',
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_1.u_dtype = 'Stock transfer IN'
and OWTR_1.docnum = '9000314'
AND owtr_1.DocDate >= @fromdate
AND owtr_1.DocDate <= @tilldate
ORDER BY owtr_1.DocDate,OWTR_2.TaxDate,OWTR_2.DocDueDate
.......................................................................................................
pls help me in this query for declaration part
ketan......
Edited by: ketan.k.pande on Dec 3, 2009 12:13 PM