Yes Remi - the keyword is "sometimes"....

I'm not sure I understand the question - you have a view V1 where A1 > 10 and A2 > 23......

If you want a where A1 = something...can you not...

Read up on "Collations" on BOL - it should be a good starting point and gives you detailed information!

Specially when you're brand new to SQL Server and learning the ropes....even otherwise, they can come in quite handy!

Frank - have you "withdrawn" so Remi can catch up with you...

I usually just set a breakpoint where the sp is being called (vb 6) and take all the parameter values and run it in QA...works quickest and easiest for me!!!

Excellent except when it's downright useless...here's the example I was looking for from BOL -

"Show first level dependency only" - BOL says it means...

"View only first-level dependencies for the...

Look up sp_changedbowner first and then sp_revokedbaccess - BOL explains this and you can finetune this to suit your needs!

what about a select distinct * into a temp table, dropping the dupe table and then renaming the temp to original name ?!

that makes sense - tscott mentioned tables so I only tried it on a test table...

however, that has to be one of the scariest things I've seen - renaming an...

I usually don't attempt renaming any objects as I have quite a few dependencies on most of them (usually stored procedures)..

However, I cannot recreate what you posted - I just...

Okay - just pick it up from the other place - will have them notify you!

(Sorry!)

Yes indeed - & just so I don't make your address public (I'm sure you don't want that) - let's just say that it went "across the border" to Canada...

Know the best part Remi - agrees with all laws of physics; no illegal moves and still makes me the winner! <;-)

Did you not get the video I sent you ?!?! It's been over 5 days since I mailed it!

or this....

select top 1 Crdate from table

where Crdate (select max(Crdate) from table)

order by Crdate DESC