monilps (1/13/2016)

---

I am sorry about that, later on I just realized it. I will be careful next time.

Didn't meant to waste anyone time.

No, this is similar but not the same....

monilps (1/13/2016)

---

Hi,

I have updated below table:

Col1Col2 Col3 Col4 RowNumber

123AX ...

monilps (1/13/2016)

---

Hi,

I have below table:

Col1Col2 Col3 RowNumber

123AXC 12/1/2015 1

123AXCVV 12/1/20152

345XSW 12/5/20151

345XSW-SE12/5/20152

567ERW ...

Fáfnir

SQLRNNR (1/13/2016)

---

Jacob Wilkins (1/13/2016)

---

edwardwill (1/13/2016)

---

Jacob Wilkins (1/13/2016)

---

edwardwill (1/13/2016)

---

Eirikur Eiriksson (1/12/2016)

---

SQLRNNR (1/12/2016)

---

I dunno about the "correct" answer on this one. The statements compile for me but produce an error at run-time....

Jeff Moden (1/13/2016)

---

Even with this, you still have a bit of the "mouse guarding the cheese". The only true method of knowing how many rows should be in a...

Steve Jones - SSC Editor (1/13/2016)

---

I think you'd need a separate process that counts rows, knowing what a "row" is in the file format as a

delimiter.

You can look for...

How big are these files? One option is to load the file into a variable using t-sql and openrowset, then count the lines by comparing the length against the length...

cycle90210 (1/13/2016)

---

This is definitely possible and the table I do load it in to is a "staging" table of sorts (with interface status columns, date loaded, filename loaded, etc).

The issue...

Quick suggestion, load the file into a separate table (ie. bulk load), check if everything is there (row count, sum etc.) and simply truncate the table if unsuccessful.

😎

What...

The query hint is the READCOMMITED, why are you using it? Is it because you are...

😎

WITH (READUNCOMMITTED)???

MMartin1 (1/12/2016)

---

Thus if we have 10 rows for tables 1 and 2 each .... and table two has three columns to consider for one column from table1 -->

then...

There are no effective predicates in this query, it will return all rows and the most effective way for the server to do that is a table scan.

😎