Doesn't look like you can do it that way.

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q319138

How should I format my case solution to get in on the testing?

Fun problem. 😀

This solution might be a little less CPU intensive because the only string manipulation is done with ISNULL or CASE tests.

The trick is to squeeze out the...

The code below will return only rows 5,6,7,8 from the sample table.

; with SampleTable AS

(

SELECT *

...

So this original requirement is off the table now?

Okay... so we want to see any group with two or more types that have two or more rows per type.

Now tell us again how codes fit into that. ...

We're getting there. You only want to see groupIDs that have at least 2 members of each type. But what about this case?

Group 99...

It may help to think of CTEs as views, since that's how they behave. Query plans generated from a CTEs may sometimes make use of a...

What does your execution plan for the query show? Could you post it here please?

Tommy is right. Adding CHAR(13) or even CHAR(13) + CHAR(10) to your output string does NOT create a new row. It just creates a...

JohnDBA (7/8/2011)

---

--I made a mistake...Sorry

I only want to see the records where count of Code >=2 group by GroupID

however, if and only if count of same type >= 2 group...

I don't think so, Jason. Your query returns all rows. You may be misreading his requirements.

John, can you please explain to us why number 7 in...

koustav_1982 (7/4/2011)

---

The Dixie Flatline (7/1/2011)

---

# 1. In your example, the optimizer uses the nonclustered index because it is a "covering" index containing all the columns needed to satisfy...

WC is right. I'm sorry for using the term 'inline' in such a misleading way.

Take a look at the OUTPUT clause used in conjunction with an UPDATE to create your temporary table. Why create a trigger? Just put the additional...