dwain.c (9/23/2013)

---

matt6749 (9/23/2013)

---

I respect your wish to have structured forum dialog, but it appears that, for this relatively simple question, helpful suggestions are possible without INSERT INTO and CREATE TABLE...

Thanks Dwain!

Solomon Rutzky (11/5/2013)

---

Alan.B (11/5/2013)

---

With your question about reasonableness, it's up to you. If performance wasn't an issue, why maintain two different functions? If it does matter, you can create a...

Thanks!

With your question about reasonableness, it's up to you. If performance wasn't an issue, why maintain two different functions? If it does matter, you can create a calculated column on...

Forgive me if the code to do this has already been posted but I had a requirement for a greater-than-8k splitter. I made the following changes:

1) Changed @pString to...

Jeff Moden (10/31/2013)

---

Heh... hate to throw a...

No Problem:-)

I don't know if a CLR is going to be the...

I've run into this before. Take a look at this article: http://nerdwords.blogspot.com/2010/01/sql-server-error-conversion-of-xml.html

As far as speed is concerned, mine is still in the top 5!

First, is the application executing a stored procedure or an Ad Hoc SQL Query? If it's Ad Hoc SQL you will want to put the query into a stored procedure....

There should be a way to do this without these self-joins but I can't figure it out. That said, this will do the trick:

WITH distinct_ids AS

(

select DISTINCT t1.id, MAX(t2.rnk)...

harsimranjeetsinghwasson (10/24/2013)

---

Not Able to get Assistant days now by open xml

DECLARE @Payrollhandle int

DECLARE @Payrolldoc VARCHAR(MAX)=

('<Payroll StartDate="2013-10-30" EndDate="2013-10-31">

<Doctor ID="74962">

<WorkDays>

<Office ID="60101" Days="23"/>

<Office ID="60102" Days="23"/>

</WorkDays>

<AsstDays>

<Office ID="60101" Days="23"/>

<Office ID="60102" Days="23"/>

</AsstDays>

</Doctor>

</Payroll>')

EXEC SP_xml_preparedocument @Payrollhandle OUTPUT,@Payrolldoc

SELECT

*...

XML questions don't always get much love around here. Here's what you are looking for:

EXEC SP_xml_preparedocument @Payrollhandle OUTPUT,@Payrolldoc;

SELECT A.*, B.AsstDaysOfficeID

FROM

OPENXML(@Payrollhandle,'Payroll/Doctor/WorkDays/Office',8)

WITH

(DoctorID INT '../../@ID',

WorkDaysOfficeID VARCHAR(10) './@ID') AS A

OUTER APPLY

OPENXML(@Payrollhandle,'Payroll/Doctor/AssDays/Office',8)

WITH...

Yes but it will be more work to secure.

We have a database of...