Viewing 15 posts - 46 through 60 (of 302 total)
Hi
So here is some sample code for the first 15 fields
and attached is a sample of the entire XML
Thanks
SELECT People.[First Name],
...
January 15, 2020 at 10:01 pm
Thanks Lynn,
let me work on this and I'll send a better sample
January 15, 2020 at 9:38 pm
Sorry for being SO vague, just wasn't sure what to ask....
So the XML, I posted was part of a layout I received for data to send on a monthly basis...
January 15, 2020 at 9:05 pm
Sorry
Also alot of tables are being called from another Database
October 18, 2019 at 8:56 pm
Ahh got it!
Works as I need . I wrote the data out to a temp table using a cross apply then chose the values as needed .
Thank you
September 25, 2019 at 8:06 pm
Thank You
Eddie and Drew...
I appreciate the info and the learning experience....
September 19, 2019 at 5:26 pm
Hi Eddie
Thanks so much, I get the logic, but not to sound dumb...
How do I incorporate this into a select statement ?
where 'data' is coming from xdoc table
FROM data.dbo.CalendarEvents AS...
September 19, 2019 at 2:24 pm
Got it...
needed Double quotes encasing the double quotes in the text ...
Thanks for your time...
CASE
WHEN x.Data.exist('Data/Treatment_x0020_Focus/PACT_x005F_x0020_Service_x005F_x0020_Note_Treatment_x0020_Focus_Option
[Name="N/A = Skip to ""Other Information"""][Checked="true"]') = 1
THEN 'Yes'
END AS [NA],
May 28, 2019 at 9:46 pm
This is the XML data
</Location>
<Treatment_x0020_Focus>
<PACT_x005F_x0020_Service_x005F_x0020_Note_Treatment_x0020_Focus_Option>
<Name>N/A = Skip to "Other Information"</Name>
<Checked>true</Checked>
</PACT_x005F_x0020_Service_x005F_x0020_Note_Treatment_x0020_Focus_Option>
May 28, 2019 at 9:28 pm
February 5, 2019 at 12:49 pm
Hi Eddie
Sorry, one more question on this
Can I grab the "Name" field if the "Checked" field is 'True'?
if the field is setup as a for only one...
October 16, 2018 at 10:54 am
Hi Eddie
Thanks, that exactly what I needed.
I just tested it works great is is much faster than the "Mess" I put together 🙂
Thanks
October 15, 2018 at 3:02 pm
Viewing 15 posts - 46 through 60 (of 302 total)