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 Mike Lewis 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: *

  1. andremc

    Division By 0 error in computed select

    Zhavic, My syntax was a bit off. This works great...thanks!
  2. andremc

    using isnull() for date fields

    Tried this several ways and it always displays as 1900-01-01 00:00:00.000. andremc
  3. 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...
  4. andremc

    I have a table called surveys with

    JamesLean, Thank you!! Works like a charm.
  5. 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