DesNorton (10/31/2016)

---

Eirikur's solution groups by PaymentComfirmDate.

In order to group by Year/Month, you will need to use something like this, which groups by the 1st of every month.

-- ...

MonthYear = DATEADD(mm,...

You still haven't...

Indices is the original Latin plural of index. Indexes is the Anglicized version of the plural. Both are acceptable in English....

david.jack (10/28/2016)

---

VAL1 can return NULL unfortunately so using a comparison operator...

Since this thread is almost three years old and the OP hasn't made any recent updates,...

I think that this approach may still be faster, especially with the right indexes in place. I created a Student table, a SchoolDay table, and the TruantDay. I...

Does your TruantDay table only contain absences or does it contain all attendance information? If it's all information, there is a much faster approach.

Drew

I think the only problem with your original query was using the ChildID from the wrong table in the second part of the rCTE.

DECLARE @Temp TABLE (descr CHAR(5), ChildID TINYINT,...

Actually, XML uses Unix-style line terminators (LF) rather than Windows-style (CR/LF), so it's not necessary to test for CHAR(13) unless the XML document specifically contains the character encoding for CR...

btio_3000 (10/27/2016)

---

declare @xml xml =

'<root>

<name>hand

<val>strong</val>

</name>

<name>mind

<val>beautiful</val>

</name>

</root>'

I need to return val...

sp_MSforeachDB does not automatically change the context to each database, so it executes in the context of the database where you originally run the query. Preface your dynamic SQL...

Actually, the problem is that you're converting int to char back to int. If you want integers keep them as integers.

DECLARE @START_DT AS datetime = '2015-01-01 00:00:00.000';

WITH E1 AS...

Depending on what indexes you have in place, one of these version may perform better.

SELECT ml.ID, ml.Cat, ml.Status

FROM #MasterList ml

WHERE NOT EXISTS (

SELECT 1

FROM #ListX lx

WHERE ml.ID = lx.ID

AND ml.Cat...

This thread is over seven years old, and the original poster hasn't logged in in almost seven years. At this point, it...

Jeff Moden (10/26/2016)

---

drew.allen (10/26/2016)

---

Jeff Moden (10/25/2016)

---

As a bit of a sidebar, it would have been nice if they had it default to a ROWS specification because it's faster than the...