Skip to Content
0
Former Member
Jul 17, 2008 at 07:36 AM

Query SQL with variables Parameters and user defined tables

46 Views

Hi everyone

I got a problem about Query SQL

[dbo].[@CSOURCE] is a user defined table

select * from [dbo].[@CSOURCE]

you can get the result in following

code name

T01 newspaper

T02 TV

T03 radio

T04 friends

when I execute the following SQL Statements ,I get an error

SELECT T0.CardCode , 0.CardName ,T1.Name ,T2.SONumber

FROM OCRD T0 LEFT JOIN [dbo].[@CSOURCE] T1 ON T0.U_CSOURCE = T1.Code

LEFT JOIN (SELECT T0.CardCode ,COUNT(T0.DocNum)SONumber

FROM ODLN T0 INNER JOIN OCRD T1 ON T0.CardCode = T1.CardCode

WHERE T1.GroupCode =111

AND (T0.DocDate >=[%0] or [%0]='')

AND (T0.DocDate <=[%1] or [%1]='')

GROUP BY T0.CardCode) T2 ON T0.CardCode=T2.CardCode

WHERE T0.GroupCode =111

and T0.CardType ='C

Is there anyone can correct it for me

thank you very much

Edited by: Li Mishan on Jul 17, 2008 9:36 AM

Edited by: Li Mishan on Jul 17, 2008 9:40 AM