i think we are missing something . when you run this from query analyzer how many records does this return and what are the records which are unexpected one's.

select...

Hi there,

i just gave u a guideline. whichever conditions are redundant you can do away with them. feel free to modify the query to match your requirements.

HTH

How about this one

DELETE FROM b

from

Chg.dbo.na_log a

inner join

Base.dbo.na_log b

on a.na_tr_code = b.na_tr_code and

and a.na_acct_nbr = b.na_acct_nbr and

and a.na_seq = b.na_seq and

and a.na_subseq = b.na_subseq and

a.Update_Type...

you can play with NEWID and order it ,to get the records in random order. i had seen this article on another site. if the moderators are comfortable with...

You can use Copy database wizad or sp_attachdb and sp_detachdb too.

This might be useful http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q246133&ID=KB;EN-US;Q246133& .

hi crosspath, is your primary key a identity column. if so, i think that would be a a bad choice for a pk. if not , then you can always...

You can be better off generating scripts for your entire db this will give you description of every object including your sp's too.

you have to do away with Read_Only option in your cursor declaration. when you do that you can use WHERE CURRENT OF option and do what you are looking for...

Can you explain more on that raghu, might be post your table schema .

if am not missing anything(though am sure i am:( ) ,you can use a distinct clause and...

if you dont want any locks to be implemented then you have specify a nolock hint on the select.

eg:

select * from tablename with (nolock)

HTH

I think this isnt the ideal forum to ask a question like that. you should be better off with dbforums.com .