#DateForumTypeThreadPost
729 May 2016 @ 04:57 PDTDatabaseReplyMacro vs Procedure - SQL SECURITYI finally understood what Tom was trying to explain me. I have broken it down for newbies like.   Basically using CREATE MACRO I can execute any query for which the database (in which the ma...
629 May 2016 @ 04:50 PDTDatabaseReplycumulative count by dateIs there an implicit conversion from datetime to character in using TRIM(cast(my_timestamp_field as format 'yyyymm')) ?
527 May 2016 @ 12:11 PDTDatabaseReplycumulative count by dateI don't have a complete solution, but I am sure cast(my_timestamp_field as date format 'yyyymm') as rule_month needs to be changed to cast(cast(my_timestamp_field as date format 'yyyymm')...
421 May 2016 @ 08:08 PDTDatabaseReplyMacro vs Procedure - SQL SECURITYThank you Dieter and Tom. I am a bit confused though. As per the DDL document as quoted above : The user creating a macro must have the privileges for all statements it performs. And as the ...
319 May 2016 @ 10:41 PDTDatabaseTopicMacro vs Procedure - SQL SECURITYDoes CREATE MACRO have an equivalent of CREATE PROCEDURE's SQL SECURITY clause? Or should the database of the user executing the macro always always have SELECT/UPDATE access, as needed, to the tab...
205 May 2016 @ 07:45 PDTAnalyticsReplySplitting of one to may rows using date range with the help other table's date range columns.I have two questions: 1. which are the two variables to join the two variables? 2. what do you mean by splitting the rows?
104 May 2016 @ 07:30 PDTAnalyticsReplyTeradata - calculate KPI every month for last 24 monthsMy suggestion is to put all the queries in a single macro that will take as input a DATE variable. Let us call this variable as first_day, when you run for April 2016 this variable should have val...