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 Westi 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. craigcjr

    sql count statistics

    Thanks everybody, I'm up and running and everything is great.
  2. craigcjr

    sql count statistics

    thank everyone for your responses but I'm still having a hell of a time getting past the iff syntax error. The response in in a field called packet, that includes other info, but as you can see the response code (two numbers)part is parsed out. I'm wanting for R10count to give me a total count...
  3. craigcjr

    sql count statistics

    rudy, thanks for your fast reply, when I try to use your script, I get a syntax error select respdate , locator , sum(iif((right(left(packet,23),2)='10',1,0)) as R10count from responses group by respdate , locator Server: Msg 170, Level 15, State 1, Line 3 Line 3...
  4. craigcjr

    sql count statistics

    I have a table (200,000+ records) with the following fields: Ticket, Member, Response (20 different responses available), Locator, and Resptime (date and time field). I would like to create another table with Response counts: that list (date, locator, and a field for each response (ie R1 count...

Part and Inventory Search

Back
Top