Ed Wagner (8/17/2016)

---

I know this may seem elementary, Brandie, but check the data types of the columns involved in your predicates - in both the JOIN and WHERE clauses. ...

Brandie Tarvin (8/17/2016)

---

ChrisM@home (8/17/2016)

---

If you could have posted a .sqlplan you would have done so in your first post. What about a picture of the properties sheet for the data...

Definitely.

If you could have posted a .sqlplan you would have done so in your first post. What about a picture of the properties sheet for the data reader operator of...

How are rows selected from the big left-joined table - only the join, or is there also a filter in the WHERE clause?

Luis Cazares (8/5/2016)

---

jasona.work (8/5/2016)

---

SQLRNNR (8/5/2016)

---

jasona.work (8/5/2016)

---

So, something completely different!

Movie review of the new Bourne movie (kept short)

Pros: Decent enough typical action movie.

Cons: Oh god the mangling and mis-use...

Post your code. Reduce the pointless guesses. Thanks.

SQLPain (7/13/2016)

---

Thanks Guyz

I connected it one more time with itself and used the MAX function, which kind of solved my problem.

I know this is not an ideal thing to do

SELECT...

TheSQLGuru (7/12/2016)

---

Note that you only need the ROW_NUMBER() stuff if you are inserting multiple rows in one batch. If you are like almost all of the clients I come across...

Has to be tested on steam-powered lappy here then. Dreckly.

J Livingston SQL (7/11/2016)

---

sql restarted

10 runs each

comment ms

CJM2 ...

MMITTAL 758 (7/1/2016)

---

Hi,

I'm trying to add a condition in sql where I have used &regiondivision and &divisionid as variables. I want if the case 1st condition is satisfied then the...

Thanks Phil :blush: I learned it from you 🙂

Use IN with a list of possible values:

IN("8 Park Lane","8,Park Lane","8, Park Lane").

Construct these values from your input.

Ed Wagner (5/31/2016)

---

Now that's along the same lines I was thinking...