daily 06/11/2015

• Cricket and the Power BI Designer – PowerBI – Site Home – MSDN Blogs

• Code | Bloomberg

• Microsoft kills off Skype for Windows touch app in favor of desktop version | The Verge

• Time to revisit the Power Pivot Import Wizard – PowerPivotPro PowerPivotPro

• Hate Cold Calling? 4 Steps to Get Over Your Fear

• Where Content Marketing Meets Customer Experience, Part 1: Regulated Industries – Marketing Action Blog – Act-On

• VLOOKUP Functionality in Power Pivot

• Hierarchies in Power Pivot

• SQL Expression to retreive last 6 months of data

  • hi Experts,

     

    I’m trying for an expression to retreive last 6 months of data from present date…like Get all dates  between october 1st 2010 and march 31st 2011 but i’m looking for a generic expression .

  • if you are looking for the past 180 days, it would  be this

     

    select * from tablename where dtstamp>getdate()-180

     

    if you are looking for the past 6 months it would be this.

     

     

     

    select * from tablename where dtstamp >dateadd(mm,-6,getdate())

• Even after doubling its investments, Britain can’t get the trains to run on time – Quartz

  • Few of Britain’s disgruntled train riders will feel much sympathy for Network Rail, the state-owned operator of the country’s rail infrastructure.

Posted from Diigo. The rest of my favorite links are here.