Isn't it possible to have parameters in the top of af statement, I get
syntax error if I try this and the parameter is there.
select top @.top etc.
JackTSQL doesn't support using a variable in a TOP statement, so reporting
services can't use a parameter in this case. The only way I know to do
this in TSQL is build the SQL as a string, and run it with
sp_executesql or EXEC.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment