That wasn't the only attempt on that day. Here's a completely lost Oracle user.

But hey, as long as I can help.

I'm just wondering why would you need to update these columns as you shouldn't store values this way if you want a normalized table. And if this is for a...

What are you expecting to accomplish with the subquery? It basically compares one column to itself joined by the same condition.

Dancing Queen

You need at least three tables in your join which you refer as a, b & c. You're doing a UNION between 2 SELECTs and but you don't define...

Here's one option. Maybe you were very close.

I know this is a 2008 forum, but you mention that you're using LAG (which was introduced on 2012).

WITH SampleData AS(

select '01' as...

yb751 (7/29/2015)

---

Luis Cazares (7/29/2015)

---

You conversion won't help as it will only truncate the string. It will basically do the same as the LEFT() function. Another problem it that 111 is...

Eric M Russell (7/30/2015)

---

You definately need some form of index on logDate column. Not only is that column determining the final sorted output, but it is also the key for...

Brandie Tarvin (7/30/2015)

---

GilaMonster (7/30/2015)

---

Yup. In fact I told some people recently to put nolock onto a bunch of...

Could you post sample data and expected results?

I have an idea of what you want, but I'm not completely sure. If possible follow the advice of this article to post...

NOLOCK hints can be useful to get estimates of certain data.

To use it on every single table and every single query is just nonsense and lack of efficiency in laziness...

Today I was wondering when would your article would come out, then I opened the newsletter and it was there.

I'll give it a read after a cup of coffee.

Thank you...

yb751 (7/29/2015)

---

Well we had a REPLACE and a LEFT solution why not add a CONVERT. 😉

DECLARE @mytable TABLE (myDate VARCHAR(20))

INSERT INTO @mytable

VALUES ('2015-07-28 00:00:00'),('2015-07-29 00:00:00'),('2015-07-30 00:00:00')

SELECT * FROM @mytable

UPDATE @mytable

SET...

sheaS (7/29/2015)

---

Thank you for such a quick reply. Yes, I can convert it to a date, actually in the new app, I had these columns setup as dates but I...

Would you be able to convert this column into a date column? That would be a much better option as it will only allow valid dates, remove the time portion...