Thanks, Gail. Coming from you, I can take it to the bank that there is no practical reason to need to see the contents of a non-clustered index therefore...

set @SqlString3 = N'

left join ClientProgram cpgm on cpgm.EnrollmentKey = ClientEnrollment.ID

and '''+convert(char,@ThruDate,101)+''' between

isnull(cpgm.effectivedate,'''+convert(char,@FromDate,101)+''') and

isnull(cpgm.expirationdate,'''+convert(char,@ThruDate,101)+''')

left join Program pgm on pgm.id = cpgm.ProgramKey

left join Program spgm on spgm.id = cpgm.SubProgramKey

where dbo.ClientEnrollment.Void is...

-- create a temporary stored procedure

create procedure #sp_TempReportMaster AS

create table #iFromDate (iFromDate DateTime)

insert into #iFromDate values ('JAN 1 2012')

create table #iThruDate (iThruDate DateTime)

insert into #iThruDate ...

Thanks, Craig. Actually, I wasn’t shooting for the highest value as much as expecting it because of the sequence in which I entered them. I was troubleshooting a...

I believe you gentlemen covered it and I thank you. Given that you cannot use an ORDER BY in an update, it sounds like I’m going to end up...

In the mid 90s I was stuck in a support position and desperate to join the deities (C programmers) on our team. I threw myself into learning C but...

When you are interviewing, be prepared to articulate precisely why you chose this specific career path. People who succeed over the long haul are the ones that do things...

Turns out, "relation" = "table". Had to get a computer science book from the 70s, when the concept was new, in order to get that definition in plain English. Otherwise,...

I'm not sure that is an accurate way to frame it. For those of you out there considering it, why not start your own business and work for yourself? It...

The last 10 years of my work life have been far and away the most rewarding and the last three in particular have been almost too good to be true....

It is a third party package overwhich I had no control but even if I did, I didn't know that the xml datatype was capable of that type of constraint....

XMLSQLNinja, thank for your time and alternative approach. I'm afraid that the garbage in my data is not well formed and this method stumbles as a result as does...

Hi Phil

I tested the UDF and it works great. But I am having a tough time wrapping my brain around or uncovering what is going on here. ...

Thanks much, Phil for both the code and the link.

I was leaning toward CLR but this is a third party database and makes me a bit nervous. ...

Only in the query. I don't want to update the table.