Ricardo Costa
Solution Architect at |create|it|. Member of the Systems Integration and Web Development team. More recently, manager of the RAD team (Rapid Application Development) with greater focus on the OutSystems platform. Special topics of current interest include: Solution Architecture design, Integration Patterns and Enterprise Application Patterns, Software Factories, Code Generation, Web Development.
Azure Mobile Services News – Issue#4
Logging in with Google, Microsoft and Facebook SDKs to Azure Mobile Services
"One of the values that Azure Mobile Services provides is an easy way...
How to Access the Previous Row and Next Row value in...
LAG - http://msdn.microsoft.com/en-us/library/hh231256.aspx
USE AdventureWorks2012;
GO
SELECT BusinessEntityID, YEAR(QuotaDate) AS SalesYear, SalesQuota AS CurrentQuota,
LAG(SalesQuota, 1,0) OVER (ORDER BY YEAR(QuotaDate)) AS...