Thank you, Phil. This workaround works for me.
Thank you so much.
1. Executed the query instead of Stored Procedure and dumped data into a temp table.

Yes Phil,
I get the below error.  
Error is: - 

November 3, 2017 at 7:34 am

#1966556

Sue,
Data types for the data columns are just varchar, int and date.
My actual requirement is to compare column by column the outputs of below queries
exec StoredProcedure1 '2017-11-02' 

You need to change the custom properties setting in SCD.

Click on SCD

1. Open show advance editor

2. Common Properties -> custom properties -> CurrentRowWhere

3. Use this condition [StartDate]...

Who else DBA 😀