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-14 : 13:15:21
|
| what is the proper syntax for this case statement. I am tryingto check for 0 or the correct value.select a.startstep, b.endstep, (select case rowspan when b.endstep-a.startstep=0 then 1 else b.endstep-a.startstep end) as rowspan, a.eid, c.pid, a.uid, a.sdesc, a.sdate, a.edate, a.clblock from #starttimetab aINNER JOIN #endtimetab b ON a.eid = b.eidINNER JOIN #users c ON c.UID=a.UIDWHERE c.pid=@xORDER BY c.pid, a.sdateSET @X=@X+1thanksslow down to move faster... |
|
|
|
|
|
case statement