How do you get the parameter list? Is it a query where you could you simply add a DISTINCT?

If I understand correctly, this article explains what you need:

http://www.sqlservercentral.com/articles/comma+separated+list/71700/

Yes, I saw that after Ed replied and didn't want to repeat it.

Thank you for the feedback.

I'm not sure if you can do that, but why don't you remove the permissions to restore backups on the database for that user?

That's the expected output, where's the sample data?

My options should give you that total. How is it wrong?

This article can help you accomplish what you're looking for:

http://www.sqlservercentral.com/articles/comma+separated+list/71700/

Can you be more specific? What's wrong with what I posted?

I could help you better with sample data and expected output as described on the article in my signature.

You could change your approach to a traditional CROSS TAB.

You'll end with something like this:

--Normal cross tab

SELECT Hospital,

p.subjectnumber,

COUNT ( CASE OralAnticoagulantID...

Maybe this code can help you. 😉

SELECT ISNULL(

REPLACE(

...

Hi Andrew!

Could you remind me your previous username? My ADHD won't let me remember. 😀

Naomi N (6/6/2014)

---

Luis Cazares (6/6/2014)

---

Naomi N (6/6/2014)

---

Peter,

I think we wanted customers who bought A and B but not C, so your query will be even simpler,

MIN(productID) = 'A' and MAX(productID)...

What if we...

djj (6/6/2014)

---

Luis Cazares (6/6/2014)

That's why I consider zip codes, phone numbers, credit card numbers & others should be stored on string type columns. You could enforce to use just digits...

LOL :hehe: My fault.

I know the difference, I'm not sure why did I write it wrong...

djj (6/6/2014)

---

An expert converted our database from Access to SQL2000. We now have zip codes that are float, column names with spaces and #.

One thing I do...