| | |
cross data please heslp
Please support our MS SQL advertiser: Intel Parallel Studio Home
![]() |
•
•
Join Date: May 2007
Posts: 4
Reputation:
Solved Threads: 1
i have table
(id1,id2)
1.row [1,2]
2.row [2,1]
3.row [3,4]
4.row [4,3]
5.row [5,6]
6.row [6,5]
i want to get result:
1.row [1,2]
3.row [3,4]
5.row [5,6]
or
2.row [2,1]
4.row [4,3]
6.row [6,5]
i try anithing, (but not temporarry table), to eliminate cross data, but ... , can you help please, how i get my result?
Rado, thanx very much.
(id1,id2)
1.row [1,2]
2.row [2,1]
3.row [3,4]
4.row [4,3]
5.row [5,6]
6.row [6,5]
i want to get result:
1.row [1,2]
3.row [3,4]
5.row [5,6]
or
2.row [2,1]
4.row [4,3]
6.row [6,5]
i try anithing, (but not temporarry table), to eliminate cross data, but ... , can you help please, how i get my result?
Rado, thanx very much.
![]() |
Similar Threads
- Data Recovery (Storage)
- How do you access Data in a QBasic 2.0 Data Table (Legacy and Other Languages)
- data file help (C)
Other Threads in the MS SQL Forum
- Previous Thread: Best book for SQL Server 2005
- Next Thread: Database Query Help
| Thread Tools | Search this Thread |
autogrowth connectingtodatabaseinuse count cursor data database datepart dbsize deadlock delete_trigger highperformancecomputing hpc hpcserver2008 ibm iis loop maximum microsoft ms mssql multiple multithreading news number permission query reporting result server services sets source sql sqlserver sqlserver2005 supercomputing tables uniqueid update view





