Constituency end date and name

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

Parents Reply Children
No Data