TheSQLGuru (6/18/2014)

---

Spammers have clearly developed a mechanism to beat the "click on this email we send you" mechanism SSC.com uses to keep out junk posters. Something else is needed....

Not totally sure what you are looking for but I think this is close.

select ID

, case when MIN([text]) = MAX([text]) then 'Matched' else 'Unmatched' end as MyAnswer

from #test

group by ID

Ed Wagner (6/18/2014)

---

sing4you (6/18/2014)

---

SQLRNNR (6/18/2014)

---

Sean Lange (6/18/2014)

---

Ed Wagner (6/18/2014)

---

JAZZ Master (6/18/2014)

---

SQLRNNR (6/18/2014)

---

Ed Wagner (6/18/2014)

---

SQLRNNR (6/18/2014)

---

Sean Lange (6/18/2014)

---

whereisSQL? (6/18/2014)

---

Ed Wagner (6/18/2014)

---

JAZZ Master (6/18/2014)

---

Stuart Davies (6/18/2014)

---

With all the food...

Ed Wagner (6/18/2014)

---

JAZZ Master (6/18/2014)

---

SQLRNNR (6/18/2014)

---

Ed Wagner (6/18/2014)

---

SQLRNNR (6/18/2014)

---

Sean Lange (6/18/2014)

---

whereisSQL? (6/18/2014)

---

Ed Wagner (6/18/2014)

---

JAZZ Master (6/18/2014)

---

Stuart Davies (6/18/2014)

---

With all the food being mentioned, I was getting hungry...

Also make sure you have a GO after your procedure code or the procedure will end up trying to call itself.

Create PROC [dbo].[spAdminFundedDateee]

AS --needed

Begin

SELECT...

SQLRNNR (6/18/2014)

---

Sean Lange (6/18/2014)

---

/RANT ON

Argh!!! Why do some people around here consider me to be their own private consultant. They send me a PM with a vague description of something...

Rain

/RANT ON

Argh!!! Why do some people around here consider me to be their own private consultant. They send me a PM with a vague description of something and ask me...

No need to apologize for anything. You asked a very legitimate question...

True that.

Seems that once again Luis "Sir Speedy" beat me to the punchline again. 😀

Thank you for easily consumable ddl and sample data!!!

Not sure what that crazy order is in your query. Just order by the columns you want ordered.

SELECT u.CID, ...

ggoble (6/18/2014)

---

If I run a single query of a bunch DELETES statements and it is not wrapped in a BEGIN TRAN, COMMIT TRAN Will my deletes commit after each...

Good grief. Maybe they should just disallow any new accounts for the remainder of the world cup. So much spam.

Stefan Krzywicki (6/18/2014)

---

Sean Lange (6/18/2014)

---

Grant Fritchey (6/18/2014)

---

SQLRNNR (6/18/2014)

---

jasona.work (6/18/2014)

---

GilaMonster (6/17/2014)

---

Gotta love a review system where an above-average rating requires "Leaves only when work is done and stays to assist others"

"No...