Getting Result of query inside another query

[meendar]

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 re**********@sql1.registerno' and
su***********@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.

[Dan Guzman]

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,

Why not use a single query? For example:

CREATE PROCEDURE dbo.marks1
AS

SELECT *
FROM dbo.marksetting
JOIN dbo.mark ON
mark.registerno = marksetting.registerno AND
mark.subjectcode = marksetting.subjectcode;
GO
To answer your question, if the first query returns no more than a single
row, you could assign the result values to variables for use in the second
query:

CREATE PROCEDURE dbo.marks1
AS

DECLARE
@registerno int,
@subjectcode int

SELECT
@registerno = registerno,
@subjectcode = subjectcode
FROM dbp.mark;

SELECT *
FROM dbo.marksetting
WHERE
registerno = @registerno AND
subjectcode = @subjectcode;
GO
If the first query might return more than one row, you could store the
result in a temp table or variable for use in the second query:

CREATE PROCEDURE dbo.marks1
AS

DECLARE @results TABLE
(
registerno int,
subjectcode int
);

INSERT INTO @results
SELECT
registerno,
subjectcode
FROM dbo.mark;

SELECT *
FROM dbo.marksetting
JOIN @results AS r ON
marksetting.registerno = r.registerno AND
marksetting.subjectcode = r,subjectcode;
GO

--
Hope this helps.

Dan Guzman
SQL Server MVP

"meendar" <as****************@gmail.comwrote in message
news:11**********************@b40g2000prd.googlegr oups.com...

>
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 re**********@sql1.registerno' and
su***********@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.

[meendar]

On May 22, 3:33 pm, "Dan Guzman" <guzma...@nospam-
online.sbcglobal.netwrote:

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,

Why not use a single query? For example:

CREATE PROCEDURE dbo.marks1
AS

SELECT *
FROM dbo.marksetting
JOIN dbo.mark ON
mark.registerno = marksetting.registerno AND
mark.subjectcode = marksetting.subjectcode;
GO

To answer your question, if the first query returns no more than a single
row, you could assign the result values to variables for use in the second
query:

CREATE PROCEDURE dbo.marks1
AS

DECLARE
@registerno int,
@subjectcode int

SELECT
@registerno = registerno,
@subjectcode = subjectcode
FROM dbp.mark;

SELECT *
FROM dbo.marksetting
WHERE
registerno = @registerno AND
subjectcode = @subjectcode;
GO

If the first query might return more than one row, you could store the
result in a temp table or variable for use in the second query:

CREATE PROCEDURE dbo.marks1
AS

DECLARE @results TABLE
(
registerno int,
subjectcode int
);

INSERT INTO @results
SELECT
registerno,
subjectcode
FROM dbo.mark;

SELECT *
FROM dbo.marksetting
JOIN @results AS r ON
marksetting.registerno = r.registerno AND
marksetting.subjectcode = r,subjectcode;
GO

--
Hope this helps.

Dan Guzman
SQL Server MVP

"meendar" <[e-mail] in message

news:11**********************@b40g2000prd.googlegr oups.com...

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 [e-mail]' and
[e-mail]';

end

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

Thanks in Advance.- Hide quoted text -

- Show quoted text -

Thanks Dan!

Indeed it was very helpful to me.

[meendar]

On May 22, 3:33 pm, "Dan Guzman" <guzma...@nospam-
online.sbcglobal.netwrote:

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,

Why not use a single query? For example:

CREATE PROCEDURE dbo.marks1
AS

SELECT *
FROM dbo.marksetting
JOIN dbo.mark ON
mark.registerno = marksetting.registerno AND
mark.subjectcode = marksetting.subjectcode;
GO

To answer your question, if the first query returns no more than a single
row, you could assign the result values to variables for use in the second
query:

CREATE PROCEDURE dbo.marks1
AS

DECLARE
@registerno int,
@subjectcode int

SELECT
@registerno = registerno,
@subjectcode = subjectcode
FROM dbp.mark;

SELECT *
FROM dbo.marksetting
WHERE
registerno = @registerno AND
subjectcode = @subjectcode;
GO

If the first query might return more than one row, you could store the
result in a temp table or variable for use in the second query:

CREATE PROCEDURE dbo.marks1
AS

DECLARE @results TABLE
(
registerno int,
subjectcode int
);

INSERT INTO @results
SELECT
registerno,
subjectcode
FROM dbo.mark;

SELECT *
FROM dbo.marksetting
JOIN @results AS r ON
marksetting.registerno = r.registerno AND
marksetting.subjectcode = r,subjectcode;
GO

--
Hope this helps.

Dan Guzman
SQL Server MVP

"meendar" <[e-mail] in message

news:11**********************@b40g2000prd.googlegr oups.com...

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 [e-mail]' and
[e-mail]';

end

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

Thanks in Advance.- Hide quoted text -

- Show quoted text -

Thanks Dan!

Indeed it was very helpful to me.

[Dan Guzman]

I'm glad I was able to help.

--
Dan Guzman
SQL Server MVP

"meendar" <as****************@gmail.comwrote in message
news:11**********************@b40g2000prd.googlegr oups.com...

On May 22, 3:33 pm, "Dan Guzman" <guzma...@nospam-
online.sbcglobal.netwrote:

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,

Why not use a single query? For example:

CREATE PROCEDURE dbo.marks1
AS

SELECT *
FROM dbo.marksetting
JOIN dbo.mark ON
mark.registerno = marksetting.registerno AND
mark.subjectcode = marksetting.subjectcode;
GO

To answer your question, if the first query returns no more than a single
row, you could assign the result values to variables for use in the
second
query:

CREATE PROCEDURE dbo.marks1
AS

DECLARE
@registerno int,
@subjectcode int

SELECT
@registerno = registerno,
@subjectcode = subjectcode
FROM dbp.mark;

SELECT *
FROM dbo.marksetting
WHERE
registerno = @registerno AND
subjectcode = @subjectcode;
GO

If the first query might return more than one row, you could store the
result in a temp table or variable for use in the second query:

CREATE PROCEDURE dbo.marks1
AS

DECLARE @results TABLE
(
registerno int,
subjectcode int
);

INSERT INTO @results
SELECT
registerno,
subjectcode
FROM dbo.mark;

SELECT *
FROM dbo.marksetting
JOIN @results AS r ON
marksetting.registerno = r.registerno AND
marksetting.subjectcode = r,subjectcode;
GO

--
Hope this helps.

Dan Guzman
SQL Server MVP

"meendar" <[e-mail] in message

news:11**********************@b40g2000prd.googleg roups.com...

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 [e-mail]' and
[e-mail]';

end

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

Thanks in Advance.- Hide quoted text -

- Show quoted text -

Thanks Dan!

Indeed it was very helpful to me.