How are you specifying to run PowerShell, as a scripting task? Spitballing here, but could you run it as an Execute Process Task, with powershell.exe as the executable? Then in...

We have in-house standards that say block designators are required (any programming language), even if there's only one statement in the block. Eliminates any chance of confusion (human or compiler/interpreter)....

You beat me to to use of phone iconography. It's not just cell phones though. We have "desk phones" in the form of VOIP on our PCs. There's no handset...

I noticed you're always updating the row you just read from the cursor, but the UPDATE re-reads the row. Add FOR UPDATE OF OUTCOST to the DECLARE CURSOR. Then at...

PowerShell arrays are 0-based. We have 10 elements, so the index goes from 0 to 9. The assignment was $numbers = @(1,2,3,4,5,6,7,8,9,10). So $numbers[0] = 1, $numbers[1] = 2, ..., $numbers[4]...

9 is the correct answer (shame on me), but there is a subtlety here with PowerShell arrays. Setting $numbers[4] = $null does not change the size of the array, only...

If this is a one-time thing I'd probably script something locally to generate what winds up as an INSERT to a table variable, then put that into the script you...

The number of items to be sorted would have been helpful. If you're sorting 10 things, it doesn't much matter; if you're sorting 10 million things...

Just tried that in Python, in Jupyter Notebooks

print(-100.0/-100.0*10.0)

The output is 10.0

Also tried in Excel entering in the Formula bar

=-100.0/-100.0*10.0

The cell contain the value of 10. Excel is a Microsoft...

This is apparently a Microsoft thing. Both Oracle and IBM DB2 put +, - , when used for signed numeric values, at highest priority. I couldn't find documentation on what...

I don't really understand the explanation. In what was is anything "crazy" about the handling of negatives? Whatever the precedence you end up dividing a negative by a negative,...

Pretty sure the restriction on ORDER BY is on the UNION, not the EXCEPT and INTERSECT. Can anyone confirm?

Missed the "-"; that makes all the difference.

One of the reasons our standards require the 'AS', when using an alias.

This isn't really a PIVOT. You've selected where AA=1, and then also selected where AA=2 and renamed the column to "2", and somehow magically need to get them side by...