i'm sorry if i seem to be asking foolish questions but raj - are your column names 'num1', 'num2' etc... or did you just display that for brevity ?!

in other...

seems to me there's not much you can do to prevent something like this...however, instead of a lenient approach (1, 2, 3 strikes you're out...) - if indeed you, Andy...

well - they do say that imitation is the sincerest form of flattery...rather than have this leave a bad taste in everyone's mouth, maybe we should shift the perspective &...

LOL...

Mike - if you have some time c'mon over to the other post "sql query again - complex" in this forum and see if you can shed some light...

oops -...

raj - do a "select * from BETS" & post the results here as sara suggested...maybe if we can look at the data, we might be able to help!

ivelisse - let us know how it goes...don't mind us - we're "meeting" after a while hence catching up!

no indeed - more like gaggis - yuck!

it HAS to be the blackbird pie....how quickly you forget!

ok...then first run:

"drop table #TempBets "

then run the rest of the statements...

..in that case a "select distinct * from myTable" should give you what you're looking for!

yes - mike - i do owe you!

raj - put an "END" after the (THEN 1 ELSE 0) and run it again!

btw - is there no way you can change the schema of your table (as Chris...

and your result set should contain:

Date Unit Company_Name

4/2/05 bu002...

change your query to:

INSERT INTO dbo_Versuchsart

SELECT * FROM AuswahlVersuchsart

is this something where a "select distinct" won't do ?! there could be duplicates of any or all fields - or a combination thereof ?! could you provide some more...

oh - here's something - says world telephone numbering guide - don't have time to see if they're any good...

http://www.wtng.info/

google! google! google!

i did and didn't come up with any sites worth posting!