jc85 (5/25/2016)

---

ChrisM@Work (5/25/2016)

---

ChrisM@Work (5/25/2016)

---

Ideally you would do this by posting a...

Don't listen to him he's drunk as usual 🙂

jewel.sacred (3/22/2016)

---

Yes, I can fully understand this as I have experienced it as well in past. 🙂 I really appreciate the help been provided. But I already mentioned this criteria...

jewel.sacred (3/22/2016)

---

Thanks. Very interesting indeed. But it fails for the following criteria

SELECT @DateStart = '20160425', @DateEnd = '20160501';

The result should have been

PrimaryKeyIDDateStartDateEnd ...

Lynn Pettis (3/17/2016)

---

smithhead (3/16/2016)

---

Thanks, yes, I updated statistics. In the interest of being able to show it conveniently here I reduced the query down to a very simple example....

Hi Ben

A few questions for you based on the information you've posted so far.

The model system you have posted - does this model a production system or a system in...

That may be an unrestricted update. The left-joined table contributes nothing, and the WHERE clause is an unpredictable mess of AND and OR. What exactly are you trying to do?

Put the WHERE clause into the join.

bala2 (2/3/2016)

---

Hi All,

Today i have heard a strange issue from apps team.

We have store procedure on one of our sql server 2008 server database. When we ran that sp(sp_new)

manually it...

Jeff Moden (1/7/2016)

---

Jason A. Long (12/24/2015)

---

Unless you're using recursion, a CTE can be rewritten as a derived table... Considering that derived tables (and CTEs) are processed before the outer query,...

Magy (1/7/2016)

---

I have this complex delete statement.

I was wondering if there's a way to simply it? I tried formatting, but it still looks complex.

--delete all entries in the table...

SQLPain (12/16/2015)

---

I have inherited the following code involving cursors which happens to be step1 in a job, currently this step is taking 19 hours to run, there has to be...

Did you have to ask that? 😉

nileshbgp123 (11/18/2015)

---

Thanks a lot for your reply, as i said earlier i am not so good in SQL, Can you please just explain me how the value of SUPPLY is...

In the APPLY block, cast r.id to varchar(n),...