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 Wanet Telecoms Ltd 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: andremc
  • Content: Threads
  • Order by date
  1. andremc

    Division By 0 error in computed select

    How is division by 0 handeled in a computed select statement. I have tried a case stmt. without luck. Here is an example of what I'm trying to accomplish: SELECT d.first_name, d.last_name, r.Store_Id, r.LMLY, r.Gallons_1mo, --(r.Gallons_1mo / r.LMLY)-1 as MOM_Change_Per FROM...
  2. andremc

    I have a table called surveys with

    I have a table called surveys with columns (store_id, survey_date) Store_id is an int, survey_date is a datetime. They query I need to write needs 2 greatest survey dates for each store in one bitlist. Any assistance is appreciated (using sqlServer2000). Thank you.

Part and Inventory Search

Back
Top