Agreed.   I'm apparently just doing it wrong.

Oops.  Here's updated data.

I've tried grouping on everything but FeeName and Fee.  And that makes it show up just one record for the Policy, but then doesn't include the 2nd...

Makes sense.  Here you go:

CREATE TABLE DataTable 
(
DataTableID INT IDENTITY(1,1),
QuoteNumber BIGINT,
ProducerName VARCHAR(50),
InsuredName VARCHAR(50),
CompanyName VARCHAR(50),
GAName VARCHAR(50),
PolicyNumber VARCHAR(25),
EffectiveDate DATETIME,
Coverage VARCHAR(30),
Premium MONEY,
Tax MONEY,
FeeName VARCHAR(25),
Fee MONEY,
PolicyTotal MONEY,
BrokerFee MONEY,
QuoteTotal MONEY
)
GO

INSERT INTO DataTable...

The first picture in the post represents some sample data.  Or do you mean send some SQL to create a table and insert sample data?

You sure you have the connection info correct for that data source?

You'll need an IP for each subnet. You can use the same port. (In fact, I don't think it is possible to use a different port per subnet,...

Could there be a trigger causing this?

Or maybe a synonym?

I don't know if it is best practice or not, but we have about 25 two-node AlwaysOn clusters, and we have a separate server that hosts the file shares for...

But considering it is a totally 100% free forum that is so well known, I think they do a pretty good job of handling/preventing SPAM.

You're talking about where you tell it what folder to use to for the backups it uses for setting up the secondary replicas?

I don't think that folder will...

I wouldn't do a direct update statement to the table.

Using the msdb.dbo.sp_update_jobstep SP would be the way to go.

What about charging a one-time small fee to be a user of SQLServerCentral.com? Something like $2? (Or whatever the minimum charge would have to be to break even...

It's working. I'm not sure what to think about how supported it is. There are MS articles scattered about saying it is not supported, one of which is...

I saw those references saying MSDTC isn't supported with AlwaysOn 2012. But apparently Microsoft still supports MSDTC itself, because I ended up opening a case with them and they...