DECLARE @var1 varchar(30)
SELECT @var1 = 'Generic Name'
SELECT @var1 = ((SELECT top 10 Client_account_number FROM #TempTable1))
SELECT @var1 AS 'account_number' ;
SELECT @var1 = 'Generic Name'
SELECT @var1 = ((SELECT top 10 Client_account_number FROM #TempTable1))
SELECT @var1 AS 'account_number' ;
No comments:
Post a Comment