Jul 23, 2001 #1 ADW Programmer Jun 21, 2001 50 GB I'm struggling assigning the results of a query to a variable. Here is an example; declare @val as int set @val = (select total = count(all transaction_type)
I'm struggling assigning the results of a query to a variable. Here is an example; declare @val as int set @val = (select total = count(all transaction_type)
Jul 23, 2001 #2 rajeevnandanmishra Programmer Jun 1, 2001 379 IN Hi ADW, Try using this, declare @val as int select @val = count(all transaction_type) from myTable Upvote 0 Downvote