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!
-
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!
Recent content by 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...- kmerenda
- Post #5
- Forum: Microsoft SQL Server: Programming
-
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...- kmerenda
- Post #3
- Forum: Microsoft SQL Server: Programming
-
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...- kmerenda
- Thread
- Replies: 6
- Forum: Microsoft SQL Server: Programming
-
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...
