MAPPING, ApplyMap: ejemplo Continuar leyendo «QlikView/QlikSense Script: Mapping & ApplyMap»
QlikView Course Content – Level 2: Developer (16 h)
QlikView Course Content – Level 1: Designer (16h)
T-SQL 2016 NEW FEATURES
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
AT TIME ZONE
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 AT TIME ZONE clause converts it into the target time zone using time zone conversion rules.
Example Continuar leyendo «AT TIME ZONE»