ShinyK (11/10/2016)

---

By default, the Lookup operates as an INNER JOIN - but we need a LEFT (OUTER) JOIN. Click the "Configure Error Output" button to open the "Configure Error Output"...

If these do represent the source, think of the maintenance nightmare when the source changes, or another is added. This is not the way to design IMHO....

What is the rule if you have three people named Bo Derek, or four people named Joe Smith? In the prior code run I see that the last one...

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