Appreciate your quick response.

Well I would like to add only if that is not present already. If it already exists, then I won't.

So how can I do that.

Many thanks n...

This is what I tried and succeeded.

select

(

select (count(ip.process1status)) from item_process ip where ip.item_id = i.item_id and process1status <> 0 and p.pagename like '10_001%' ,

select (count(ip.process2status)) from item_process ip where ip.item_id...

Yea Jeff, I'm working on it. I has posted the reply there but missed out post one here.

Thanks anyways.

--Ron.

 Yea Jeff, I'm working on it. I have posted the reply there but missed out to post one here.

Thanks anyways.

--Ron.

Okay, so now I dropped the server

sp_dropserver 'Computer-1'    (which is my new server name)

then I again added it using

sp_addserver 'Computer-1', 'local'

After this i restarted the services and issued

SELECT @@SERVERNAME

and it worked.

Thanks...

Hi Liliana & Gareth,

Finally i got the required query,

Yes Gareth, you were right, i had the problem of duplicate values,

But i used distict for that and solved it.

SELECT  distinct   ItemName...

Hi Gareth, thanks for replying.

The values of ItemID will be different because i've set a different range for them in both the tables.

STANDARD - 1000 to 3000.

CUSTOM - 5000 to...