CREATE PROCEDURE PDSCOMBOASSETCODE
AS

SELECT DISTINCT AssetCode, AssetCode + ' - ' + AssetName AS AssetName
FROM PMDAST0001