I gang

Write SQL server query to get frequency of distibution of data over time in VB.NET

Write a Query for SQL server 2005 in VB.NET 2005 to get:

1. Hourly distribution of totals and count of data for certain days per week (ex Monday + Thursday + Saturday) for certain dates (ie, start date to end date)

2. Days of week distribution of totals and count of data. (ie, instead of time display days of )week.

3. Monthly distribution of totals and count of data

4. yearly distribution of totals and count of data

ex result:

Time Number of transactions quantity of Items sold Total Sales

8am - 9am 2 11 8

11am - 12pm 3 3 7

database sample table

Date Transaction number user Quantity Item name price

10/19/2010 8:21:00 AM 912 AL 3 gum 2.00

10/19/2010 8:21:00 AM AL 1 candy 3.00

10/19/2010 8:44:00 AM 913 SM 1 grocery 1.00

10/19/2010 8:44:00 AM SM 6 gum 2.00

10/19/2010 11:21:00 AM 914 AL 1 candy 3.00

10/19/2010 11:23:00 AM 915 AL 1 gum 2.00

10/19/2010 11:44:00 AM 916 AL 1 gum 2.00

Requirement:

1. provide queries only in vb.net 2005 and sql server 2005 please.

2. provide instructions on how to transfer dataset columns to rdlc report chart.

This is a simple project no high bids please. thank you and best of luck.

Evner: .NET, Microsoft SQL Server, Software Arkitektur, SQL, VB.NET

Se mere: sql price, sql get date, sm software, sm 19, sample of bids, how to write vb, how to write simple report, how to write bids, how to write a simple report, for in vb.net, vb net pivot table data source sql server database, insert xml data sql server tables vb net, time data sql server winform, insert xml data type sql server net, uusing data adaptor aspnet query sql server database, sql server query rijndael aes net, insert data sql server using visual basic net, store data time oracle sql server aspnet

Om arbejdsgiveren:
( 26 bedømmelser ) Sarnia, Canada

Projekt ID: #8760084

Tildelt til:

mahmoudgamal008

I have more than 4 years of professional and practical experience in .NET and database development. With my knowledge and background, I am confident I can make an immediate contribution to you. I'm looking forward to Flere

$25 CAD på 1 dag
(0 bedømmelser)
0.0

14 freelancere byder i gennemsnit $35 på dette job

talhaamin

I am an Expert in SQL Server 2005 and VB.NET, and is proficient in writing queries... I can write the queries you have mentioned in 1 day. Looking forward to hearing from you.

$25 CAD på 1 dag
(21 bedømmelser)
8.5
murtaza1981

Hi, Please feel free to discuss the project with me ..................................................................................................... Thanks, Murtaza

$100 CAD på 1 dag
(11 bedømmelser)
4.7
paskal77

Hello, I can develop your project [login to view URL] y ASP.net and Sql server How you want the result of each query is displayed? grid, label? You want me to tell you how to display data in a report service? Please ta Flere

$15 CAD in 2 dage
(18 bedømmelser)
4.1
Effusionflower

A proposal has not yet been provided

$30 CAD på 1 dag
(0 bedømmelser)
0.0
phsk825

A proposal has not yet been provided

$35 CAD in 5 dage
(0 bedømmelser)
0.0
activetech

A proposal has not yet been provided

$32 CAD på 1 dag
(0 bedømmelser)
0.0
sreekantha86

I have experience in vb.net, sql server, and various reporting services. I will be better with your requirements..

$25 CAD på 1 dag
(0 bedømmelser)
0.0
chhabramanoj7

My Self Manoj Chhabra, i have more then 9 yrs of experience in IT - Software and i am playing with SQL for a long, i can provide you solutions as per your expectaions

$35 CAD på 1 dag
(0 bedømmelser)
0.0
jcalia65

A proposal has not yet been provided

$35 CAD in 3 dage
(0 bedømmelser)
0.0
SPARKtechBD

VB, VB.NET, ASP.NET, MS DATABASE, MS SQL2005, MS SQL 2008 & MS SQL2012 Programmer. Experienced on Stock Exchange Ltd. for 10 year on Windows Back Office for their dealer accounts to maintain financial and securities a Flere

$25 CAD på 1 dag
(0 bedømmelser)
0.0
ritonga

A proposal has not yet been provided

$35 CAD på 1 dag
(0 bedømmelser)
0.0
imtiazmakhanivw

hello I have experience SQL for than 7 years

$40 CAD in 2 dage
(0 bedømmelser)
0.0
pradipdivekar

A proposal has not yet been provided

$40 CAD in 7 dage
(0 bedømmelser)
0.0
vmanuelr01

I'm going to complete the task in 1 day. I've been working on .rpt report and also reporting services. I can give you the solution with a linked .rdlc file using the dataset as an example

$20 CAD på 1 dag
(0 bedømmelser)
0.0