ADS 19.0 VA still does not allow the creation of a #temp table in a batch and the selection form the #temp table in another batch.
Ie, it only allows one batch of SQL
However in Query analyzer I have
Select * into #tmp
Go
Update #tmp
Go
Select * from #tmp
Va only uses the last batch
I need all of them to be executed
The implementation could be tricky, so I am moving this to a future release.
The user could work around this by writing a stored procedure to perform the multiple statements in the issue description. Then just call the stored procedure to prepare and return the data.
Issue #15632 |
New |
Completion |
No due date |
No fixed build |
No time estimate |
The implementation could be tricky, so I am moving this to a future release.
The user could work around this by writing a stored procedure to perform the multiple statements in the issue description. Then just call the stored procedure to prepare and return the data.