Hi!!!!!

Can u tell me ur table structure....and which fileld updated recently......do  u have any idea @ that...........

Hey RGS'us!!!!!!!

I want to update IDs in  REGSIST  table by IDs in GRANTED......

Is that possible.......

Hi!!!!!!

there is possibilities of retriving data which are newly inserted in original database by comparing it with mirror database but it is hard to retrive data which are updated....

Hi!!!!!!

there is possibilities of retriving data which are newly inserted in original database by comparing it with mirror database but it is hard to retrive data which are updated....

Hi!!!

As far as PK/FK relationship concern .... there is not possiblilities of UPDATEing

statement..But it will possible for u when u remove the Relationship between them and UPDATE PK table and then...

Hi!!!!!

SELECT SUBSTRING('intra_005561.pdf',0,PATINDEX('%.p%','intra_005561.pdf')) AS FIRSTPART,RIGHT('intra_005561.pdf',LEN('intra_005561.pdf')+ 1 - PATINDEX('%.p%','intra_005561.pdf')) AS SECONDPART

Hi!!!!!

Can u paste ur insert query by which u r inserting records in central server....

hi!!!!

Can u give me which query u run ...and what error msg u got there......

Hi!!!!!

as seen ur post ur not alias subquery here..

select * into #temp from (select convert(varchar,convert(datetime,Date_Lst_Iss),103),Part_Num from dbo.Part_Mast where Part_Num LIKE (RTRIM('258095GB') + '%')) P

and then run this ......

select...

Hi!!!

I agree with VLADAN......

here is ur solution..

SELECT * FROM TABLE1

WHERE MARKS NOT IN (SELECT MAX(MARKS) FROM TABLE1)

UNION

SELECT E.ID,E.MARKS FROM TABLE1 E INNER JOIN (SELECT ID,MAX(MARKS) MARKS FROM TABLE1 GROUP...

Hi!!!

Actually that was my mistake u should write this way.....

select * into #temp from (select convert(varchar,convert(datetime,Date_Lst_Iss),103),Part_Num from dbo.Part_Mast where Part_Num LIKE (RTRIM('258095GB') + '%')) p

Hi!!!!

U can do....

select * into #temp from (select Part_Num from dbo.Part_Mast where Part_Num LIKE (RTRIM('258095GB') + '%')) p

and now u can use....

select * from dbo.Part_Mast

where Part_Num in (select Part_Num from #temp)

order...

Hi!!!

U can do one thing here Go to EM and Delete that ID column by right clicking to it and again right click on the next column where u want...

Hi!!!

In ur subquery that getting two columns as output which compar with one column from outer query......

by removing convert(varchar,convert(datetime,Date_Lst_Iss),103) u will get output...

select * from dbo.Part_Mast

where Part_Num in (select Part_Num from...

Hi!!!

May be u r using join somewhere in your DTS so that duplicates row are inserted in ur backups.....or if it possible then filter in the DTS when data is...