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.

 All Forums
 Development Tools
 Other Development Tools
 IF THEN Statement Help

Author  Topic 

ggarza75
Yak Posting Veteran

50 Posts

Posted - 2009-07-20 : 13:12:15
I'm creating a report that shows hour many hours a user has worked on a clients case. There are times when the user will not work on a case for weeks or months. Even though the user has no activity on a case for the month of May, for example, I still want the report to show zero hours for that case.

Not sure how to write up the IF THEN statement. Thanks for any help.

afrika
Master Smack Fu Yak Hacker

2706 Posts

Posted - 2009-07-20 : 16:41:00
is this homework ?
Go to Top of Page
   

- Advertisement -