The reason I asked about Access is that I don't know how to dynamically select which columns are getting imported/mapped to which destination columns in SQL Server. I have done...

You can do this in Access too... Open a front end (no data, just linked tables, and some code). Then loop through the table(s) and deal with them. Append to...

Thanks for posting the INSERT scripts.  But without a corresponding CREATE TABLE script, the data has nowhere to go.

That's a huge question... Are you looking for a book on SQL Server Administration or T-SQL?

I tried to reproduce your problem by using DECLARE inside the query window in PowerBI (after you specify the database etc), and mine worked. Granted, my SQL was a lot...

Yes, you're right. I would absolutely do this as a stored procedure. If you post the CREATE TABLE and INSERT scripts for your Agents and ActiveCalls tables (maybe 2 records...

Joe,
Here's my really small test setup:
USE TempDB;
GO

CREATE TABLE Agent(
    AgentID INT IDENTITY,
    FirstName VARCHAR(15) NOT NULL,
    LastName VARCHAR(20) NOT NULL
CONSTRAINT Agent_PK PRIMARY...

You can capture the ID of the person with the fewest calls, and then use it in another query:
DECLARE @AgentID INT;

SELECT TOP 1
    @NextAgentID =...

Okay, I'm not a DBA, so take this with a grain of salt.
What if you had a table that held the size of the log over the course of...

Yeah, I figured that out after taking a break for a while... (That's my crummy code he was posting about.)
Took me a minute to figure out I could use...

Why not just use a the 3-part naming convention when creating your view?

USE Tempdb;
GO
CREATE VIEW MyView
AS
SELECT CustomerID
FROM Galactic.dbo.Customer;

I'm creating...

Thanks for the data, and expected results - it helped a lot.  I fixed it up and created the scripts to populate your table - (since you're new, you get...

This would be infinitely easier if you normalized your table structure first. Repeating groups is the first thing you remove when normalizing a table.

Can't you take my union query (or similar) as the source, and then use COUNT() as the aggregate at the intersection? Something like A would be on Columns, C would...