Hi,
Can any one tell me how can we combine Stored Procedure and SQL statement together in Cognos Report Studio 10.2.
Currently I have SQL script in report ,which is taken direct from SQL server database source and it is working fine.
Now need to add one update Stored Procedure to this SQL, before SQL script run data it has to update this procedure and run.
Any help urgent is much Appreciated here.
Thanks
Gopi