Hi Imran,
Thanks for the reply. Your answer gave me a hint how I can do it.
Below is how I retrieve the Organization name dynamically without hard coding the Friendly name, In case some one need it.
DECLARE @CRMUrl nvarchar(255)
DECLARE @FrienlyOrgName nvarchar(100)
DECLARE @OrgName nvarchar(100)
--Retrieve Server Name
SELECT @CRMUrl = 'http://' + Name + '/'
FROM [MSCRM_CONFIG].[dbo].[Server]
WHERE Name NOT IN
(SELECT [name]
FROM [MSCRM_CONFIG].[sys].[servers])
Select @FrienlyOrgName = name from dbo.FilteredOrganization
--RetrieveOrganization Name
SELECT
@OrgName = UniqueName
FROM [MSCRM_CONFIG].[dbo].[Organization] where friendlyname = @FrienlyOrgName
select @CRMUrl + @OrgName