All Forums Analytics
GrahamS 1 post Joined 03/13
28 Mar 2013
Using parameters in a derived table

I am trying to use SSRS to pass parameters into a derived table in Teradata. The parameters represent a SQL Server table that is about 1600 rows. 
The join I'm trying is
 JOIN (Select ? (varchar(4)), ? (varchar(4))) as derivedtable (Col1Name, Col2Name) on (Col2Name=TDcol)
The error I'm getting is 3706 Column name list is shorter than select list. I'm hoping that this is possible and that I'm just messing up the syntax. 
Many thanks in advance. 

You must sign in to leave a comment.