I nead an MS SQL Procedure that generating a list of how many entrys from the Table1 that are within a single year, month, day. I must be able to give a criteria to those fields "bolag, filial, datum, avdelning" I must be able to select all fields that have "datum" between two dates. (2001-06-01 - 2002-05-01) The output list must generate a list of fields as following. Year month1, month2, month3, ---> month12 Month day1, day2, day3, ---> day31 Day hour1,hour2,hour3,---> hour24 Example1: If i want to produce a list for one year and January and June has zero entrys those fileds should have the value of "0" and all other fields should have the value of how many entrys there are within that specified month. The same is from Year, Month and day. Thetable look like this: Table1: CREATE TABLE [dbo].[t2A] ( [ID] [int] IDENTITY (1, 1) NOT NULL , [Bolag] [smallint] NULL , [Filial] [smallint] NULL , [Datum] [datetime] NULL , [Avdelning] [varchar] (5) COLLATE SQL_SwedishStd_Pref_CP1_CI_AS NULL , ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] The code should work with Microsoft SQL server 2000.
## Deliverables
Complete and fully-functional source code of all work done. Complete copyrights to all work purchased.
## Platform
Microsoft SQL Server 2000 MS SQL Code
## Deadline information
Nead to have it compleated within one week!!