make SQL output so I can run it in SSMS
in the SQL output window instead - the parameters emitted as coments are not executable.
Putting them on separate lines with a declare in-front and the appropriate type in-front would be very useful
e.g. instead of
-- Region Parameters
-- @year_0='2024' (DbType = Int16), @period_1='5' (DbType = Int16)
-- EndRegion
output:
-- Region Parameters
-- declare @year_0 int ='2024' -- (DbType = Int16)
-- declare @period_1 int ='5' -- (DbType = Int16)
-- EndRegion
3
votes
![](https://secure.gravatar.com/avatar/a6feb5b4c84289a0c108edc54faf49af?size=40&default=https%3A%2F%2Fassets.uvcdn.com%2Fpkg%2Fadmin%2Ficons%2Fuser_70-6bcf9e08938533adb9bac95c3e487cb2a6d4a32f890ca6fdc82e3072e0ea0368.png)