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

I am only familiar with SSRS (and another tool I will mention in a moment) but have seen others have luck with Cognos and Tableau for OLTP and OLAP environments....

mario17 (10/28/2013)

---

Hi,

I'm trying to make one of parameter and grouper in my SQL optional, is it possible, for now I'm thinking:

1. in SSRS make parameter UseParam1 = Y/N

...

Take a look at what happens when you change @BDate to...

todd.ayers (10/24/2013)

---

How could I write a sql statement to where I could get an age in one field based off typing a date in another field?

I am trying to get...