You shouldn't store lists for delimited values in a single line for a single value. It violates the first normal form.

If you really need this (I suggest to use it...

I would let the database do the work for me. Just to be clear, a single constraint that involves all 3 columns should be fine instead of 3 unique constraints.

There's not enough information on what's happening. The problem is too generic and can't be solved.

For performance problems, check the following article:http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Jim P. (2/19/2014)

---

phonetictalk (2/19/2014)

---

I have this problem! I have my phone by me all day and forget to plug it in. Then, when I'm out & about and go to...

I'm not sure that your expected results are correct because you say that if you pass "Cooking Candy" as a parameter, you should get "Cooking Waffles". If that's incorrect, this...

sql2k8 (2/19/2014)

---

I have to rewrite the code in another language. This correlated subquery is not working in the another language. So i am trying to rewrite the code without correlated...

sql2k8 (2/19/2014)

---

The below query works fine. I am trying to rewrite the code without using the sub query. In the end i should get the same results for both the...

It seems correct to me. What's the problem? Can you post sample data (check my signature to know how to do it properly)?

None of the solutions given depend on the field starting with C or P. However,...

That's why I included a link to BOL. You should check it to know exactly what's happening. Be sure to ask any questions you have after reading it.

Here's an example...

You could do it easily with the STUFF function.

Would you need help on how to do it?

To get last 7 days of data, you could use some datetime formulas like this:

WHERE DateColumn >= DATEADD( DAY, DATEDIFF(DAY, 0, GETDATE()) - 7, 0)

AND DateColumn < GETDATE()

Maybe something like this if you just want to eliminate duplicates while displaying the information:

WITH CTE AS(

SELECT *,

ROW_NUMBER() OVER(PARTITION BY LEFT( Name, CHARINDEX( '.', Name + '.') - 1)...

It's good to know that it worked for you. Do you understand why does it work and how? Do you have any questions you would like to ask?

For future posts,...

He posted...