Recent content by rivi007

k yah that solved it ... select top 50 percent .... then you can use not in to unselect the one row that overlaps

i just found select top 50 percent ... in another forum ill try that and see what happens

basically my question is how do I select the top half of a table.

yah that doesnt really matter though for my situation as I just need the second query to return only half the rows in the table .... if your curious though I use a DTS package to run the query and populate the data in SQL server. can I select the top half of the table in one query or something??

Can I just create a variable that will hold that value or something??

please help hey guys i have a similar issue ... i need to select half the count of a table and then insert this number into another query. A query I am trying to run times when transporting data to SQL so i need to split it in half and run it in chunks. Joining won't work I dont think because I...