Create Procedure [DataSprings_RetrieveDynamicView]
@PortalID integer,
@intTableorQuery integer,
@strTableOrQuery nvarchar(MAX),
@LimitResults nvarchar(4000),
@strUserFilter nvarchar(4000),
@intUserID integer, 
@strDetailView nvarchar(2000)

AS

Declare @MySQL nvarchar(MAX)
Declare @SQLToExecute nvarchar(MAX)

if @intTableOrQuery = 0 
BEGIN
Set @MySQL = 'Select * from ' + @strTableOrQuery
END
ELSE IF @intTableOrQuery = 1
BEGIN

--WE Have Removed this because its likely that this is for an external connection and doesn't use Dynamic Forms
--exec [DataSprings_DynamicViews_GetDynamicFormsResults] @strTableOrQuery, @intUserID, @MySQL OUTPUT
--Select @MySQL
END
ELSE
BEGIN
Set @MySQL = @strTableOrQuery
END

Set @SQLToExecute = cast('Select ' as nvarchar(max)) + @LimitResults + cast(' * from
(' as nvarchar(max)) + @MySQL + cast(') AS Main ' as nvarchar(max)) + @strUserFilter + @strDetailView

--Select @SQLToExecute
exec sp_executesql @SQLToExecute
GO