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
Actually, now that I look at the Cookbook more closely, it looks like there is a typo at the end of the SQL to create the view. On page 13 it says:
GRANT REFERENCES, SELECT on [LVS_CONT_RECENT_DT] to impusersGO
When it should actually say:
GRANT REFERENCES, SELECT on [LVXS_CONST_CUST_EXPIRED] to impusersGO
It's granting permissions to a different view - possible one you don't even have! Hopefully that can get changed in the documentation... :)
Beth
Hi Beth,
Good pick up! I've now granted the correct permissions for the view but am still getting the same error.
Very curious indeed. I'll keep digging.
dgh