I am trying to merge based on a value found in the registry. I am using sql server 7. I am able to get my desired results through query analyzer with a statement like this
declare @build varchar(3)
exec
master..xp_regread 'HKEY_CURRENT_USER',
'SOFTWARE\VB AND VBA PROGRAM SETTINGS\SYSTEM\COMMUNICATIONS',
'BUILD',@build output
select * from customer where rep_id = @build
But when using the merge wizard it only allows you to enter the where part for the selection. Any ideas on how I can set the where up to compare to the registry?
Thanks,
Ctau
declare @build varchar(3)
exec
master..xp_regread 'HKEY_CURRENT_USER',
'SOFTWARE\VB AND VBA PROGRAM SETTINGS\SYSTEM\COMMUNICATIONS',
'BUILD',@build output
select * from customer where rep_id = @build
But when using the merge wizard it only allows you to enter the where part for the selection. Any ideas on how I can set the where up to compare to the registry?
Thanks,
Ctau