Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Date Range type Formula for a VarChar field
Hello Gurus, I have a perplexing little formula to write that I am at a roadblock with. I am constructing a report where I need to provide the sales figures for a definable week (easy part) as well as column for each of the past 13 weeks sales.... plus another column for the current Financial...- boatie
- Thread
- Replies: 5
- Forum: Business Objects: Crystal Reports 1 Formulas
-
T-SQL Query help
Hi All, I am (attempting to) write a select query where I want to return distinct rows based on a max/distinct criteria. please see the below query for my WIP thus far: select lintitemnumber as IPN, curcost as CurCost, dtmwhen as CurCostDate from podetail pod where dtmwhen = (select...- boatie
- Thread
- Replies: 4
- Forum: Microsoft SQL Server: Programming
