You could do it from a Powershell job step, with something like:
Invoke-WebRequest -Uri http://www.google.com

Something like this should do it:

$badLines = 0
Get-Content .\test.txt | ForEach-Object {
    $currentLine = $_
    $cols = $_.Split('|')
    Try {
        # Note...

The EOMONTH function can give you the last day of the month from any given date.

Row Number in this case is not guaranteed to return the order nodes were in the XML, you have to use XQuery to get that.

Get used to "it depends", such is the world of database development. Compound keys can be a good solution, but make sure they don't get too wide - sometimes it...

Good discussion here. Choosing clustering keys and fill factors strikes me as one of those "black arts" when it comes to SQL Server and I'm not surprised people gravitate towards...

There most certainly was a decimalised half penny. I'm not old enough to remember pre-decimal currency, but I am old enough to remember being gutted that half-penny sweets were about...

Are you absolutely sure you didn't mis-type the last line of that query when you tried it in SSMS (or accidentally missed it off). The fact you have a HEAP...

Dumb moment on my part, try:

August 29, 2018 at 3:49 pm

#2003920

Casting things to CHAR will force a specific length, so something a bit like:
Select
 Cast(trans As Char(3))
 +Cast(Number As Char(3))
 +Cast(Loan As Char(6))
 +Space(41-13+1)
 +Cast(Interest As Char(7))