High praise coming from one of the maestro's of data manipulation......

I have to admit... that's about the most colorful congrats I've seen on these forums! Thanks Domagoj!

David B (7/1/2008)

---

Good Stuff 🙂

I know I have pointed every SQL developer that has come through our doors to at least one of Jeff's articles. Some of the code...

GilaMonster (7/2/2008)

---

Congrats Jeff. When you get down from cloud nine, let us know. Don't rush though, this doesn't happen every day....

Venkat Gotur (7/2/2008)

---

My hearty congratulations to my friend Jeff!!

Jeff taught me lot of techniques and he designed coding standards in our company which significantly improved the quality and perfomance of...

sushila (7/2/2008)

---

Cannot think of two more well-earned awards - I'm glad to see hard work appreciated and recognized - guess you now find that it's been well worth your time...

Oh my... wow... WOW! HOLY MACKERAL! :w00t::blush:

Ok, I've gotta tell you... It's all because of the good folks on this forum, both current and in the past. I've...

Obviously, you'll need to fix the error...

Part of the whole problem on things like this is the condition of the data. For example, I downloaded the provider list for...

gaurava16fc (7/2/2008)

---

CREATE function dbo.udfGetNumVal

(

@strInput nvarchar(50)

)

Returns DECIMAL(18,0)

AS

BEGIN

DECLARE @iCtr INT

DECLARE @AscVal INT

DECLARE @NumVal NVARCHAR(100)

SET @iCtr = 1

SET @NumVal = ''

WHILE @iCtr <= Len(@strInput)

BEGIN

SET @AscVal = Ascii(substring(@strInput,@iCtr,1))

IF (@AscVal >= 48) and (@AscVal <=...

You made a BCP FORMAT file like I suggested, eh?

d_sysuk (7/1/2008)

---

Well going to the first post, its clear the the post is most unclear in its requirements. Shouting at posters wont help under any circumstances or imposing random...

bitbucket (7/1/2008)

---

per rbarryyoung:

Except that that is NOT what was wanted. What was wanted was:

Eliminate One row from each distinct Group.

With the Following restrictions:

...

Heh... crack was showin'... :hehe:

GSquared (6/30/2008)

---

Some people just apply what I call "professional rituals". They've been taught the magic words and the mystic gestures, they know that when you say "waz zug cho...

Heh... this all reminds me of another of my favorite 4 letter acronyms... [font="Arial Black"]RTFS[/font]!!!!! 😀

Yeah... I'm out'a here, too! Nice job to the folks that actually read...