rourrourlogan (1/27/2016)

---

Yeah no problem

UniqID | Date Issued | Date Expires | Business

1...........1/1/2010..........1/1/2011.....Commerical

2...........1/1/2011..........1/1/2012.....Commercial

3...........1/1/2011..........1/1/2012.....Medical

The correct output would be the count of Ids that don't have any lines replacing them.. essentially a renewed...

There's probably a more efficient way of doing it than this, but here's one potential solution with your sample data:

WITH numbered_table1 AS

(SELECT rn=ROW_NUMBER() OVER (PARTITION BY AcctNo, WorkDate ORDER...

bsmith 63193 (1/27/2016)

---

Percentage Increase and...

bsmith 63193 (1/27/2016)

---

Jacob Wilkins (1/27/2016)

---

bsmith 63193 (1/27/2016)

---

Jacob Wilkins (1/27/2016)

---

First thing I notice is that your expression doesn't match what you stated in the text. In the text you stated you...

bsmith 63193 (1/27/2016)

---

Jacob Wilkins (1/27/2016)

---

First thing I notice is that your expression doesn't match what you stated in the text. In the text you stated you want to divide by...

bsmith 63193 (1/27/2016)

---

Jacob Wilkins (1/27/2016)

---

First thing I notice is that your expression doesn't match what you stated in the text. In the text you stated you want to divide by...

First thing I notice is that your expression doesn't match what you stated in the text. In the text you stated you want to divide by preMisc1*100, but in the...

The replicas' being set to synchronous commit isn't sufficient. Both the primary and secondary have to have failover mode set to AUTOMATIC.

What does this query show?

SELECT replica_server_name,

...

That's going to give incorrect results. For the insert into #alldbstate, you're still joining sys.databases and sys.master_files on the database name...

If the log is full, that means a couple things.

First, it means SQL Server isn't able to mark VLFs within the log as reusable (that's truncation). As indicated in...

You never reinitialize @StripeCounter, so after the first loop, it just stays at 0 and never gets set back to 4. In the cursor, before you set the value of...

What does this return for jobhistory_max_rows and jobhistory_max_rows_per_job?

EXEC msdb.dbo.sp_get_sqlagent_properties

At any rate, it sounds like you will just have to figure out how you want to handle the frequent-running CDC...

VegasL (1/23/2016)

---

You're right Jeff modifying the registry is the best solution since you don't have data integrity issue then.

On a side note, I'm still not understanding why even if column...

Ah, you're using an Excel source, not a flat file source.

That's a documented "feature" of using an Excel source (under "Usage Considerations", see "Truncated Text" and "Data Types" sections here:...

The data type of the destination is not the only thing at play there.

I'd double-check the OutputColumnWidth defined for the source columns (in the Wizard, when you choose a flat...