what kind of problem with the right join? example pls?

what kind of problem? example pls?

This is working fine but i'm missing 2 attributes. how can i get a result to be like this:

<KPICounts>

<KPICount Name="ga:visitors" SiteID="2" TestGoupID="1" GroupName="Production" type="integer" value="100" />

<KPICount Name="ga:visitors2" SiteID="2" TestGoupID="1" GroupName="Production"...

This is what you want?

create table computerCA (computerCAID int primary key, computerCAName varchar(300), computerCAEmail varchar(500))

insert computerCA

select 1, 'Laura', 'mymail@hotmail.com' union all

select 2, 'Joe', 'herman@hotmail.com'

SELECT computerCAID , computerCAName, computerCAEmail FROM COMPUTERCA...

Why do you want to compare a table vs a view. They are different.

Thank you so much.

Did you resolve this issue? I'm curious.

no replication involved.

anybody was able to do this?

anyone resolved this? i neeed help

When I do it manually it still gets stuck. I'm guessing the server1 is being blocked. Not sure what is blocked though. Maybe the port? maybe the server1 IP?

No, phil.

It only does work if i run it locally.

u need a proxy.

Did you fix this?

No