×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
UDF (user defined function), not a stored procedure, as you have it in first
example should work fine.
Subselect wont work with VALUES clause.
Elvis
Celebrating 10-Years of SQL Performance Excellence
http://centerfieldtechnology.com/training.asp
-----Original Message-----
Subject: SQL INSERT help
Hello,
Is the following sql statement possible using only sql? I'd like to have
the 'get_prod_desc' execute an sql statement that returns the product
description.
insert into mylibrary/myfile (warehouse, product#, description)
values('WH', '123456789', get_prod_desc('123456789'))
Is there an easier method that doesn't involve a procedure? Maybe something
like the following:
insert into mylibrary/myfile (warehouse, product#, description)
values('WH','123456789', (select description from product_master
where prdno = '123456789'))
Thanks,
Frank
midrange.com
