That's probably right in SQL Server 2000... dunno about 2005 with that nice new RowNum and PARTITION OVER statement.

I do gotta ask though,  why on Earth are you declaring an...

Hi there, Koji,

Got your private message and thought I'd post my reply here so that others can see it, as well...

Koji,

There's not much to a Triangular Join (least, not up front)......

Please don't cross-post...

Please don't cross-post...

Please don't cross-post...

Please don't cross-post...

Actually, there's a lot that will trip up ISNUMERIC... please see the following URL...

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=243646&p=2

So... if you want an ISALLDIGITs and still allow conversion to the MONEY data type when...

heh... I guess I'm just gonna have to break down and upgrade one of these near days...

Not sure where to look, Koji... it's mostly personal experience.  Like I said, it's really half a cross-join... I guess my suggestion would to be to readup on cross-joins and...

Um.... they don't want it in T-SQL... they want an expression in SSIS and they said IsNumeric Doesn't work there...

Nope... not kidding.  THAT level of intelligence or training was, apparently, missing.  And, it's really hard for me to think that maybe I didn't ask the question correctly because I drew...

Yes... computer science is dead even if you have a degree in it (not you personnally, just a general observation). 

I've interviewed many a person that have Masters degrees in...

Dont worry... it's not a trivial question...

There's a half dozen or more ways to do such a thing... Koji posted one of them... but, beware... Koji's code relies on...

Very cool... thanks for taking the time, ALZDBA!

Not a problem... didn't take it offensively but I appreciate your feedback.  I still wouldn't mind finding out what the performance of your dupecheck is on SQL Server 2005 because...