If I understand what you are doing here you have 2 parameters. 1 is Name and the 2nd is a comma delimited list? I think what you need to do...

You should take a look at Gail's blog post about multiple execution paths. It will explain why you sometimes see horrible performance and for other parameters you don't.

http://sqlinthewild.co.za/index.php/2009/09/15/multiple-execution-paths/%5B/url%5D

Steven Willis (7/10/2013)

---

I use this syntax in my where clauses rather than case statements:

WHERE

((@StartDate IS NOT NULL AND StartDate >= @StartDate)

OR

(@StartDate IS NULL))

...

puja63 (7/10/2013)

---

Sure, is this what you mean?

create table #Something

(

CustID Char(10),

SurveyId char(5),

ResponseDate datetime

)

insert #Something

select 'Cust1', '100', '5/6/13' union...

UGH!!! Any chance of changing this? Storing "dates" as nvarchar is a really bad practice. It makes for very challenging validation...

shane.stitts.ctr (7/10/2013)

---

Thanks for the help, but to clarify my question some, I am trying to return the list of names of people who will be expiring in 30 days. (I...

ShuaibV (7/10/2013)

---

Hello

Can someone please share if there are any functions or code to validate the Date in different format settings?

Ex:

----

If I enter the value "9999", the function should validate against...

shane.stitts.ctr (7/10/2013)

---

Believe me when I say that I have googled this and searched this forum up and down and either don't understand or can't find the answer I am looking...

It isn't too bad but can you turn your data into something readily consumable? A good example is what I posted in your other thread. It makes it a LOT...

Nope won't work going forward. You can go the other way (connect to an older instance from a newer one). This is much like backups, they are not forward compatible.

COUNT(DISTINCT CustomerID)

Here is another way...

create table #Something

(

CustomerID char(5),

CustomerName char(5),

AcctID int

)

insert #Something

select 'Cust1', 'Peter', 123 union all

select 'Cust1', 'Peter', 345 union all

select 'Cust1', 'Peter', 567;

with OrderedRows as

(

select CustomerID, CustomerName, AcctID, ROW_NUMBER() over(Order...

Here is a screen shot of what I have been working on.

Give me a couple days to get it all cleaned up and I will send it along.

riya_dave (7/10/2013)

---

select distinct rl.Id,

rl.AlarmId, rl.Name

...