Repeat records based on field value ----------------------------------- Key: CORE-4248 URL: http://tracker.firebirdsql.org/browse/CORE-4248 Project: Firebird Core Issue Type: New Feature Reporter: william Priority: Minor
I have a table like this Name Qty ----- ----- BD 2 SD 1 XE 3 It will be useful if I can repeat records based on the value in the Qty field for example first row would be repeated twice with all same values. What I suggest to add new keyword (ex Repeat) to select statement to return the repeated rows like this Select * from mytable Repeat On Qty Where.... -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira ------------------------------------------------------------------------------ October Webinars: Code for Performance Free Intel webinars can help you accelerate application performance. Explore tips for MPI, OpenMP, advanced profiling, and more. Get the most from the latest Intel processors and coprocessors. See abstracts and register > http://pubads.g.doubleclick.net/gampad/clk?id=60135031&iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel