→ The Lansweeper Customer Excellence Awards 2024 - Submit Your Project Now! Learn More & Enter Here
‎06-08-2015 10:46 AM
Solved! Go to Solution.
‎06-08-2015 01:42 PM
Select Top 1000000 'Link 1 for ' + tblAssets.AssetName As hyperlink_name_Link1,
'http://www.example.com&Assetname=' + tblAssets.AssetName As hyperlink_Link1,
'Link 2 for ' + tblAssets.AssetName As hyperlink_name_Link2,
'http://www.secondexample.com&Assetname=' + tblAssets.AssetName As
hyperlink_Link2
From tblAssets
‎06-08-2015 03:45 PM
‎06-08-2015 01:42 PM
Select Top 1000000 'Link 1 for ' + tblAssets.AssetName As hyperlink_name_Link1,
'http://www.example.com&Assetname=' + tblAssets.AssetName As hyperlink_Link1,
'Link 2 for ' + tblAssets.AssetName As hyperlink_name_Link2,
'http://www.secondexample.com&Assetname=' + tblAssets.AssetName As
hyperlink_Link2
From tblAssets
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now