Area 51 » bonCodigo

Follow and Support Business Intelligence Proposal

[Exploring...coding]

C# - [.DLL, .xla]
BI, Dimension modelling
QlikView [Nice]
Agile - Most useful technique for finding bugs?
SSIS, SSRS

Manipulating Access DB from Java no ODBC

Programmers CHAT:The WhiteBoard

SAMPLE ORACLE Table Schema SQLFIDDLE

• [email protected]: Active in {*BI * SQL * VBA * VB * C# ` + interesting questions on fin tech, logic/algorithms/maths.}

I am going to use this space for my favorite Q&A: Waiting for this to become a feature.

• http://stackoverflow.com/a/14201765/1389394 (exists/case using OR) http://sqlfiddle.com/#!2/a3567/1
• http://stackoverflow.com/a/2081287/1389394 (group wise max and myths)
• http://stackoverflow.com/a/14347525/1389394 (sum group by case)
• http://stackoverflow.com/a/14358522/1389394 (order by everything desc except two rows asc)
• http://en.wikipedia.org/wiki/Syntactic_sugar
• http://stackoverflow.com/questions/14125297/merging-data-in-a-single-sql-table-without-a-cursor (took me two weeks or more to find this again. I adore this query so much as my own answer logic matched this perfect answer exactly the same :D)
• http://msdn.microsoft.com/en-us/library/hh213234.aspx (sql server analytics - they rock but less mobile)

Like Java, C# does not support multiple inheritance, meaning that classes cannot inherit from more than one class. You can, however, use interfaces for that purpose in the same way as in Java.

• Multi-Threading in VBA

• Project REAL for MS BI

What is important to programmers when evaluating a job opportunity: it was as brilliantly creative and true as it could get()

• Found this while checking out anti-multiple inheritance behaviour of C#. "To celebrate my first year of programming I will ask a 'stupid' questions daily on my blog for a year, to make sure I learn at least 365 new things during my second year as a developer"

• 2013 SO survery -from user's persepctive 2012 was a hit