Take a look at using ROW_NUMBER() in MS BOL.

If you can't figure it out post some DDL and sample data (consumable form) where your query would return duplicates. Identify...

This should also work:

;WITH YOY AS (

SELECT Years = DATENAME(year, EnrollDate)

,COUNT(MemberID) as TotalMembers

FROM dbo.Enrollment...

Eugene Elutin (10/30/2012)

---

Jeff Moden (10/30/2012)

---

dwain.c (10/29/2012)

---

Sorry about...

angelrapallo 90775 (10/30/2012)

---

yes i have seen it yeah hey is not perfect

i could handle dynamic maybe in the future, becuase i use little dynamic, i use a different technique

to avoid...

Jeff Moden (10/30/2012)

---

Thanks for the compliment :blush: but seriously not...

webtekkie (10/30/2012)

---

Eugene - I didn't even notice your post earlier as I was posting at the same time. It's an excellent solution but sadly fails for the same reason...

webtekkie (10/30/2012)

---

Dwain - that's impressive! I'm going through it now to see understand what's going on here.

Jeff - I've checked with the data sourcing team - they have told...

Or you could construct a query against your table as follows to check total actual string lengths for both scenarios.

Assume the column (Your_Column) in your table (YourTable) is VARCHAR(100):

SELECT VARCHAR=SUM(2...

eugene.pipko (10/29/2012)

---

What about any other error? There is no front end. The result is emailed to the user.

I guess what I am trying to do is to let the other...

Jason-299789 (10/30/2012)

---

dwain.c (10/30/2012)

---

In the future, you should provide DDL and consumable sample data in the format I've included below.

-- DDL

DECLARE @T TABLE

(RecordID INT, ItemID INT, MaxOfCost...

In the future, you should provide DDL and consumable sample data in the format I've included below.

-- DDL

DECLARE @T TABLE

(RecordID INT, ItemID INT, MaxOfCost MONEY)

-- Consumable...

SQLRNNR (10/30/2012)

---

L' Eomot Inversé (10/29/2012)

---

I (installed and) ran SUPERAntiSpyware. It told me "I've found three things infected; I won't tell you what with, and I won't tell you which...

Angel,

This is indeed a pretty cool script.

I ran it against a small database of mine, after changing '[msdb]' to '[My database].' Aside from some of the information printed still...

Sorry about that! Just couldn't help...

Jeff Moden (10/29/2012)

---

Just to be sure, Value 1 will only contain 1 to 7 characters...