Skip to Content
0
Former Member
Dec 03, 2009 at 11:12 AM

declaration in query

42 Views

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