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 /*...

titsiros (1/26/2016)

---

The databases are on different machines but for the purpose of the merge we could move them to the same one. This would also make sense in terms of...

titsiros (1/26/2016)

---

I use a similar strategy but instead of having a nested select, I do an INNER join between the two databases

insert into destinationDB.destinationTable (ID, s...)

select destinationParentTable.ID, s...

from...

Sergiy (1/25/2016)

---

MMartin1 (1/25/2016)

---

No, since this particular statement is vague the best we can do is start him off with some basics to try and get more information. This is not...