#DateForumTypeThreadPost
328 Apr 2014 @ 03:14 PDTGeneralTopicRecursive Query - Cannot Have Aliases Whose Names Matches Recursive NameHello I'm trying to run this recursive query but it's giving me an error: WITH RECURSIVE TSD_Candidate_Treatment ( CandidateID , RuleSetSeqNum , RuleSetID , RuleSetResult...
221 Feb 2011 @ 02:26 PSTDatabaseTopicRetrieving metadata about most recent queryHello In my stored procedures, I'm looking to start recording an "audit log" after each step. So for example: /* * Step 1 in my Stored Proc */ DELETE FROM MyDatabase.MyTable_Step1 A...
101 Sep 2010 @ 06:02 PDTToolsReplyQuery performance in SQL and BTEQHi Sreehari SQL Assistant connects to the database via ODBC, so many of the performance observations may be due to limitations with ODBC itself. BTEQ doesn't connect via ODBC, instead it effe...