It looks like he wants to sort by the root process. He has an adjacency list of processes and blocking processes. Take a look at the following article...

Eric M Russell (5/11/2016)

---

TheSQLGuru (5/11/2016)

---

Eric M Russell (5/11/2016)

---

drew.allen (5/11/2016)

---

Eric M Russell (5/11/2016)

---

For what it's worth, this one can be paramaterized in terms of the number of dates returned, and it...

Reported as spam.

Most of the people here don't speak Portuguese. You might have better luck if you posted your question in English.

Drew

It would help if you provided sample data and expected output.

My first question, is whether you really need to reference a table for your various DoNotX attributes. Do they...

An empty string is not the same as a NULL string. An empty string is...

Eric M Russell (5/11/2016)

---

For what it's worth, this one can be paramaterized in terms of the number of dates returned, and it doesn't require a pre-existing tally table, which might...

Use the Inserted pseudo table rather than the Payment table. Use the inserted and deleted tables

Drew

SQL XML

Drew

o103452 (5/10/2016)

---

drew.allen (5/9/2016)

---

The 445 and 454 fiscal years only have 364 days. You have only given data for one fiscal year, so it's not clear how you are handling...

Andrew P (5/9/2016)

---

Have you tried CAST(STUDENT_CRS_HIST.JOB_TIME AS DATE)?

The below query would give you a list of distinct dates.

SELECT DISTINCT CAST(STUDENT_CRS_HIST.JOB_TIME AS DATE) AS JOB_DATE

FROM STUDENT_CRS_HIST

For an alternative, check out...

The 445 and 454 fiscal years only have 364 days. You have only given data for one fiscal year, so it's not clear how you are handling that extra...

Lowell (5/9/2016)

---

The group by is fine if you...

This is not valid xml, because there is no single root element. In fact, you have text that is not contained in an element at all.

Drew

You should be able to figure this out from the answers that you received to your post on XML to SQL tables

Drew