Change the FAST_FORWARD option to FORWARD_ONLY STATIC.

Universe

Your WHERE clauses are converting your LEFT JOINs on Status and Borrower into INNER JOINs.

I would initially change this:

FROM Dbo.[VDSMeetingInformation] VMI

INNER JOIN dbo.[DelimitedSplit8K](@fund_id,',') fnsplt ON VMI.FundID =(CASE WHEN fnsplt.item IS NULL THEN VMI.FundID ELSE fnsplt.item END)

WHERE VMI.customerID = @customer_id

AND VMI.MeetingDate BETWEEN @Start_date AND...

Did you considered Koen's suggestion?

I reformatted your conditions to make it clear what you're doing.

IF NOT EXISTS (

SELECT...

LoudClear (9/10/2015)

---

Yes, my argument has heretofore been

From above article: "Invariably, someone at some point is going to come in and add a column, remove a column, or change...

Is there any difference when using clustered indexes instead of heaps?

The underscore is a single character wildcard.

You need to change your condition to one of these options:

select distinct specialty

FROM [dbo].[Import_ClaimData]

where specialty like '%[_]%'

order by 1 desc

select distinct specialty

FROM [dbo].[Import_ClaimData]...

Sean Lange (9/9/2015)

---

You know that when you don't bother to put in any effort into providing details it ends up coming across as though you want...

Do you realize that the STUFF function is not the one concatenating the rows? The stuff function is only replacing the first character (a comma) with an empty string.

Try understanding...

This is a violation to the first normal form. Avoid storing several concatenated values and use an appropriate design for this.

In order to be able to do what you want,...

My crystal ball is showing a query like this:

WITH CTE AS(

SELECT ROW_NUMBER() OVER( PARTITION BY Patient

...

cory.bullard76 (9/9/2015)

---

Thanks...That's what I thought at 1st. But, it's pulling the BINNO for Grant instead of Commercial when I use that. I want Commercial 1st if they have...

Just add more conditions:

case when inscomp.payor = 'COMMERCIAL' then INSCOMP.BINNO

when inscomp.payor = 'Grant' then INSCOMP.BINNO

when inscomp.payor = 'Part D' then...

World