CRLF can be added to the end with these 2 lines:

SET @Cmd = 'cmd.exe /C echo.>>"' + @FileName + '"';
EXEC xp_cmdshell @Cmd, no_output;

—SqlServerBuilds site admin

• This reply was modified 3 years, 5 months ago by  SqlServerBuilds.
• This reply was modified 3 years, 5 months ago by  SqlServerBuilds.

Hello,

I'm here again. Again, I kindly recommend you to use a public Google document as your data source, as described here:

How to get SqlServerBuilds data programmatically?

https://sqlserverbuilds.blogspot.com/2019/08/how-to-get-data-programmatically.html

For simplicity, for...

• This reply was modified 3 years, 5 months ago by  SqlServerBuilds.
• This reply was modified 3 years, 5 months ago by  SqlServerBuilds.

Hello,

as a datasource you can use public Google Sheet with all SQL Server builds:

https://docs.google.com/spreadsheets/d/16Ymdz80xlCzb6CwRFVokwo0onkofVYFoSkc7mYe6pgw/view

Download using PowerShell as CSV – DownloadSqlServerBuildsAsCsv.ps1:

$SqlVersion = "2017"
$URL = "https://docs.google.com/spreadsheets/d/16Ymdz80xlCzb6CwRFVokwo0onkofVYFoSkc7mYe6pgw/gviz/tq?tq=select+*+where+A%3D" + $SqlVersion +...