Already declared variable d type to date, in datewindow nested query, nested select variables d to invalid parameters (parameters) in brackets, excuse me expert how to solve? The following is an example:

Select * from (select * from the TAB where txdate=: d) where txdate=: d

CodePudding user response:

Derived to add alias

Select * from (select * from the TAB where txdate=: d) where a txdate=: d

CodePudding user response:

reference 1st floor blandwolf response:

derived to add alias

Select * from (select * from the TAB where txdate=: d) where a txdate=: d

Added, an example of this is literally write a select * from (select * from the TAB where txdate=: d) as tab2 where txdate=: d

CodePudding user response:

It looks not wrong, you can put this on the data sources window to see, may be problem in other places

CodePudding user response:

reference blandwolf reply: 3/f

no error when it looks, you can put the data window to see in the data source, possible problems elsewhere

In sqlsever written directly "the position of the parameter value, there is no problem, DW, parameters directly into value is also no problem, but not as parameters, I estimate the nested parameters of the problem, because of the nested written values of parameters, outside of the parameters of the same, still running ok, nobody knew how this nesting parameters to statement?

CodePudding user response:

Pb9 mssql2005

The data source for
Select * from (select * from TB where ddate=: d) where a ddate=: d
The data window is not an error