Hugo Kornelis (1/12/2016)

---

Yeah, and travelling ten miles if you happen to live near a timezone boundary can affect hour, day, month, and year parts, and in some areas of the...

Hugo Kornelis (1/12/2016)

---

If you think that datetimeoffset violates relational theory, then you should...

Kedazs (1/12/2016)

---

"If you do it more than once in a year - you need to rethink you approach to T-SQL programming, and probably take some lessons on how to do...

Alan.B (1/11/2016)

---

As already stated. atomic values would be ideal but sometimes you have to play the schema your dealt. One solution would be Full Text indexing then, instead of WHERE...

Lynn Pettis (1/11/2016)

---

Sergiy (1/11/2016)

---

Kedazs (1/11/2016)

---

Yes. I also use CTE's to "clean up my code". Especially if it is something being called multiple times within the select. I do...

Hugo Kornelis (1/11/2016)

---

You are confusing content with representation. If the presence of a delimiter is key, then you could equally well argue that date is non-relational (delimiter being "-" or...

Eric M Russell (1/11/2016)

---

In addition to dealing with 100s of external sources, the policy numbers coming from the same source, within the same source file, are coded inconsistently. There...

Kedazs (1/11/2016)

---

Yes. I also use CTE's to "clean up my code". Especially if it is something being called multiple times within the select. I do not think there...

drew.allen (12/31/2015)

---

GREAT! But suppose your company is going multi-national and they want to record dates using DATETIMEOFFSET. Update your code to use a DATETIMEOFFSET field with offsets ranging between...

Magy (1/7/2016)

---

Thanks. I tried joins, but I am not receiving the same number of rows as I am with the original query.

I replace the delete with a select for...

Don't you sense a bit of Catch 22 here? 😉

You should not worry about such...

Lynn Pettis (1/7/2016)

---

Then we should ban the use of views as well. How many times have we seen queries written with views nested in views, nested in views such...

Too late, mate.

Sorry. 😛

But honestly, there is nothing wrong with using CTE's -...

Alan.B (1/7/2016)

---

Using a CTE and keeping the code compatible with SQL 2005, we could re-write the code like this:

WITH

E1(N) AS

(

SELECT 1 UNION ALL SELECT 1 UNION ALL SELECT...

Hi Magy,

The main question is about you "untested" CTE:

SELECT ce.testerId, @partId as testId, 0 as resultCount,...