@select value from sp - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

@select value from sp

Author

Topic

desikankannan
Posting Yak Master

152 Posts

Posted - 2010-12-03 : 04:14:48

Hi,
i try to get value from a table below i have store procedure
i want descvalue should be fetched in @freq
i don't no how to frame below query exactly i needed
set @freq = select descvalue from mst_desc where desckey =(select frequencycode from Mst_stdgauagemaster where fldguagekey = @fldguagekey)

create procedure spstdguagecalibdatetail
(
@fldguagekey int
)
as
set nocount on
declare
@freq int

begin try
set @freq = select descvalue from mst_desc where desckey =(select frequencycode from Mst_stdgauagemaster where fldguagekey = @fldguagekey)
END TRY
BEGIN CATCH
IF @@TRANCOUNT > 0
ROLLBACK

-- Raise an error with the details of the exception
DECLARE @ErrMsg nvarchar(4000), @ErrSeverity int
SELECT @ErrMsg ='workbring',
@ErrSeverity = ERROR_SEVERITY()

RAISERROR(@ErrMsg, @ErrSeverity, 1)

END CATCH

Desikankannan

nigelrivett
Master Smack Fu Yak Hacker

3385 Posts

Posted - 2010-12-03 : 04:20:12

select @freq = descvalue from mst_desc where desckey =(select frequencycode from Mst_stdgauagemaster where fldguagekey = @fldguagekey

or
select @freq = md.descvalue
from mst_desc md
join Mst_stdgauagemaster ms
on md.desckey = ms.frequencycode
where ms.fldguagekey = @fldguagekey

Assuming that fldguagekey is an int

==========================================
Cursors are useful if you don't know sql.
SSIS can be used in a similar way.
Beer is not cold and it isn't fizzy.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources