MAPPING, ApplyMap: examplo // Nota: salto adrede algunos números MiMapa: Mapping LOAD * INLINE [ Code, Value 1, Mercury 2, Mars 3, Venus 7, Saturn 8, Jupiter ]; TablaSinMapping: LOAD * INLINE [ UnIndice 1 2 3 4 5 6 7 …
MAPPING, ApplyMap: ejemplo // Nota: salto adrede algunos números MiMapa: Mapping LOAD * INLINE [ Codigo, Valor 1, Mercurio 2, Marte 3, Venus 7, Saturno 8, Jupiter ]; TablaSinMapping: LOAD * INLINE [ UnIndice 1 2 3 4 5 6 7 …
1. Loading Files and Database Data What is a qvd file? Optimized load Using ODBC and OLEDB Script Checking and Debugging Script control flow (conditional, loops) 2. Associating Data from Several Tables Associations Loading and associating a second table Renaming fields Qualify / Unqualify Mappings Save table to file Resident data source 3. Concatenating Tables …
QlikView Course Content – Level 2: Developer (16 h) Read More »
1. Loading Files and Database Data What is a qvd file? Optimized load Using ODBC and OLEDB Script Checking and Debugging Script control flow (conditional, loops) 2. Associating Data from Several Tables Associations Loading and associating a second table Renaming fields Qualify / Unqualify Mappings Save table to file Resident data source 3. Concatenating Tables …
QlikView Course Content – Level 2: Developer (16 h) Read More »
1. Introduction What is QlikView? QlikView Basics Document 2. Query editor: simple data load from file 3. QV Objects 4. Making Queries in a QlikView Document Basic QlikView terminology / colors Associative selections Stepping back or forward in the list of selections Locking and unlocking selections Searching values Selection bookmarks 5. Script Editor Basics: Loading …
QlikView Course Content – Level 1: Designer (16h) Read More »
1. Introduction What is QlikView? QlikView Basics Document 2. Query editor: simple data load from file 3. QV Objects 4. Making Queries in a QlikView Document Basic QlikView terminology / colors Associative selections Stepping back or forward in the list of selections Locking and unlocking selections Searching values Selection bookmarks 5. Script Editor Basics: Loading …
QlikView Course Content – Level 1: Designer (16h) Read More »
Stolen Copied from Adam Machanic’s blog (http://sqlblog.com/blogs/adam_machanic/archive/2017/01/13/sql-server-2016-hidden-gems-resources.aspx) STRING_SPLIT https://msdn.microsoft.com/en-us/library/mt684588.aspx Aaron Bertrand’s performance tests: https://sqlperformance.com/2016/03/sql-server-2016/string-split Session Context https://msdn.microsoft.com/en-us/library/mt605113.aspx Time Zone Support sys.time_zone_info: https://msdn.microsoft.com/en-us/library/mt612790.aspx AT TIME ZONE: https://msdn.microsoft.com/en-us/library/mt612795.aspx HASHBYTES https://msdn.microsoft.com/en-us/library/ms174415.aspx Session Wait Stats https://msdn.microsoft.com/en-us/library/mt282433.aspx Live Query Statistics https://msdn.microsoft.com/en-us/library/dn831878.aspx Ability to attach to other sessions’ Live Queries! https://blogs.msdn.microsoft.com/sql_server_team/query-progress-anytime-anywhere/ Actual Query Plan Data Enhancements …
Stolen Copied from Adam Machanic’s blog (http://sqlblog.com/blogs/adam_machanic/archive/2017/01/13/sql-server-2016-hidden-gems-resources.aspx) STRING_SPLIT https://msdn.microsoft.com/en-us/library/mt684588.aspx Aaron Bertrand’s performance tests: https://sqlperformance.com/2016/03/sql-server-2016/string-split Session Context https://msdn.microsoft.com/en-us/library/mt605113.aspx Time Zone Support sys.time_zone_info: https://msdn.microsoft.com/en-us/library/mt612790.aspx AT TIME ZONE: https://msdn.microsoft.com/en-us/library/mt612795.aspx HASHBYTES https://msdn.microsoft.com/en-us/library/ms174415.aspx Session Wait Stats https://msdn.microsoft.com/en-us/library/mt282433.aspx Live Query Statistics https://msdn.microsoft.com/en-us/library/dn831878.aspx Ability to attach to other sessions’ Live Queries! https://blogs.msdn.microsoft.com/sql_server_team/query-progress-anytime-anywhere/ Actual Query Plan Data Enhancements …
New time functions in SQL 2016 Converts an inputdate to the corresponding datetimeoffset value in the target time zone. If inputdate is provided without offset information, the function applies the offset of the time zone assuming that inputdate value is provided in the target time zone. If inputdate is provided as a datetimeoffset value, than …
New time functions in SQL 2016 Converts an inputdate to the corresponding datetimeoffset value in the target time zone. If inputdate is provided without offset information, the function applies the offset of the time zone assuming that inputdate value is provided in the target time zone. If inputdate is provided as a datetimeoffset value, than …