#DateForumTypeThreadPost
428 Mar 2013 @ 03:28 PDTDatabaseReplyTruncation of Data while Bteq ExportCan you please try the below   .EXPORT RESET
323 May 2011 @ 06:33 PDTDatabaseReplyTotal Sum of all columnsyou can use a union stmt using sum stmt. But this will take two passes
223 May 2011 @ 06:19 PDTToolsReplyPerformance TuningVery Simple. If you want to start with Perfromance Tuning on SQL you need to check the below 1. Statistics are used 2. Partitions are used You can find these two by Use this sql in ...
123 May 2011 @ 06:15 PDTAnalyticsReplyhow to compute the kpi using sqlLets say you are doing this for a current_date. So first get the set of customers who are not there in last 3 months for a specific service. Then you can apply filter between last 1 year and curren...