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.