Hi

I have a Stored Procedure that goes something like this:

SyntaxEditor Code Snippet

IF EXISTS (SELECT 1 
            FROM --Some query--) 
  BEGIN
    SELECT 'X' AS COVERED_BI_PD 
    SELECT '' AS NOTCOV_BI_PD 
  END
  ELSE
  BEGIN
    SELECT 'X' AS NOTCOV_BI_PD 
    SELECT '' AS COVERED_BI_PD 
  END

Basically I want the atribute to be X if the query is found and null if not. I have the correct output sturcture:

However when the procedure runs i get the following error:

Error in advanced query GetCoverages in GetPolicyCoverages in Forms in TSP_Policies (/* %LogicalDatabase% = GetLogicalDatabase({pv_header}) */  EXEC dbo.usp_PP_DEC_115_SECTION @id_pv): Could not assign '' to 'usp_PP_DEC_115_SECTION.COVERED_BI_PD'... Index was outside the bounds of the array.

I have tried running a SQL Advanced Query with just this piece of code:

SELECT 'X' AS COVERED_BI_PD 

SELECT '' AS NOTCOV_BI_PD

And I am getting the exact same error. Unfortunately I am unable to share the OML. Any sugestions? 

Thanks in advance,

  CLSJ