Tags for views
SchemaLoader results? Views via EF to EDMX?
Is there a way to get the SchemaLoader results? The cmd prompt it opens closes immediately and I cant seem to pause it to read what it output.  I cant tell what went wrong or what went right.     Also if there is an alternative way to get the views into the EDMX please let me know.
schemaloader EF views
Performance and view-on-view approach
Hi Guys, thanks for reading the post. I did do a search for "view on view" and there was no result.
sql views view performance
How to Design Complex Views
This presentation teaches you how to design effective semantic view layers on Teradata. After briefly explaining the mechanics of how the Teradata Parser processes views, it dissects a number of semantic view examples that have been successfully implemented in production environments to help you understand what works and what constructs are problematic. The emphasis is upon practical issues from understanding how to design a single view to design patterns appropriate for virtual star schemas.
views semantic view parser design patterns star schemas
Volatile table vs views.
Hi, Can some one please tell me, between Volatile table and view, which is better in terms of efficiency, accessbility and use? What is the difference between them?? Also, can I create a volatile table with same name but using different user ID?
effective #Volatile tables volatile table views
MS Visio 2010 - Reverse Engineering Views?
Has anyone successfully Reverse Engineered Teradata Views using MS Visio 2010? When I try "Reverse Engineering" the Views check box is grayed out and not selectable. Is there a dbc table or view I need additional rights to?  
visio views
Temporal Macro / Dynamic SQL in a View
Hi, I have the following tables EMPLOYEE& DEPT. I am writing the following query :   validtime as of date '2001-01-01' select * from SANDBOX.TEMPORAL_EMPLOYEE AS EMP join SANDBOX.TEMPORAL_DEPT as dept on emp.dept_id=dept.dept_id;    
temporal sql views joins macro
Create a View From A Select Statement Generated in A Cursor--Stored Proc
Hi.   I have a problem. I have a cursor with a select statement. The select statement returns 5 rows. Row 1-- Select col 1 Row 2 --,col2 Row3---,col3 Row4---,col4 Row5--- From table A;  
stored procedure dynamic sql views cursor
Common Table Expression Within View
Is it possible to put a common table expression within a view? The following SQL works fine WITH myCTE (account_number) AS ( SELECT account_number FROM dbname.tablename WHERE columnname = 'somevalue' ) SELECT account_number FROM myCTE; However when I try to put this into a view . . . CREATE VIEW myCTE_VIEW AS ( WITH myCTE (account_number) AS ( SELECT account_number FROM dbname.tablename WHERE columnname = 'somevalue' ) SELECT account_number FROM myCTE )
views common table expressions cte with
Creating a view that uses "WITH RECURSIVE" getting error 6926
I have a recursive query that begins with the text "WITH RECURSIVE". The query works fine. When I try to use the exact query within a view, while creating the view I receive an error that says "REPLACE VIEW Failed 6926: definitions, views, triggers or stored procedures". I simply prefix the query with this text: REPLACE VIEW DB.VIEW_NAME AS LOCKING ROW FOR ACCESS and I get the error. I can successfullly get the recursive view created if I use this text instead: REPLACE RECURSIVE VIEW DB.VIEW_NAME, and if I also remove the syntax "WITH RECURSIVE".
views 6926 with recursive recursive view
Global and session level parameters in SQL
The commonly known technique to pass parameters to SQL statements at the system or session level utilizes tables (permanent or global temporary tables). In this blog post, I'll show better performing techniques for system and user level variables using views and QueryBanding. These solutions are based on TD13, but can also be used pre-TD13, although performance might be worse.
views scalar subqueries parameters variables querybanding