Posted by meendar on 05/22/07 09:53

Hi to all,

I just need to get two fields from a table and manipulate the results
in next query of a procedure.I planned to code like what you see
below,

create procedure marks1
as
@ sql1 as varchar(50)

@ sql1=select registerno ,subjectcode from mark;

begin

select * from marksetting where registerno='@sql1.registerno' and
subjectcode='@sql1.subjectcode';

end


can it be possible to get the results as shown in the code? else
propose an alternative for this scenario.

Thanks in Advance.

• Next in forum: Re: Getting Result of query inside another query
• Prev in forum: Return data from multiple tables
• Thread view: Getting Result of query inside another query

[Reply to this message]