Dynamics GP - SSRS - Location Lookup View

CREATE VIEW [dbo].[BI_Location_Lookup]
AS
SELECT     TOP (100) PERCENT LOCNCODE, LOCNDSCR, RTRIM(LOCNCODE) + ' | ' + RTRIM(LOCNDSCR) AS LocLbl
FROM        dbo.IV40700
ORDER BY LOCNCODE

GO