Aggregate Function Product()
The TSQL aggregate function SUM() gives a number based on the addition of the values of multiple rows to each other. Do the same thing but with multiplication instead of addition.
2012-02-06
8,665 reads
Paul McPherson
Blogs
Fixing the PoSh Hotkey in ADS
By Steve Jones
I installed the PowerShell (PoSh) extension in ADS recently. This is available in the...
Capture Execution Plans Only For Long Running Queries
I love questions. Most of all, I love questions I can answer. I spotted...
Daily Coping 28 Sep 2020
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Forums
Simple Python question...
I have a table in SQL Server like this: CREATE TABLE #SymptomData ( ...
Regular expressions in script component
In one of our SSIS package we have a script component that validate a...
Ask SSC