I have 2 SQL Server instances that I need to query from. I have figured out how link the 2 servers, I just don't know how to get the value from the other instance/table and put it in the case statement.
Here are the tables:
Instance: Default Database:GAD
Instance: MSSQL Database:SCA
Here is the Select Statement with the when clause in it.
Select top (1)V301054A as MW, Availability = case when V301054A <= '.1' then 'Deployed' else '0' end FROM [Default].[SCA].[dbo].[SAMPLES1] AS SAMP1
Group by V301054A
order by MW desc
What I need to do is get the value from this Select Statement and put it where the 'Deployed' is in the above When Clause.
View Complete Post