Find Jobs
Hire Freelancers

A procedure that produce a list.

$30-5000 USD

Closed
Posted over 21 years ago

$30-5000 USD

Paid on delivery
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!!
Project ID: 2864107

About the project

15 proposals
Remote project
Active 22 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
15 freelancers are bidding on average $40 USD for this job
User Avatar
See private message.
$42.50 USD in 14 days
5.0 (137 reviews)
7.0
7.0
User Avatar
See private message.
$12.75 USD in 14 days
4.9 (69 reviews)
4.2
4.2
User Avatar
See private message.
$34 USD in 14 days
5.0 (38 reviews)
4.1
4.1
User Avatar
See private message.
$4.25 USD in 14 days
5.0 (5 reviews)
3.5
3.5
User Avatar
See private message.
$21.25 USD in 14 days
4.7 (7 reviews)
2.5
2.5
User Avatar
See private message.
$85 USD in 14 days
5.0 (1 review)
2.3
2.3
User Avatar
See private message.
$4.25 USD in 14 days
5.0 (2 reviews)
1.3
1.3
User Avatar
See private message.
$34 USD in 14 days
5.0 (2 reviews)
0.0
0.0
User Avatar
See private message.
$42.50 USD in 14 days
0.0 (0 reviews)
0.0
0.0
User Avatar
See private message.
$38.25 USD in 14 days
0.0 (0 reviews)
0.0
0.0
User Avatar
See private message.
$85 USD in 14 days
0.0 (0 reviews)
0.0
0.0
User Avatar
See private message.
$42.50 USD in 14 days
0.0 (1 review)
0.0
0.0
User Avatar
See private message.
$12.75 USD in 14 days
0.0 (0 reviews)
0.0
0.0
User Avatar
See private message.
$59.50 USD in 14 days
0.0 (1 review)
0.0
0.0
User Avatar
See private message.
$85 USD in 14 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of SWEDEN
Sweden
0.0
0
Member since Jul 23, 2002

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759) & Freelancer Online India Private Limited (CIN U93000HR2011FTC043854)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.