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 2000 Forums  Transact-SQL (2000)  Results from a select into a variable

Author  Topic  shark Starting Member 1 Post Posted - 2001-08-17 : 18:55:19 Hi, I really can't find any information on this. I now have this query: select @qid = (select qid from uniques where ip = '127.0.0.1') select @counts = (select counts from uniques where ip = '127.0.0.1') How can i combine them into something like: select @qid, @counts = (select qid, counts from .... That would seem so logical, but can't be done!! Help very much appreciated joe