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 IamaSherpa 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: db2mo
  • Order by date
  1. db2mo

    Combine 1 row into 2

    Hi, I have a statement where I'm trying to combine the data of two rows into one. My data has to do with crash circumstances. I am selecting the cicumstance and the accident no. Circumstance '04' and '05' are the same. I want to combine all the instances where there is a circumstance '04'...
  2. db2mo

    Return 0 With Null Value

    I have a Select statement which is doing a count. For the column that is being counted, I want the null values that are returned to be 0. I've tried using ISNULL and IFNULL, but no luck. Here's the part of the code that I need to return 0 instead of null: (SELECT COUNT(QO01ACCIDENT_NO) AS...
  3. db2mo

    Using DB2 in SSRS

    I'll give that a try. Thanks for the response.
  4. db2mo

    Using DB2 in SSRS

    Hi, I'm using DB2 tables to run a report in SSRS 2008. The first issue I'm having is comparing the date in my DB2 table to the system date. How would I code that? Currently the code looks like this: SELECT CNT AS ACC_CNT, KILLED, INJURED, INCYEAR AS ACC_YR, (CASE SEVERITY WHEN '1' THEN...

Part and Inventory Search

Back
Top