Just a note, make sure the input streams are sorted in the same manner. I have seen where they were not and the data...

Assuming it is the 'Sick' hours that you are mainly focusing on , the following is as simple as I can code it:

selectcid,

sum(case when hr_type = 'sick' then 0...

Are you querying everything from one table or doing some type of join(s)?

Thanks Steve. Good straightforward question. I take it the capital Q means Quit (I'm not a sqlCmd user).

Ok maybe the defaulting of the bit field to 'false' is a little "bit" tricky. Part of the...

Ditto,

First name can be 'John' OR 'Linda' but cannot be both at the same time (which is what a AND condition is implying).

I figured B, though I was struggling with D and was glad that the options were this or not this rather than figuring out the math on D 🙂

This may not sound elegant, but a two step approach is to query out the entire xml string with the Results To File setting selected. Save the results to a...

The...

Briceston (11/1/2016)

---

Thank you for your insight. Your example was not exactly what i needed to answer my question, mainly due to a new Id is issued for a readmission. ...

Does this help ?

DECLARE @tbl TABLE

(

id INT,

col XML

)

INSERT INTO @tbl

VALUES

(1,'<name><name1>aht</name1></name>'),(2,'<name>6</name>')

select *

from @tbl

where col.value('(/name)[1]','varchar(10)')='aht'

Thanks Ed. No tricks, though it is the day after...

Below is a sample of the underlying data. Please excuse me if I did not use the correct code, and for the headers not being completely aligned.

Reporting YearReg AreaOrignalAdmissionOrignalDischargeReadmissiondischargedatedays between...

Hello, our server hard disk crashed due to power failure and all the backups were on the hard disk. Before just before it did we had managed to copy the...

Lynn Pettis (10/28/2016)

---

Chris Wooding (10/27/2016)

---

Just as an aside; I have got into the habit of using the "Script as create" instead of "Script as alter" or "Modify" options when looking...