Viewing 8 posts - 31 through 38 (of 38 total)
joseph.connor (12/2/2014)
Neat, although isn't the Floor function obsolete, since you're performing an Integer Division?
well spotted, I was guarding against it rounding up where fractional part was > 0.5, but integer...
December 5, 2014 at 2:46 am
Most cultures celebrate the birthday of a "Leaper" on the 28th February, so a Leaper born on 2012-02-29 would celebrate their first birthday on 2013-02-28 and their
second on 2014-02-28.
its...
December 2, 2014 at 6:25 am
A person born on 2012-02-29 should be how old on 2014-02-28?
1 year old still, the day has not rolled over to 1st March
select '20120228' , FLOOR((CONVERT(INT,'20140228') - CONVERT(INT,'20120228'))/10000) , FLOOR((CONVERT(INT,'20140301')...
December 2, 2014 at 6:09 am
If you only need age in years, then the following is easier as it does not need you to create a function so can be used directly in a select...
December 2, 2014 at 2:21 am
Msg 156, Level 15, State 1, Procedure my_sp, Line 2
Incorrect syntax near the keyword 'FROM'.
the explanation says
"Actually SQL Srever only check syntactical accuracy when a stored procedure is created. Only...
October 15, 2014 at 2:24 am
not sure what you mean by ODS (operational data store?), if you mean it to be the same as a datawarehouse, i.e. bringing together data from various systems, e.g. finance,...
August 1, 2014 at 7:19 am
the simple answer is that the datamart/datawarehouse must contain raw detailed records, otherwise you can't create the OLAP cube
the OLAP cube should only contain summarised data, otherwise they become slow...
August 1, 2014 at 2:07 am
Viewing 8 posts - 31 through 38 (of 38 total)