Hi there,
I am using the Output Set Builder Cookbook for V11 (July 2012) and trying to get the Constituency end date and name output set working.
When I try and run the view SQL (LVXS_CONST_CUST_EXPIRED), I get an error that the view doesn't currently exist. I modified the code from ALTER VIEW to CREATE VIEW and ran it successfully. Now, when I try and use execute the output set I get the following error:
Invalid column name 'start_dt'execute dbo.RP_RUN_QUERY;1 @query_no = 28, @list_no = 0
Any ideas why this isn't working?
Thanks,
David Geoffrey Hall
Did you grant permissions to ImpUsers for the new view you created? Not sure if that is what is causing the error, but it often trips me up when creating a new database object.
Beth