SQL:Problem in dynamic sql query [modified]

[xodeblack]

static query executes fine but there is problem when I make it dynamic.please ignore logic of query,only consider syntax

	set @sSQL = 'select s.first\_name from sfm\_students s
               left outer join 
               (select seq\_id from sfm\_classes)c 
               on c.seq\_id = s.sfm\_classes\_seq\_id'
print @sSQL
    exec @sSQL

when executing above procedure For Example

exec GetInfo

following error produce

Msg 203, Level 16, State 2, Procedure GetInfo, Line 15
The name 'select s.first_name from sfm_students s
left outer join
(select seq_id from sfm_classes)c
on c.seq_id = s.sfm_classes_seq_id' is not a valid identifier.

modified on Friday, August 28, 2009 5:15 AM

[Mycroft Holmes]

try exec (getinfo)

Never underestimate the power of human stupidity RAH