SQLPSX 1.6.1 Release
I completed a maintenance release of SQL Server PowerShell Extensions, which address all known open issues. This release is still...
2009-09-02
634 reads
Chad Miller
Internet Explorer Automation with WatIN
At my workplace I use an IT Service Desk application, called well, "Service Desk" from CA. The system is web-based...
2009-08-29
2,513 reads
Continuous Integration in a Development Environment using Red Gate Backup and SQL Compare
My co-worker and fellow DBA, Leigh Freijo has a blog entry about a Powershell script he created to re-integrate QA/Development database changes...
2009-08-25
1,106 reads
Tampabay SQL Server User Group Presentation
I presented a one-hour session for Tampabay SQL Server User Group on Powershell and SQL Server. I've previously delivered this session for the...
2009-08-19
829 reads
Installing SQL Server 2008 on Windows 7
When Installing SQL Server 2008 on Windows 7 RTM, I encountered a couple of issues. Supposedly you can install SQL...
2009-08-15
795 reads
ThrowAway Scripts
Although I tend to write a lot of formal scripts, as part of the development process I'll explore an object...
2009-08-12
564 reads
SQLSaturday #16 South Florida Downloads
I presented a 1 hr session at SQL Saturday #16 session PowerShell and SQL Server Administration: In this sesssion we...
2009-08-08
465 reads
SQLSaturday #16 South Florida
I'm giving a presentation at SQLSaturday in South Florida on August 8th 2009. If you haven't been to a SQLSaturday,...
2009-07-27
473 reads
Building PowerShell GUIs with Primal Forms
Although PowerShell is best suited for console applications there are times when a GUI interface just makes sense, however hand cranking...
2009-07-25
4,140 reads
SQL Server Powershell Extensions PowerGUI PowerPack
If you've been working with Powershell, you most certainly have heard of PowerGUI, for those of you who haven't PowerGUI is...
2009-07-24
1,166 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