Hi and...

The problem with assigning an auto-incrementing id as the primary key is that it does nothing. Imagine a data entry typist accidentally leaning on the keyboard for a while, causing...

Perhaps this might help get you started.

http://www.sqlservercentral.com/Forums/FindPost1758249.aspx

Out of curiosity what Security protection level configuration are you using when you save the package?

Grant Fritchey (4/8/2015)

---

I'm with Luis. I don't like the normalization on DVD. I'll go one further, there is a movie (Luis used title) and there is the physical DVD itself....

How would I set up a Foreign Key between the Job_Request (RequisitionNumber) and the Job_Requisitions(RequisitionNumber) knowing that the first record created will be in Job_Request which will have a...

Miranda Johnson (10/1/2015)

---

So if I understand you correctly instead of having 3 columns in the Job_Requisitions table, RequisitionNumber, JobID, and LocationID , you would have a 4th column...

The way I was taught to start with database design is to look at things conceptually. You first establish the "entities." Then you solve how the entities are related to...

Orlando Colamatteo (1/23/2016)

---

Would it benefit you to improve in the 43 minutes? 5 million rows is more than your average data load but it is possible to process that many...

In your control flow, how do you know what version of the procedure will be called? Are you using it in a loop container?

SQL006 (1/31/2016)

---

Thanks chris, Luis for the solution.

This is just the scenario i created, In production there is no temporary table #Test only physical table which consists of 2 million data....

Jeff Moden (2/1/2016)

---

Eirikur Eiriksson (1/27/2016)

---

Jeff Moden (1/26/2016)

---

I'd take some heart in what was said as mean as it sounded. We have quick posts that don't survive the future and...

One idea you may see and related to making use of a underutilized server ; is having a the application server and the reporting database on two instances of the...

GilaMonster (1/29/2016)

---

"(table2.[type]<2 and table2.[type]>2)"

That will match precisely 0 rows, as type cannot be both less than 2 and greater than 2 at the same time. It's not equivalent to (table2.type...

Also know that if that column contains nulls, those will be missed by the select. Something along the lines of

(table2.[type]<2 and table2.[type]>2) Or table2.[type] IS NULL /*...