Status: Solved
Priority: Medium
Security: Public
Views: 251
Last Modified: 2012-12-27

output variable value?

nothing outputs:

SELECT @Abbr = RTRIM(Merchant.Abbr)
FROM Asset
INNER JOIN Pool ON Asset.PoolID = Pool.PoolID AND Asset.PoolSID = Pool.PoolSID
INNER JOIN Merchant on Pool.MerchantID = Merchant.MerchantID AND Pool.MerchantSID = Merchant.MerchantSID
WHERE Asset.AssetID = @AssetID AND Asset.AssetSID = @AssetSID

how do I see what is in @Abbr?

Tom Knowlton

Asked: 2012-12-27

Advertise Here

Microsoft SQL Server 2008

1 Solution

LVL 66

Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented: 2012-12-27

That's because when you SET @variable = something, it makes the assignment but does not SELECT the value such that it is returned.

SELECT @Abbr = RTRIM(Merchant.Abbr)
FROM Asset
INNER JOIN Pool ON Asset.PoolID = Pool.PoolID AND Asset.PoolSID = Pool.PoolSID
INNER JOIN Merchant on Pool.MerchantID = Merchant.MerchantID AND Pool.MerchantSID = Merchant.MerchantSID
WHERE Asset.AssetID = @AssetID AND Asset.AssetSID = @AssetSID

-- Show the value
SELECT @Abbr

LVL 66

Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented: 2012-12-27

... or, not even have the @Abbr variable, and just return the value, like ...

SELECT RTRIM(Merchant.Abbr)
FROM Asset
INNER JOIN Pool ON Asset.PoolID = Pool.PoolID AND Asset.PoolSID = Pool.PoolSID
INNER JOIN Merchant on Pool.MerchantID = Merchant.MerchantID AND Pool.MerchantSID = Merchant.MerchantSID
WHERE Asset.AssetID = @AssetID AND Asset.AssetSID = @AssetSID

LVL 5

Tom KnowltonWeb developerAuthor Commented: 2012-12-27

thx

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

output variable value?

Join & Write a Comment Already a member? Login.

Featured Post