-
Notifications
You must be signed in to change notification settings - Fork 14
/
1-create-view-with-no-params.sql
57 lines (40 loc) · 1.24 KB
/
1-create-view-with-no-params.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
-- ==============================================================
-- Description:
-- 1. This query shows you how to make a view
-- 2. The fiew is called "TestHoldings" and will appear under "Test/Example"
-- 3. Luminesce views are effectively custom providers
-- 4. You can think of them as being somewhat like stored procs
-- ==============================================================
-- First delete the view if it already exists
@delete_model_portfolios_view =
use Sys.Admin.SetupView
--provider=Test.Example.TestHoldings
--deleteProvider
----
select 1 as deleting
enduse;
-- Wait 5 seconds after delete before attempting to re-create
-- This give the view time to reset on the Luminesce grid
@delete_model_portfolios_view_response =
select *
from @delete_model_portfolios_view wait 5;
-- The Sys.Admin.SetupView provider
@model_portfolios_view = use Sys.Admin.SetupView
--provider=Test.Example.TestHoldings
----
@model_portfolios = use Drive.csv
--file=/luminesce-examples/model_portfolios.csv
enduse;
select
#distinct
#select_agg
{
{ModelPortfolioName^ : model_port_name},
{Sector: sect},
{Region: loc},
{Weighting: weighting}
}
from @model_portfolios
where #restrict_agg
enduse;
select * from @model_portfolios_view;