Re: Interpolating subroutine call in SQL INSERT INTO SELECT statement

You might be able to do simple interpolation using nothing but SQL inline with a few subqueries and some trivial math.

If you truley need a perl function to do the job, you'll have to do a select in one call. And then prep an insert data set for a second call.

--
“For the Present is the point at which time touches eternity.” - CS Lewis

Comment on Re: Interpolating subroutine call in SQL INSERT INTO SELECT statement

Replies are listed 'Best First'.
Re^2: Interpolating subroutine call in SQL INSERT INTO SELECT statement by shadowsong (Pilgrim) on Aug 26, 2015 at 12:56 UTC
If you truley need a perl function to do the job, you'll have to do a select in one call. And then prep an insert data set for a second call. That is what I suspected, but I'm very new to Perl and still far from sure of what is and isn't possible. Thanks again for the advice. I appreciate it.	[reply]