Time series problem

Hot Topic

Export table from SQL 2000 to SQL 2005
Web Site Admin Tool problem in VS2005
SQL Server 2005 Trigger fires per statement or per Record
WWW Service overload when trying to print a rs2005 report
SQL Server Agent Job Variables
check what table are lock by application
From MySQL to MSSQL 2005
Query problem - TIPOS IN ()
Cognos to RS
SQL Server Profiler on Analysis Server

SQL Server

SqlWb.exe window focus ON and OFF for every second!
Data Source / ODBC error
Management Studio lists all databases
attribute key cannot be found - regular hierarchy
How to Store System Variables in DB?
where are the stored procedures fields in report design?
Flat File data for every row
Dynamic Database Source Changing
Adding row with values in script
Meta Data Management / Dependancy Analysis

Time series problem

I'm going to create an analysis report based on time range. The data is grouped by the hourly range. There're two problems that I'm facing.

1. How can I generate such result set so that it will give me 0 count instead of missing that column

2. How can I vary the start and end time which depends on another table

I believe this is quite hard to be complete within a single SQL. However, I would still want to try. The SQL server is the Express version. No analysis service is available.




Answer this question

Time series problem

  • tom stucki

    1. create a table that contains the hour and left join to yourtable

    2. take a look at dateadd() function

    If this does not answer your question, post your table structure, some sample data and the expected result


  • Time series problem
Answer this question