Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Help for Union/Intersect query
Try UNION ALL between select statements. I used this the other day in a view to accomplish something similar. It would look something like this: SELECT a,b,c FROM table UNION ALL SELECT a,b,c FROM table Remember: (1) The number and the order of the columns must be identical in all queries...- CatParks
- Post #2
- Forum: Microsoft SQL Server: Programming
-
SQL 2000 Table Variables
THIS IS THE MAIN PROC: CREATE PROCEDURE dbo.TestTableProc (@PropertyNumber int) AS BEGIN declare @Premium table( PropertyNumber int, UnitNumber int, Unit varchar(10), Price int null, Code varchar(20) null, Description varchar(40) null...- CatParks
- Post #3
- Forum: Microsoft SQL Server: Programming
-
SQL 2000 Table Variables
I am using a table variable (as opposed to a temporary table) in a stored procedure. I am calling a cursor from within the proc and it updates the table variable. My problem is that I am being prompted to declare the table variable within the cursor - but I don't want to because it has already...- CatParks
- Thread
- Replies: 3
- Forum: Microsoft SQL Server: Programming
