#DateForumTypeThreadPost
807 Sep 2016 @ 11:16 PDTDatabaseTopicvolatile tables inside the stored procedure Hello,    I have the following two questions please:   1) While creating a volatile talbe inside a stored procedure : it needs to be created first outside the SP a...
706 Sep 2016 @ 01:36 PDTDatabaseTopicSyntax I am getting the following error : SPL1027:E(L7), Missing/Invalid SQL statement'E(3706):Syntax error: expected something between the word 'StartDate' and the 'DATE' keyword.&...
602 Sep 2016 @ 07:04 PDTDatabaseReplyreplacing existing column Thanks Sachin. I will go with the second option as then I can do it all in one query.
501 Sep 2016 @ 12:59 PDTDatabaseTopicreplacing existing column Hello,   In the below query, i get the error    CREATE TABLE Failed. 3515:  Duplication of column PRCD_AMT in a table, derived table, view, macro or trig...
431 Aug 2016 @ 10:36 PDTDatabaseTopicSingle vs double quotesHello, in the following code , if i replace the single quotes arounf 'credit card' with double quotes, it looks for a column with name 'credit card' . can some one throw some light ...
331 Aug 2016 @ 06:14 PDTDatabaseReplySet multiple variable in one case statement Could you elaborate on how a SP could do the above?
230 Aug 2016 @ 11:40 PDTDatabaseTopicSet multiple variable in one case statement Hello,    I am converting some SAS code to TD : In SAS you can set multiple variables within a single case statement. Can we do the same in TD? Thanks in advance if RFRL_SRC_CD = &#...
130 Aug 2016 @ 10:33 PDTDatabaseTopicReplacing tableHello,   In SAS if a new table A is created using the table A itself, the new table will overwrite the old. Can you pl let me know if same is the case in TD. -   create volatile ...