I was trying to use LVS_CONT_RECENT_DT in an output set based on something in the updated cookbook for v.11, and come to find out that is not one of our three views. I am in dev, so I've never set up a view, but I guess that's what this does (which follows after the output set bits I'm familiar with)?
800x600
Normal 0 false false false EN-US X-NONE X-NONE MicrosoftInternetExplorer4
USE [impresario]
GO
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
ALTER VIEW [dbo].[LVS_CONT_RECENT_DT]
AS
SELECT a.customer_no, MAX(a.ref_no) AS ref_no
FROM dbo.VS_CONTRIBUTION AS a
JOIN VS_FUND b on a.fund_no = b.fund_no
WHERE (a.recd_amt > 0) AND (b.desig_code IN (##,##))-- ## your desig_codes
GROUP BY a.customer_no
GRANT REFERENCES, SELECT on [LVS_CONT_RECENT_DT] to impusers
Hi John,
That's correct. You'll need your DBA to create the database view before you can reference it in your output set elements.
In general I think the naming convention is that any time you have a table or a view starting with "L" it refers to something Local, i.e. a customization rather than one of the out-of-the-box Tessitura tables, views, etc. Something prefixed with LT_ is a local table, LV_ is a local view, LVS_ is a local secure view, and so on.