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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-02-04 : 11:17:50
|
Pablo writes "I am able to do the following in access:
SELECT IIf([T1SeriesA]=[Series],[T1CHA],IIf([T1SeriesB]=[Series],[T1CHB],IIf([T1SeriesC]=[Series],[T1CHC],IIf([T1SeriesD]=[Series],[T1CHD],IIf([T1SeriesE]=[Series],[T1CHE]))))) AS Expr1, dbo_Main.*
FROM dbo_Main
WHERE (((dbo_Main.CircuitType)<>"T-1") AND ((dbo_Main.Active)=True) AND ((dbo_Main.T1SeriesA)=[Series])) OR (((dbo_Main.CircuitType)<>"T-1") AND ((dbo_Main.Active)=True) AND ((dbo_Main.T1SeriesB)=[Series])) OR (((dbo_Main.CircuitType)<>"T-1") AND ((dbo_Main.Active)=True) AND ((dbo_Main.T1SeriesC)=[Series])) OR (((dbo_Main.CircuitType)<>"T-1") AND ((dbo_Main.Active)=True) AND ((dbo_Main.T1SeriesD)=[Series])) OR (((dbo_Main.CircuitType)<>"T-1") AND ((dbo_Main.Active)=True) AND ((dbo_Main.T1SeriesE)=[Series]))
ORDER BY IIf([T1SeriesA]=[Series],[T1CHA],IIf([T1SeriesB]=[Series],[T1CHB],IIf([T1SeriesC]=[Series],[T1CHC],IIf([T1SeriesD]=[Series],[T1CHD],IIf([T1SeriesE]=[Series],[T1CHE])))));
I am trying to select into a variable an index in a field that corresponds to another field that can appear in five different fields and then sort by that one." |
|
|
|
|
|
|
|
Able to do this in access but cannot code it for asp