You can also get these from SYS tables if you prefer:

SELECT b.name, b.object_id, b.parent_object_id, b.type_desc

FROM sys.all_objects a

INNER JOIN sys.key_constraints b

ON a.object_id = b.parent_object_id

WHERE b.type_desc = 'UNIQUE_CONSTRAINT'

UNION...

This may help you to find UNIQUE and...

Just having a little bit of fun here as the requirements are clearly unclear. 😀

DECLARE @Accts TABLE

(ACCOUNT VARCHAR(10), QTR1 INT, QTR2 INT, QTR3 INT, QTR4 INT)

DECLARE...

Here's another way using (mostly) Paul's set up data:

-- Demo table structure

DECLARE @Example

AS TABLE

( ClaimKey integer,

SequenceNumber ...

Can you provide expected results in each of the 4 tables after the update you want to perform is applied.

I looked at your description and maybe my brain is just...

I'm not sure why no one mentioned this (maybe I missed it?) but my favorite way to keep the pieces of a complex query understandable is Common Table Expressions.

I think...

I'll be honest that I don't really understand the way you've expressed your requirement, however I believe this solution matches the result set you listed.

-- Solution 3: List combinations up...

Eugene Elutin (9/21/2012)

---

SELECT COS($)

Will do the same, but it's to obvious...

I think the harder question would be: How to return 4 without using number in SELECT,

finding SELECT LEN($), would...

I'll settle for an honorable mention.

Still a tie then:

SELECT DAY($)

It runs in SQL 2008.

Oh!...

David Moutray (9/20/2012)

---

GilaMonster (9/20/2012)

---

I can think...

egerencher (9/21/2012)

---

Once again. It worked. GENIUS. OK. Here comes a curve ball. Instead of sum of transamt > 1000 in 2 days, how about sum...

egerencher (9/21/2012)

---

Let me throw this out there. If I need to get the same results, but instead of sum of transamt > 1000 in 2 days, I need to...