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 - 2005-11-14 : 07:20:46
|
| navin writes "convert this query of access to sqlTRANSFORM Sum(IIf(DBA_mib2HourlyStats!oututil>DBA_mib2HourlyStats!inutil,DBA_mib2HourlyStats!oututil,DBA_mib2HourlyStats!inutil)) AS UteSELECT India_Frame_MIB2_WAN_SLA.ifIndex, India_Frame_MIB2_WAN_SLA.Local, India_Frame_MIB2_WAN_SLA.Remote, India_Frame_MIB2_WAN_SLA.CircuitUserSpeed1_Kbps AS SpeedFROM India_Frame_MIB2_WAN_SLA INNER JOIN DBA_mib2HourlyStats ON India_Frame_MIB2_WAN_SLA.resID = DBA_mib2HourlyStats.resIDWHERE (((DBA_mib2HourlyStats.Dttm)>=DateValue(Now()-1) And (DBA_mib2HourlyStats.Dttm)<DateValue(Now())))GROUP BY India_Frame_MIB2_WAN_SLA.ifIndex, India_Frame_MIB2_WAN_SLA.Local, India_Frame_MIB2_WAN_SLA.Remote, India_Frame_MIB2_WAN_SLA.CircuitUserSpeed1_KbpsORDER BY India_Frame_MIB2_WAN_SLA.LocalPIVOT DBA_mib2HourlyStats.Dttm;and i want max Sum(IIf(DBA_mib2HourlyStats!oututil>DBA_mib2HourlyStats!inutil,DBA_mib2HourlyStats!oututil,DBA_mib2HourlyStats!inutil)) AS Ute field from it even" |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
|
|
|
Transform 