User defined Sql vs stored procedures

[vsudaya]

Hi,

Anybody can tell me which one will give best performance(User defined sql or stored procedures) when yu are using report studio?

thanks regards
vsudaya

[BIsrik]

Ofcourse SP is more efficient in performance than the user defined Sql. But SP had to be executed atleast once before testing the performance with the user defined Sql.

But the report design flexibility is more with the user defined sql than the SP.

Srik