Was it the same on the Object Explorer and the Query Editor?

It's not possible to randomly return less rows using "select * from table" unless there's something else going on.

Steve,

That was bad generated sample data, not the real structure of the data.

It's possible that you were connected to a different database or server.

It's not recursive.

Alvin Ramard (8/4/2015)

---

Steve Jones - SSC Editor (8/4/2015)

---

Since we're all piling on the behavior of others, I was wondering.

Is there value in getting the questions/knowledge that people lack in interviews...

Daryl AZ (8/4/2015)

---

It feels like the CTE is acting more like RBAR then a result. My best thought is the updating #tReceive from a CTE against #tReceive is somehow...

bghad1 (8/4/2015)

---

are you sure that BI is not kinda restricted area of IT...

You almost got it, but we need the real structure instead of rows of delimited strings. I guess you forgot to click on the "Convert CSV to SQL Insert" button.

It...

drew.allen (8/4/2015)

---

Actually, those two queries are not equivalent. The first query allows dates that are before '20150101', whereas the second does not. While it's highly likely that the OP...

Hi welcome to the forums.

What you explain might be possible, but a simple pdf with truncated rows won't help. We need DDL, sample data as insert statements and the expected...

Stewart "Arturius" Campbell (8/4/2015)

---

JP Dakota, PRC (8/4/2015)

---

Did you execute queries 1 & 2 in seperate query windows to the initial? Yes

If you did do that, did you execute them while...

Edward-445599 (8/4/2015)

---

I have a table which has been import from a TXT file. Most lines can be ignored, but when I get a line like this

' ...

You've been here long enough to know that you should post DDL and sample data to get a coded solution.

That's not...

Is '2015/01/01' a fixed value for the query or is it a value that can change from one row to another?

If it's a scalar value, you should change your query...