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!

Register Log in
  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: Stevan23
  • Content: Threads
  • Order by date
  1. Stevan23

    If data exists in view return data otherwise return 1 percent for each farm & egg type

    Hi all, We are using Microsoft SQL Server 2008 and are querying a SQL view that contains information about our egg grade percentages for each farm. A manager wants as part of the query if a farm does not exist for the last seven days then it is it return a default percentage of one for the...
  2. Stevan23

    Cross tab formula

    Hi all, We are trying to come up with a forecast report and are trying to calculate the opportunity cost. We have created a formula - ABS(IF(D22<0),(-D22-E22)) - in Excel where this is basically saying if the net quantity difference between the forecast, actual and sales for the second most...

Part and Inventory Search

Back
Top