I think that this is what you are looking for.

SELECT *, ROW_NUMBER() OVER(PARTITION BY Companyid, DateFrom ORDER BY DateTo DESC)

FROM #temp

ORDER BY CompanyID, DateFrom, DateTo

Drew

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...