Just based on that logic if any record in the your staging table matches anything in the target table very row in the staging table would be treated as an...

Yes it will process text files in line order, that is no guarantee however that they'll come out of a database table in that order. The line counter can...

Well if you really don't know the lengths just import everything as varchar(max) then proceed to do some analysis from there.

Phrenology

DECLARE @query nvarchar(max)

SET @query = (SELECT STUFF(COL_ONE, 1, 10, '') FROM

(SELECT ' UNION ALL SELECT DISTINCT ' + char(39) + COLUMN_NAME + char(39) + '' + ' FROM...

Steve Jones - SSC Editor (11/3/2016)

---

ZZartin (11/2/2016)

---

I don't feel it's the job of IT to play vigilante and hunt down people potentially abusing the system, unless you work in InfoSec...

It always surprises me that companies will have no issues putting up 6-7 figures on deployments in licensing/man hours but then put up a huge fight over an extra 5-10...

Nifty, too bad I don't create tables often enough to care much about this vs just declaring the indexes separately. Especially if SSMS wasn't also updated to script out...

Did you try updating the statistics on the tables in question first?

I don't feel it's the job of IT to play vigilante and hunt down people potentially abusing the system, unless you work in InfoSec and are just an evil person.

Bat

What about this, since you don't have any other criteria the results will be fairly arbitrary if you have multiple rows that are returned either with ThisRec or no rows...

Gary Varga (11/1/2016)

---

It seems a little worrying how many will not use the command line. I am not referring to your average citizen but your average IT professional. I have...

RVO (10/31/2016)

---

Thanks Jeff.

I'm confused.

You're saying it's a good idea to have staging tables in a separate database

but then what do I do with Foreign Keys?

Flow is the following:

1. load into...

Business...