How do I get my Datetime out in 3 dropdownlists :
ddlDay = Day
ddlMonth = Month
ddlYear = Year
View Complete Post
Using SQL Server 2005.
I need to return the year only from a datetime field and then group by that field, does anyone know the syntax for this?
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.
I have this date format from
but I just need the month and year in order to do the aggregations with...
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
How do I write my SQL so I get this result?
2010Januari(4)Februari(23)Mars(12)April(5)... and so on2009Januari(12)Februari(2)... and so on
I'm building a blog and want to have this as links. I have a field in the database "CreateDate".
Hi, most time dimensions are setup using a base Date field in the fact table, and they have plenty of issues for time analysis as it is. However my fact sales records have the time aspect assigned by pre-calculated periods, because depending on various
factors, monthly final invoices are all raised on varying days (usually 2nd friday of month but can change). The monthly period is therefore not a straight calendar month. Probably a very common scenario.
So, the invoicing system already assigns the year (ie 2009, 2010, 2011) and monthly period (1, 2, 3 ... 12 with 3 representing march, even though that might represent 13th march to 9th april) and I want to use those as Time dim so we can do YTD, growth-on-prev-year
It looks like its best to setup 2 Dimensions to link to 2 DataColumns/Attributes in the Fact table (say, FYear and FMonth, both integers). That way I can assigned attribute names like March to key column 3. If I combined them into 1 dimension with both fields
making up a single key column, would have to either repeat the month names or link it to another Star schema I believe.
I can use the Add Business Intelligence wizard to make the Dimensions into Time ones instead of regular but I'm still not totally sure if this is the best structure/method and once done, how to use the YTD calcs to show in the cube browser (and my MDX knowle
When below SQL is used to print the MONTH Names in SQL SERVER 2000, order by Month name ordering in Alphabetical order, which is incorrect.
Let me know any work around to get this order by Montly order and then Year.
WHEN MONTH(a.registrationdate) = 1 THEN 'Jan'
WHEN MONTH(a.registrationdate) = 2 THEN 'Feb'
WHEN MONTH(a.registrationdate) = 3 THEN 'Mar'
WHEN MONTH(a.registrationdate) = 4 THEN 'Apr'
WHEN MONTH(a.registrationdate) = 5 THEN 'May'
SPQuery to get all Items Modified in Current Month/Year I have a SharePoint List. Using CAML I need get all the Items that are modified in the current Month/Week/Year.?
Can anybody help me to achieve this?
I have a SharePoint List. Using CAML I need get all the Items that are modified in the current Month/Week/Year.?
Can anybody help me to achieve this?
from my sql blogs table, I want to generate blog archive section on my master page. like;
january, 2010 (20)
fabruary, 2010 (35)
I cannot come up with a linq to sql query on this. do you have any idea how it can be done ?
I went through this post http://stackoverflow.com/questions/2208480/jquery-date-picker-to-show-month-year-only which is very helpful to me in order to hack the datetime picker UI to suit my situation. But as I have several datetime picker on the same form, this happens. The css display:none is aim to 'hide' the days not to be shown. But if I have several datetime picker on the same form but only one I wish to make one of it monthpicker, how can I achieve that? With thw css, it makes all the days on the all datetime calender UI disappear since the css will change the attribute of .ui-datepicker-calendar. Any suggestions are welcome. Thanks. This is my first post.