This is a really quick tip in Excel while opening CSV filesYou’ve different methods available for the data export to csv like bcp,OPENROWSET etc.One issue that I came across recently in this was the CSV file after getting generated, if…
Checking for Integer or Decimal values using ISNUMERIC
Thanks to Erland I learned a cool way to validate integer or decimal values from varchar field having intermixed data which I’m sharing through this blog.ISNUMERIC was a function which was always thought to be unreliable due to various formats in…
SSRS Tips: Demystifying Top N Bottom N filter
The purpose of this post is to clear the confusion regarding the behavior of Top N & Bottom N filter option available in SQL Reporting Services (SSRS).Couple of days back I came across a post in one of the public…