The information you give is quite limited so this is going to require some guesswork. But perhaps this works:

SELECT CaseStatus, Case_Group, COUNT(CaseStatus) AS CASE_GROUP_TOTAL

FROM dbo.MCJ

WHERE Case_Group IN ('INPATIENT', 'Outpatient')

GROUP BY...

Julie, from this point on two things can happen.

One is that me or someonee else, despite the still incomplete information you have given, decides to start guessing what the missing...

You might want to reread Sergiy's second post in this topic. That's the one that...

nm.rajesh (1/17/2016)

---

Hi All,

I Have a Table with the values as shown below :

IDcode recoIDPostmtsa_m DesiredFlag

19990104220791236917.2 1

20000104220791236917.2 1

34330104220791237017.2 1

45430104220791237017.2 1

16560104220791237322.6 0

26610104220791237322.6 0

36610104220791237422.6 0

1661010422079127050.4 ...

Sergiy (1/21/2016)

---

MMartin1 (1/21/2016)

---

You assume a bit much though. The OP might have a situation where he needs to deliver a result now, and take care of database Normalisation after. We...

I don't think that's possible.

Also, even if you know what data is from dirty pages, you still do not have the full picture. Using read uncommitted can also cause data...

Greg Edwards-268690 (1/21/2016)

---

Steve Jones - SSC Editor (1/21/2016)

---

Greg Edwards-268690 (1/21/2016)

---

It seems he has an elephant on the menu, and a 6 quart pot to cook it in.

But refuses to start...

Phil Parkin (1/21/2016)

---

I love a good understatement.

I get very irritated when we...

Not true. Without a clustered index (i.e., in a heap), SQL Server needs to use...

You really need to give us more information than this.

Mike has included a set of two links in his reply to you. Please click them, read them, then follow the...

To avoid the duplicates, extend the WHERE clause of whichever version of the query you picked with something like this:

AND NOT EXISTS (SELECT * FROM fecon2 AS f2 WHERE f2.productcode...

Small footnote to Mike's solution. This works well when UserID is guaranteed to be unique. Otherwise it is a bit risky. If, for instance, rows #100 and #101 are for...

For the timestamp and user of creation, you can use default constraints.

For the timestamp and user of last update, you have to use an ON UPDATE trigger. Use the inserted...

Though I am happy to hear that he feels that he has heard enough to be able to solve it, I am at the same time concerned. Based on his...

Me, too