Is there a particular reason why your developers want to do this, some weird security reasons that make creating multiple procedures an issue? Or do they think it's just...

jonathanm 4432 (9/11/2015)

---

Here is my code:

BULK INSERT [ThomasSci].[dbo].[DONNAWESNERINP]

FROM '\\111.17.10.23\global$\Stocking_Request\_macro\WESNERINPUT.txt';

GO

and here is the error message i get:

Msg 4861, Level 16, State 1, Line 1

Cannot bulk load because the...

Eirikur Eiriksson (9/11/2015)

---

Mike Sofen-356112 (9/11/2015)

---

Eirikur Eiriksson (9/11/2015)

---

My 2 Cents, when working with large and often complex schema, cluttering a detail level ERD into a single diagram does neither make sense...

Pizza

/shrug I consider an ERD a decent high level documentation tool but if I want to really know what's going on I'll look at the database and more importantly the...

It doesn't look like you need the subqueries at all?

SELECT

L.Loanid

,B.FirstMiddleName AS First1

,B.LastName AS Last1

,B_TWO.FirstName AS First2

,B_TWO.LastName AS Last2

,MA.AddressLine1

,MA.AddressLine2

,MA.City

,MA.State

,MA.Zip

FROM Loan L

LEFT JOIN Status As S on S.LoanID = L.LoanID

LEFT...

Just out of curiosity are all your clients using the same version of whatever app they are using to connect to the database?

Cartilage

You can run multiple dataflows in parallel in the same package but as has been said it depends on complexity and dependencies and performance issues.

Or SELECT 15.0/24.0

call.copse (9/3/2015)

---

ZZartin (9/2/2015)

---

RonKyle (9/2/2015)

---

I guess why I find this topic so interesting is that I keep hearing this "the consequences will dire" statement about not using foreign keys and...

RonKyle (9/2/2015)

---

I guess why I find this topic so interesting is that I keep hearing this "the consequences will dire" statement about not using foreign keys and I just...

David.Poole (9/2/2015)

---

If you are the person who will bear the consequences then if you are willing to do so then you can do without foreign keys. Chances are that...

How is this procedure going to be called, will it be run manually from SSMS bcp and powershell would both be command line tools would you run it manually there?...

Now if only all websites used the same algorithm to determine whether a password is strong enough.....