Thanks to both Jeff B & Jeff M -

Jeff Moden - u have given me a real good idea !

1. Creating another Table ,

2. making the UNIQUE IGNORE...

Would it be easy to :

- select distinct and store in temp table

- delete the table

- re-insert back

- Just pondering - That would mean - more...

SQL Champs , I have Doubts pertaining to DELETE command to be used for a specific scenario :-

example # 1

Actually - Consider...

Thanx , SQLbill 

Any1 else with Suggestions, I guess a lot of the SQL Pros here would have embarked sometime or the other in...

hey Andy/David

thanx a lot for ur Post ---

BUT, theres another Problem ?

After i put

SET Identity_Insert ON

& SET Identity_Insert OFF

--- IT SAYS

"

String or Binary data would be Truncated.

The statement...

Hey !

Currently, i have this weird Error message :-

" Cannot insert explicit value for Identity column in #Test______________00010000017 When Identity_Insert is set to OFF "

Can any1 here Guide me -...

Thanx , Prasad/Sushila FOR ur help;

I finally Got tat Sorted out !!

@ Lowell : Thanx for ur Help !!!

This is Latest StoredProc after I made it a little more Compact BUT the problem/Task remains !!!

I...

Hey SQL ppl !

Now i am using the Following StoredProc-Code ; Can any1 Suggest a Better/Compact method of Doing the Above...