Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Problem Merging Based On Registry Element

Status
Not open for further replies.

ctau

IS-IT--Management
Feb 8, 2000
34
US
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top