I forgot to mention that this would be MS SQL 2000 On 1/27/2011 1:33 PM, Kelly Matthews wrote: > Ok so I haven't really written any code in tSQL yet that does major looping > like I'm doing in CF. Figured I'd post this here and see if anyone had some > input on how to convert this into tSQL so it could be run w/ in a DTS package. > > Basically we have products, top-level categories, sub-categories, > sub-sub-categories, etc. The purpose of this script is to find any sub, or > sub sub etc. categories that have no products, and mark that sub-category as > having no products. The script works great but I'd love to pull it out of CF. > Anyone care to take a stab or lead me in the right direction. IN the > meantime I shall google some SQL looping examples and see what I find. > >
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:341563 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
