Tampa Code Camp 2009
I presented a 1 hr session at Tampa Code Camp 2009: PowerShell for Developers In this sesssion we will look...
2009-11-07
653 reads
Chad Miller
Stored Procedure Call Tree
I was reading a post by Linchi Shea in which he demonstrates a Perl script to Find the complete call...
2009-11-01
1,802 reads
Operations Manager Shell
I've started using SCOM 2007 R2, which has given me a chance to try out the Operations Manager Shell. The Ops Mgr Shell...
2009-10-21
1,017 reads
SQL Saturday #21
I presented a 1 hr session at SQL Saturday #21 session SQL Server PowerShell Extensions: In this sesssion we will...
2009-10-18
396 reads
SQLServerCentral Article on Database Space Capacity Planning
I wrote an article for SQLServerCentral entitled "Database Space Capacity Planning" that demonstrates a database and volume (disk) capacity planning solution...
2009-10-13
1,001 reads
SQL Saturday #21 and Tampa Code Camp 2009
A couple upcoming events I'll presenting at...
SQL Saturday #21 on October 17th in Orlando
I'm amazed at how SQL Saturday has grown...
2009-10-10
387 reads
Southwest Florida Code Camp II
I presented a Powershel session at the SW Florida .Net Code Camp IIl. The session demonstrated the following uses cases for...
2009-10-03
537 reads
External MAML Help Files
One of the really handy improvevements in Powershell V2 is around creating help information for your script users. I often find myself having...
2009-09-23
752 reads
SQLPSX Developer Blog
Powershell enthusiast, DBA and new SQL Server PowerShell Extensions developer Mike Shepard started a blog. Mike addresses a common question...
2009-09-07
490 reads
MIF Busters
Management Information Format (MIF) files are formatted text files containing additional information about hardware and software components. The MIF format originated...
2009-09-07
1,598 reads
Blogs
AI Helps Me with My Sloppiness
By Steve Jones
I type fairly well. Well, I type fast, but I do wear out a...
WITH clause gets a 26ai boost!
By way of background, a while back I did video called “My New Favourite...
Automatic Index Compaction
By ReviewMyDB
Index maintenance has always meant nightly jobs and a window you have to defend....
Forums
SQL Art, Part 4: Happy 4th of July — A British DBA's Guide to Celebrating a War We Don't Talk About
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
ALAMAT KONTAK BCA KCU PONTIANAK Telp,Cs:08218154393
WA:08218154393 Jl. Jenderal Ahmad Yani No.1, Benua Melayu Darat, Kec. Pontianak Sel., Kota Pontianak,...
ALAMAT KONTAK BCA KCU BALIKPAPAN Telp,Cs:08218154393
WA:08218154393 Jl. Jenderal Sudirman No.139, Klandasan Ilir, Kec. Balikpapan Kota, Kota Balikpapan, Kalimantan Timur...
Question of the Day
Getting the Average
I have this data in the dbo.Commission table in a SQL Server 2022 database.
salesperson commission Brian 12 Brian 16 Andy 7 Andy 14 Andy 21 Steve 20 Steve NULLAll the data is a varchar, and I decide to run this query to get the totals for each salesperson.
SELECT SalesPerson
, AVG(TRY_PARSE(Commission AS int)) AS TotalCommission
FROM commission
GROUP BY SalesPerson
GO
What average commission is calculated for Steve? See possible answers