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 |
|
ngk
Starting Member
10 Posts |
 Posted - 2008-09-25 : 04:43:22
|
| Hi there, My app. does ETL update of data from other databases then uses a UI to display queried data. This "core" data will only be altered prior to ETL and the UI will only query not update the data - the data is shown in a "default" order & the UI will offer the facility to the UI of filtering the data by various set ways, what would be the best way of achieving this with what are, large amounts of data? The filters are known & unalterable within the UIWould just a set of Views be the way to go, based on the preset filter options available? |
|
|
LoztInSpace
Aged Yak Warrior
940 Posts |
Posted - 2008-09-28 : 11:51:14
|
| Views do not sort data. You will have to create a query or SP with a suitable ORDER BY for each case. Alternatively you can ORDER BY a CASE statement but there's not much in it really. |
 |
|
|
ngk
Starting Member
10 Posts |
Posted - 2008-10-06 : 06:38:04
|
OK thanks for reply LoztInSpace, as always our original problem has changed beyond this now anyway |
|
|
|
|
|
|
Economical Recordset filtering