.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
Kaviya Balasubramanian
Imran Ghani
Post New Web Links

I need to display and group by month/year

Posted By:      Posted Date: October 11, 2010    Points: 0   Category :Sql Server
 

I have this date format from

CONVERT

 

(CHAR(10),(INVC_DT),112) = 20090102 

but I just need the month and year in order to do the aggregations with...




View Complete Post


More Related Resource Links

Display the Sum of hours and Month Year using sql Query

  
Hi,  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            0400Apr 2010             0450-----------------------------------to get month/Year i am using this querySELECT right(convert(varchar, fromdate, 106), 8) from tbl_x where id='11101' for the sum of hours SELECT SUM(CAST(hours AS INT))AS TOTALHRS FROM tbl_x WHERE id='11101'

Matrix Report With Month/Year Columns - Display date even when there are no records for that month

  

I've created a matrix report that displays the quantity of different products  set to expire by month/year. The stored procedure returns records for a variety of products and each record contains an expiration date. If there are no products/records that contain an expiration date of lets say 6/2010 then 6/2010 will not appear as a column in the report.

I need a way to force these month/year columns to appear in the report.

 

Does anyone have a suggestion on how I can make that happen?

 

Rick Dowdall

 


Sharepoint list group by column data ,display in webcontrol like panel or label

  

I  have a sharepoint list[Managers] with groupby sector column. like below

1)Sector1
a)Dep1
b)Dep2

2)Sector2
a)Dep3

3)Sector3
a)Dep4
b)Dep4
c)Dep4

Each Sector group by column data i want to display in label or panel control.

How to do that ? how to write the logic?

REgards
mansoor

 


Regards, Mansoor

Group Results By Month, showing each month as the column

  
I have to list 50 states and the # of population per month. right now my results look something like..   CA, June, 5000 CA, July, 6000 CA, August, 7000 CA, September, 7230 I want it to show.. State, June, July, August, September CA, 5000, 6000, 7000, 8000 NJ, 4013, 5030, 7020, 7310   I was going to use a PIVOT table but.. I want the columns to expand as the coming month  comes upon us.

Date format for Year, Year-Month, and Date (Year-Month-Day) where input is not known

  
I have a requirement to capture historical events in a table. Now some events will have only Year, some Year/Month, and remaining where Date is known. We should be able to store them in the column and be able to sort etc. When publishing the information, we should be able to publish as was the input, Year only, Year-Month only, or Date. I looked at the newer Date data type. I can insert a 4 digit year, but on retrieving it is YYYY-01-01. I do not know if it has input YYYY or YYYY-MM-DD and is indeed a Date or a Year. I am trying to avoid saving the format information in another column or something. For sorting, when records have same Year, I would have another column to do relative sorting... So question is - what are my best options with SQL/Entity Framework combo. And what others have done, when encountering similar - if any. Thanks in advance. --Sharad 

report expression for month and year

  
Hi , Can anyone help me how to write a report expression to get the following out put? Actually this value is the month of previous month. I want to set default month name of the parameter to previous month. This is sep.So it should display like this; Aug - 10 Thanks shamen

Calender control to display dates of one month only

  
How to make calender control to display dates of one month only like for month of June it shows 25 to 31 of May and 1 to 5 of July. like this-   25 26 27 28 29 30 31 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 1 2 3 4 5   I want it to be displayed like this- 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30   Any ideas

How do I dynamically change and display the group of controls/content in wpf

  
The requirement for me is, based on some condition I need to show different group of controls on the screen. Gow do I achive this?

Search Scopes - new display group always shows "This site:"

  

Hello all,

I have created a new scope (Scope A) and everythind works ok. Then I wanted to create a search page (my search page with a search box and search core results) to show only the results from the created scope.

I created a new search display group (Display Group B) and assigned the "Scope A", configured the search box to display the "Display Group B" hidding the scopes drop down list and it didnt work as I wanted as it displayed all the results by default.~

How can I remove the "This site" from my display group, keeping only one scope as the default one?

Thanks for all the help

Best Regards,

André Cunha

 

 

 


List of Month and Year in SSRS report parameter?

  
Hi, I have two parameters in my SSRS Report i.e. Month and Year. I want to show the list of all Months in dropdown and years for a particular range say 1995-Current Year.
Can any one suggest me the query for how to get it to work.
Thanks!! MCP

Month Group View in Calendar

  

Dear collegs,

I have one issue and hope that you maybe can help me.

Namely, I created on new Calendar.  In that Calendar exist 5 standard views (under the main Calendar view) and that are :

1) Day Group

2) Week Group

3) Day 

4) Week

5) Month

What I need is something what missed here - Month Group (namely exists standard view Month but not Month Group).

Do maybe somebody know how can add or make Group Month ? Is for that neccesary some programing or can simply that do only isnide SharePoint.

Thanks in Advance.

Regards.

 

 

 

 


Month Group View in Calendar in SharePoint 2010

  

Dear collegs,

I have one issue and hope that you maybe can help me.

Namely, I created on new Calendar.  In that Calendar exist 5 standard views (under the main Calendar view) and that are :

1) Day Group

2) Week Group

3) Day 

4) Week

5) Month

What I need is something what missed here - Month Group (namely exists standard view Month but not Month Group).

Do maybe somebody know how can add or make Group Month ? Is for that neccesary some programing or can simply that do only isnide SharePoint.

Thanks in Advance.

Regards.


Group Parent-Child attributes with same display value

  

Hi all, I am very new to SSAS and have a question that I can't seem to answer anywhere

I may want to implement a parent-child attribute (depending on limitations). If I have the following hierarchical structure

 

Company

Region

Cost Centre

A

South

1

Display columns in matrix based on a group even if data don't exist in resultset

  

I am trying to create columns in a matrix for data that currently does not exist.  I created a matrix that groups on office name (ROWS) and Month of Appointment Date (Columns).

For example, the matrix currently looks like this.....

  January February March April

Ignore date and consider month and year to match

  

Hi there,

It is required to retrieve the records where ONLY Start Month, Year AND End Month, Year are passed. Trying below SQL to get these with no success. 

registrationdate BETWEEN(MONTH((registrationdate) = 01) AND (Year(registrationdate)= 2009)) AND ((Month(registrationdate) =03) AND (Year(registrationdate)=2010))


 

Help is appreciated.


month / year formatted dates

  

I need to convert an invc_date from 2009-01-01 00:00:00.000 to MM-YYYY

 

I have tried some of the stuff but not quite working for me yet


Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend