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)
 GRID RESULTS

Author  Topic 

PATPC999
Starting Member

8 Posts

Posted - 2013-04-05 : 11:13:33
I am run a query multiple times using
WHILE @YEAR < @STOPYEAR
BEGIN

THE QUERY

SET @YEAR = @YEAR + 1
IF @YEAR = @STOPYEAR
BREAK
ELSE
CONTINUE
END

Of course the results show up in multiple grids and I was wonder if I can get the results
In just one grid.

chadmat
The Chadinator

1974 Posts

Posted - 2013-04-05 : 11:29:39
Not the way you have it written. Maybe if you give us the query, it could be written to give you a single result set.

-Chad
Go to Top of Page
   

- Advertisement -