when do we say the sp is complex...i mean when we use dynamic sql or anything else.
Can any one can explain me what a complex stored proc with an example or any issues while writing a stored procs in real-time environment adn trouble shooting it.
Thanks in advance
Paddy..:-)