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 derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by kmerenda

  1. kmerenda

    Crosstabs and grouping - don't know which I need

    RiverGuy - in terms of using defined slices of data - we were already doing that with various reports, but we needed something that gave our administrators a live view of the traffic in each office so they could adjust staffing levels as needed. Your query worked PERFECT! I added just a few...
  2. kmerenda

    Crosstabs and grouping - don't know which I need

    I would like the output to look like: LOCATIONID - AVG TRAFFIC - CURRENT TRAFFIC 75 10 15 Keep in mind that... Current traffic = the total records with a SignInDate that falls between right now and the past 60 minutes, grouped by locationID AVG Traffic = the...
  3. kmerenda

    Crosstabs and grouping - don't know which I need

    I have a table that tracks people coming into our offices at various locations. The important fields are as follows: ID (auto generated integer) SignInDate (date/time) LocationID (integer) so a typical record would look like: 1 - 12/30/2008 8:00 AM - 75 If each person that comes in is a...
  4. kmerenda

    New to homesite and need RDS help!

    Let me preface this by saying I am a total newbie, and your mercy and assistance is appreciated. I have installed ColdFusion MX, HomeSite+ 5.5, SQL Server 2005, and IIS on my XP Home Laptop (I used a workaround to get IIS running on xp home). I am trying to learn cf, but I cannot get the RDS...
See more

Part and Inventory Search

Back
Top