#DateForumTypeThreadPost
1009 Nov 2011 @ 04:35 PSTDatabaseReplyRows to column | SQL looping | reccursion Thanks Amir. This is working, but Fld_LEVEL is not available in the base table and cannot be created throught a derived table or sub query. Both of them are not supported by RECURSIVE q...
909 Nov 2011 @ 04:30 PSTDatabaseReplyWhat is the syntax for recursive views? How to aggregate the final output set of a recursive view? Have tried this but not able include GROUP BY and MAX() function     CREATE RECURSIVE VIEW JDAVENDNUM  (REAL_NM, SUB_NM,     CON_NM,   &...
809 Nov 2011 @ 04:23 PSTDatabaseTopicWhat is the syntax for recursive views? How to aggregate the final output set of a recursive view? I have a recursive select query as below. Which need to be converted into a recursive view. {Since normal view does not support a recursive query}. How to convert this select query to recur...
708 Nov 2011 @ 10:18 PSTToolsReplyBTEQ loop Yes recursion might be a good idea
608 Nov 2011 @ 09:51 PSTAnalyticsReplyTransposing Data Case statement please
508 Nov 2011 @ 09:19 PSTDatabaseTopicRows to column | SQL looping | reccursion Have to create a view from base table below. The record count of base table is not constant.   Base table:- ----------------------- Country | State ----------------...
408 Nov 2011 @ 08:22 PSTDatabaseTopicRows to column Input table should hown be converted into output as shown below. Country          State India        ...
308 Nov 2011 @ 02:19 PSTDatabaseReplyHow to format numbers as Comma separated Thanks Carlos.  But this is not working in sql assistant.
207 Nov 2011 @ 10:54 PSTDatabaseReplyHow to format numbers as Comma separated In short I need to add commas to numbers for readability
107 Nov 2011 @ 10:23 PSTDatabaseTopicHow to format numbers as Comma separated I have to format numbers in the column as comma separated. For example  1000 should be 1,000 1234567 should be 1,234,567