Michael Hodgdon wrote: > > Before I begin, I know this is simple and remedial in CF, but I specifically > want a SQL solution (if necessary, it can be a Transact SQL solution) > > Basically, I want to loop over a query using SQL syntax just like you would > loop over a query using <CFQUERY> or <CFLOOP QUERY> tags. That is it. > Looking for the same functionality using SQL instead of CF. > > I want to embed this functionality in a SQL script, but all the solutions I > have tried report that the request has returned more than one possible match > and errors out. Basically, SQL is treating the select as a whole object > verses looking at each row one at a time.
You can't do it in SQL. Jochem ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm