sub selecting the result set

Question

Post reply

sub selecting the result set

surya-236315

SSC Eights!

Points: 850
More actions
June 10, 2005 at 11:43 am

#88657

Hi all!
How Can I just select Col1 from the resultset of the query below? I need to use that in another SP
select top 1 count(col1), col1
from tabl1
where (col2 = 666)
group by col1
thanks

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 1

What can be modified?

Can you show us how you're gonna use this?

surya-236315 SSC Eights! Points: 850 More actions · Answer 2

The query returns i value in the col2 (the count), 1 value in the col 1. I just have to select the col1 value and use it in a SP

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 3

Sounds like homework to me...

Declare @value as int

select top 1 @value = col1

from tabl1

where (col2 = 666)

group by col1

Set @value = --do what you got to do with it.

ramses2nd Hall of Fame Points: 3720 More actions · Answer 4

Here is a silly way to do it although I am not a big fan of temp tables:

select top 1 count(col1)as num, col1

INTO #temp1

from tabl1

where (col2 = 666)

group by col1

SELECT col1 from #temp1

DROP TABLE #temp1

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 5

I'd just copy the statement, or make it into a view and use it in both sps.... there's just no need for a temp table in this case, the statement is just too simple... and should run pretty fast too.