#DateWhereItemComment
601 Dec 2014 @ 11:53 PSTGeorgeColeman's blogOrdered Analytical Functions: Translating SQL Functions to Set SQLYes, this does sound hard, but it sounds like something you can solve with some patience.  I would hope you could find a way to turn those scalar subqueries into selects that can be joined wit...
523 May 2012 @ 12:23 PDTGeorgeColeman's blogUsing Derived Tables as a Shortcut to Set SQLYes, there are things that seem just too difficult if not impossible to do in Set SQL. Usually these things have many, many lines of if-statements. It is possible to have so many IF's that the corr...
422 May 2012 @ 12:07 PDTGeorgeColeman's blogUsing Derived Tables as a Shortcut to Set SQLThank you, Pranu, This is a good example of a cursor loop that does not need to be eliminated for two reasons: first, the cursor is looking for certain list of table names in the data dictionary. ...
325 Nov 2011 @ 05:58 PSTGeorgeColeman's blogLoops to Sets: A Brief History of Database Programming LogicI find that it helps a lot to read good SQL examples from other people. Two good resources for that are the Teradata SQL DML manual and the SQL Functions manual. (www.info.teradata.com.). These man...
218 Sep 2011 @ 08:45 PDTGeorgeColeman's blogConverting Complex Procedure Logic to Set SQL Using Derived TablesNo, that's right - it was a scrap left over from the original code on which this example is based. I've corrected it, and I hope no one was confused by that. Thank you for catching it, and than...
112 May 2011 @ 03:36 PDTGeorgeColeman's blogFrom Flat Logic to Set Logic - a basic approachYes, this code worked pretty much as shown here a couple of years ago. (There could be some typos in this text.) Of course, you would have to create tables that have the names and columns used he...