You could try adding a single quote, as the first character, to each value exported. When Excel sees a single quote as the first character of a cell it treats...

Phil's suggestion also makes it much easier to update just one table, or a subset of tables.

Jerid421 (9/22/2016)

---

Alvin,

Thanks for the response! Wouldn't running a task be a one-time thing though? I want to run this package daily to make sure that the data in...

Take a look at the "Transfer SQL Server Objects Task" task. If it works for you, it could save you a lot of work.

Well, depends on how far in the future SendDate might...

mcfarlandparkway (9/20/2016)

---

Based on this below SP.How to know this sp is updating or inserting into a specific table?

Do we need to specify table name here?

CREATE PROCEDURE [dbo].[sampleLog_Insert]

@table varchar(30),

@date ...

Looks like you have lots to learn about indexing, but I'm not the right person to do the teaching.

... I know technically a table without a clustered index is considered...

BrainDonor (9/19/2016)

---

I've played a little more (this is a nice diversion from trying to understand reduction and distribution in QlikView) and it appears to depend upon the use of the...

BrainDonor (9/19/2016)

---

Alvin Ramard (9/19/2016)

---

BrainDonor (9/19/2016)

---

I couldn't see any of the answers that matched what I believed I should be getting - then I played around a little.

Where dates are concerned...

BrainDonor (9/19/2016)

---

I couldn't see any of the answers that matched what I believed I should be getting - then I played around a little.

Where dates are concerned it is probably...

Really? I now feel better about avoiding merge too. 🙂

What happened when you tried it?

Keep in mind that if you have a data warehouse with a date dimension, you may already have a useful calendar table.

I think your first priority should be dealing with what's causing the error messages, not the growing of the error log.

This is how I normally do it.