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.
| Author |
Topic |
|
skillile
Posting Yak Master
208 Posts |
 Posted - 2001-11-08 : 14:37:15
|
| here's my dilemma.create table #temp (num int)insert #temp values (1110)insert #temp values (1130)insert #temp values (1122)insert #temp values (1148)insert #temp values (1133)insert #temp values (1121)declare @filter intset @filter = 1122select * from #tempwhere num >= @filter or num <= @filterdrop table #temp--i want to be able to filter all--my records and have the filtered--record show up first in the list--followed by the rest of the numbers--in sequence--should look like112211301133114811101121--any suggestionsslow down to move faster... |
|
|
|
|
|
filter and order by filter