Its All About Analytics
1. SET NOCOUNT ON: Stop the message that shows the count of rows affected by a T-SQL statments. These messages can be suppressed with SET NOCOUNT ON and can increase performance by decreasing network traffic 2. IF EXISTS(): Use IF EXISTS() to check if data exist in a table or not. You can write something …
Continue reading "Six Simple Steps to Improve Stored Procedures in SQL Server"
Sept 2019 Sales Data till 09/09/2019 Sept 2018 - Full Month Sales Data A very common situation when you don't have full month data to calculate YOY ( Year-on-year), MOM( Month-on-month). You will end up with comparing incomplete month with full month data for the previous year. A simple way to compare current year sales …
Continue reading "How to Calculate YOY for Incomplete Month Data?"
Reckon Analytics 