Aravindan GP
asked on
Query formaton
Hi,
Please find the attached sql query , which is calling a function.
can I combine the functionaliteis of the function within the query,if so please help me to frame that query.
Regards,
query1.sql
Funct1.sql
Please find the attached sql query , which is calling a function.
can I combine the functionaliteis of the function within the query,if so please help me to frame that query.
Regards,
query1.sql
Funct1.sql
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
It may be possible to write a "max" subquery that returns just one row instead of a cursor loop, and put that inside of a "case" statement to evaluate what it returns, then put this into your query, but this is certainly not a task for a novice SQL coder! I'm not suggesting that you are a SQL novice, but this would be a challenge for many advanced SQL developers. Also, maintenance and/or changes of something this complex could be a problem in the future.