Tag Info

Hot answers tagged

1

If you need to execute sql file use sqlcmd documented in the MSDN: Run Transact-SQL Script Files Using sqlcmd This did the trick for me: sqlcmd -S serverName\instanceName -i script.sql -o output.txt


1

What you are asking is to be able to create a report name dynamically, which is not something that can be programmed, on download, say, from Report Manager. You can (although I've never tested this) possibly do this through a subscription using @ParameterName @ReportName. citation from msdn It's about the best you can do for now, and there's a link on the ...


1

You can use an array constructor: select array( select zone from mytable) as areas;



Only top voted, non community-wiki answers of a minimum length are eligible