I have a table with 990 rows, I want to be able to copy these rows and
attach them on the end of the last row, any ideas on how I can do this?
Would appreciate the help.
use syntax INSERT INTO....SELECT as i've shown you in the earlier post. since your destinationQuote:>> attach them on the end of the last row,<<
insert into <source_table> (col1,col2)
select col1,col2 from <source_Table>
Also remember that, table is an unordered set of rows. To assure the retrieval order of the
rows always make use of "order by" clause in the select statement, it does not matter in what
order rows are getting inserted.
I'm running Win2k Adv Srv's with SQL 2000 SP1. I was just wondering if
anyone knew of an SQL statement (or group of statements) to append what
would normally return in rows into a single column. This one has had me
stumped for a while.
SELECT Column1, Column2 FROM Table1
Would there be a way (of course using a different query) to have it return
Text1 Version1, Version2
With or without seperators?