That's XML. You should be using the built-in XML functionality to shred the XML document. If you provide a more complete sample, we can help you with that.

Drew

Jeffery Williams (10/6/2016)

---

I will give it a try thank you. AND I don't have to count I just need to know if the result is greater than 0. Basically...

Jeffery Williams (10/6/2016)

---

I need to have a case statement in within a JOIN. The condition needs to be a SELECT,

Basically I need to see if records exist that matches a...

Simply replace the periods with something else before replacing the greater than sign with a period. It's up to you whether you restore the periods after the PARSENAME.

Drew

Have you tried Scott's approach?

I also want to add that this violates 2nd Normal Form. Have you considered how you want to handle it when one of the codes gets...

valeryk2000 (10/5/2016)

---

CELKO: Do not understand - is it about script from my post of Posted 9/27/2016 10:05:34 PM? This is just a result of query that I originally sent...

Hugo Kornelis (10/5/2016)

---

What...

How about just changing the declaration of @StartTime2 to SMALLDATETIME?

Drew

Thanks! I...

LAG (Transact-SQL)

Drew

With my first article for SSC accepted for publishing, I've already written a second (unrelated) article. I'd like to have a couple of people review it.

This article is meant...

Sean Lange (10/5/2016)

---

Is there any other kind? 😛

Whatever the spam was it didn't last very long as I can't see it at...

And now we're getting blatantly fraudulent spam. :angry:

It's really hard to provide suggestions without sample data and expected results based on that sample. (See the first link in my signature about how to provide that.)

The main...

Usually when people need information associated with a last instance of something, the correct method is to use a CTE that includes ROW_NUMBER with the proper partition and order and...