SQL Server :: How To Get The Data In A Table Based On Month And Year

Jan 8, 2011

I have a requirement that I have to retrieve data base on month and year.I am using the below query

<pre lang="sql">SELECT SUM(areasft),DATEPART(year, sdate),DATEPART(month, sdate) FROM storedata
GROUP BY DATEPART(year, sdate) ,DATEPART(month, sdate)
ORDER BY DATEPART(year, sDate) ,DATEPART(month, sDate)</pre>

The above query is retrieve data like below.

SUM YEAR MONTH
51013 2000
1
30970 2007
1
NULL 2007
3
900 2007
6
807 2007
8
NULL 2007
9
1756 2007
10
7535 2007
11
NULL 2008
1
1193 2008
2
4230 2008
3
350 2008
4
2200 2008
5
4660 2008
6
6685 2008
8

But I need to display including all the months of the year along with year irrespective of SUM . My query only displays only some months in a year.

View 12 Replies


Similar Messages:

Web Forms :: Get Start And End Date In A Month Based On Month And Year

Jun 7, 2012

lblperiod.Text = " period " + "01/" + drpsmon.SelectedValue + "/" + drpsyr.SelectedItem.Text + "---" + System.DateTime.DaysInMonth(DateTime.Now.Year, DateTime.Now.Month) + "/" + drpsmon.SelectedValue + "/" + drpsyr.SelectedValue;

i want the daate ie the 1st to  the end of month when page is loaded i get the current months 01/06/2012 - 30/06/2012  but i want it on dropdown changed

i mean whever the user selcts in dropdown for month & year i want the period for the same

View 1 Replies

Data Controls :: Get Data In GridView Of Month And Year Less Than Current Month / Year

Jan 30, 2014

I am having one table in whic there is monthyear column and amount column..i want the data in gridview of monthyear less than current monthyear ...

my table entry is like this

Monthyear                Amount

December 2013        10000
January 2014            20000
February 2014          60000
March 2013               40000

View 1 Replies

C# - Get Total Number Of Days In A Month Based On Year?

Jan 20, 2011

I am using a drop down lists for selecting the month and year in .aspx page. I have to get last date of the selected month of particular selected year in .aspx.cs page. (some months have 30 days and some have 31 days)

View 2 Replies

Web Forms :: Results Based On Dropdown Selection Of Month And Year

Jan 13, 2014

I am trying to display results based on both dropdown list selection.If a user selects Jan from 1st ddl and 2013 from 2ns ddl then results of Jan 2013 will be displayed to the user,everything works fine,I wanted to confirm the query that I have used is correct or not.

Store Procedure

Create proc usp_monthwisedata
@month int,
@year int

[Code].....

My concerns are:

1.Is the way of writing the Sp is correct to achieve the result.

2.Is it correct to set the onselectedindexchanged of both the ddls to 1 method i.e onselectedindexchanged="DropDownList1_SelectedIndexChanged" 

3.Over all Performance wise is it correct.

View 1 Replies

SQL Server :: How To Get Month And Year In Single Column And Grouping The Data For All The Years And Months

Jan 10, 2011

For the below query (sdate is column name and table name is storedata)

View 2 Replies

SQL Server :: How To Get Both Month And Year Together From A Date

Jan 10, 2011

I have a column in report that should display month and year together i.e single column will have both month and year(this is the first column of the table).

Ex: JAN/11
FEB/11
.
.
DEC/11

How can I do this?

View 3 Replies

SQL Server :: Display The Sum Of Hours And Month Year Using Query?

Sep 10, 2010

I have,hours(in varchar),Id in table tbl_x ,i need the sum of hours, monthyear(eg. mar 2010)for the last three months.But with two separate queries i am getting these results.but actually i need in the following format

Month/Year TotalHours
----------------- ----------------
Mar 2010 0400
Apr 2010 0450

to get month/Year i am using this query

[Code]....

View 5 Replies

C# - Selecting Data From SQL Server Table According To Month?

Mar 31, 2010

I have to come up with a way to get data from a SQL server table given it's month

There's a smalldatetime type field called "date" in the "events" table and a field from it looks like this:

29/01/2003 17:00:00

It should be one among those that appear in the gridview when I select jan/03 in a given DropDownList control in ASP.NET.

What would be the best way to do this? Assuming I only want to go as long as 10 years to the past, wouldn't making a dictionary be a good way?

How do I change it so the top month is always the current, and each month another options appeaars in the dropdown ?

It should be a common issue, so that shall not be a trick, but I want a good and clean way of doing this, and (since I'm new to asp.net) I myself would come up with something messy after a long time trying.

So what I want is:

1) Select

2) Best way of populating DropDownList (with the current month always at the top)

3) Best way to bind the DropDownList user-friendly way of writing months to the select query-friendly way of writing datetimes

Info: ASP.NET, (C# or VB.NET), SQL Server 2005

View 4 Replies

Data Controls :: Adding Day Month And Year Date DropDownList In DetailsView Control

Dec 19, 2012

How can we add a drop down calendar to one of the cell of details view.

Actually i want to add three drop down list one for month , other for year and third one for days.

View 1 Replies

SQL Server :: How To Get Number Of Year / Month And Days By Given Days

Jan 31, 2011

I would like to get number of Year, Month and Days by Given days.

Eg:- My input is 400 out put like as 1 year 1 Month and 4 Days.

How to do it?

View 5 Replies

SQL Server :: Name From Table A ,minimum Rate1 And Rate2 Values For A Month In A Dropdownlist From Date Field From Table B?

Nov 19, 2010

I need to write a query to populate a gridview with minimum rates in ascending order for a month from three tables.For example i have three tables A,B,C as follows

TABLE A TABLE B
TABLE C
Id id id
Quote_no Quote_no Quote_ no
Name Rate1 Equip_name
Rate2 E_rate
Date R1_rate
R2_rate
Date

Now if the data is as follows

I need to get the Name from Table A ,minimum Rate1 and Rate2 values for a month in a dropdownlist from date field from Table B and the corresponding minimum rate(E_rate) for Equipment E1 and E2 only from Table C for the month in ascending order group by Name.

TABLE A

id
Quote_no
Name
1
101
XYZ

2
102
ABC
TABLE B
id
Quote_no
Rate1
Rate2
Date

1
101
105
200
12/11/2010

2
102
90
210
15/11/2010

TABLE C
id
Quote_no
Equip_name
E_rate
R1_rate
R2_Rate
Date

1
101
E1
60
0
0
12/11/2010

1
101
R1
0
110
0
12/11/2010

1
101
E2
80
0
0
12/11/2010

2
102
R2
0
0
300
15/11/2010

2
102
E2
100
0
0
15/11/2010

2
102
R1
0
60
0
15/11/2010

2
102
E1
230
0
0
15/11/2010

View 9 Replies

How To Get Current Month And Year

Oct 8, 2010

how i can get current month and year and show it in a lable in asp.net

View 4 Replies

SQL Server :: Ascending Order Based On The Date And Month?

Oct 7, 2010

Ascending order based on the Date and month?

[Code]....

View 2 Replies

How To Add Date/month/year From Dropdownlist

Feb 11, 2011

I am developing a project in asp.net using c# coding. I m new to this field.

I need to add day/month/year to a text box in asp.net.

I hv 3 drop-down list. when i m selecting 3 dropdown list, its value must de shown in a text box.

View 1 Replies

C# - How To Get The Number Of Days In A Particular Month And Year

Jul 29, 2010

how to get the days for particular month and year

Given the following method:

GetDaysPerMonth(string monthName, string year);

And the values "1" and "2010", how can I return the number of days within the specified month?

View 3 Replies

C# - Datetime Format For Month And Year

Aug 18, 2010

DateTime ExpMonth = Convert.ToInt32(ddExpMonth); ---- DropDown(user selects a month)
DateTime ExpYear = Convert.ToInt32(ddExpYear); ---- Dropdown(user selects year)
Datetime ExpDate = ///// I want this part to be saved as Datetime 02/2012

How is this possible?

View 4 Replies

Two Buttons For Next And Previous Month And Turn Next Year?

Jul 4, 2010

I have 2 button links and 1 text like this:

Previous JULY Next
Every time i press Previous, a variable mymonth subtracts 1 , and when if i press
Next , the variable mymonth adds 1.
Previous LINK: <%# mymonth - 1 %>
Next LINK: <%# mymonth + 1 %>

All the schedule from the DB is shown, using the following SQL:

SELECT DISTINCT day(mydate) FROM schedule WHERE month(mydate)=" + mymonth + " AND year(mydate)=" + myyear + " ORDER BY day(mydate) ASC"

But my problems are:

- i want to show 3 months backwards from th actual month

- when mymonth is 1 (January) 2011 for example, it would show December, November and October from 2010

- If for example, we are in JULY, it would show until APRIL backwards, and when on APRIL it wouldnt show the PREVIOUS button.

View 3 Replies

VS 2008 Building An Array - Month / Year?

May 26, 2010

I am building an array by month and year. Present format is mm/yyyy. I need the format to be mm/yy.

Code:
Dim myNewdate As DateTime
Dim myMonthArray(11) As String
Dim i As Integer = 1
[code]....

View 4 Replies

C# - How To Find Year And Month Difference Between Two Dates

Jan 20, 2011

DateTime dayStart;
DateTime dateEnd;

TimeSpan ts = dateEnt - dateStart;

Print : ... Year(s) and ... Month(s)

how can I calculate it?.net framework 2.0c# asp.net project.

View 3 Replies

Date Format Followed By Month / Year In String

Feb 17, 2010

I want to date format like this 1-Apr-2010 in asp.net (1st date followed by month in string and followed by current year....).

View 4 Replies

AJAX :: Add Dropdown For Selecting Month And Year

Mar 24, 2011

Is it possible to add dropdown for selecting month and year within ajax calender.

View 5 Replies

Extracting Month / Date Or Year Only From Textbox?

Nov 23, 2010

I have a textbox that gets the date from an AJAX Calendar extender. What I need to do is extract the "month," "day," and "year," and put them into seperate string variables to use in my code to do various things based on the month, day or year respectively.

Here is what I have so far:

[code]....

But I don't want the year NOW, I want the year from the textbox.

View 3 Replies

C# - Populate Drop Down List With Month / Year?

Jan 22, 2011

I have a date and I need to populate a drop-down with the months/years between that date and today. For instance, if that date is 10/14/2010 then the drop-down should contain October 2010, November 2010, December 2010, January 2010.

The way I'm thinking of doing this is to pass that date to a function, loop from today backwards step 1 month while adding each month to a collection until we reach that date and finally return a collection of strings. Then, populate the drop-down control on page load. Finally, use some ajax with a page method to parse back the string and trigger a partial page reload.

View 3 Replies

Web Forms :: How To Make Year And Month As DropDown In Web Calender

Aug 2, 2010

Is there any way that we can make year and Month as DropDown in Web Calender.

View 8 Replies







Copyrights 2005-15 www.BigResource.com, All rights reserved