SELECT SQL Select SQL and upgrade your performance

Details

Written by Stanislav Duben

Parent Category: MSSQL

Published: 28 May 2018

Last Updated: 28 May 2018

Hits: 131584

There is an issue with Leap Year and DateAdd function that can appear if you want to compare two dates from different years and using some date value from table. For example if you have calendar table and use DateAdd function, you can get 2 rows wit two date for one source date instead of expected 1 row. See bellow reason and solution.

Details

Written by Stanislav Duben

Parent Category: MSSQL

Published: 20 March 2018

Last Updated: 20 March 2018

Hits: 23880

When you need select Min or Max value from table with one column, it's easy SQL task. A little harder is same request when you want to find minimum value and maximum value associated with column from minimal value row. For example, let's say we want see Customer with his minimum sales order plus amount value of this order and compare it to maximum value from any other order made with this customer.

Details

Written by Stanislav Duben

Parent Category: MSSQL

Published: 01 November 2017

Last Updated: 01 November 2017

Hits: 114539

Are you trying convert float to numeric and you get "Arithmetic overflow error converting float to data type numeric" error? This could happen even if all was working before and now it fails. The reason should be in precision and scales settings.

Details

Written by Petr Slaba

Parent Category: MSSQL

Published: 15 June 2017

Last Updated: 15 June 2017

Hits: 16977

When you alter view or stored procedure and you realize, previous version wasn't saved and you need it. Or you want recover SQL script immediately after management studio crash and you were lucky, that you run it at least once. There is a nice tricky way how do to it by SQL script without any 3rd party enhancement. 

Details

Written by Stanislav Duben

Parent Category: MSSQL

Published: 04 April 2017

Last Updated: 11 April 2017

Hits: 75704

Sometimes it can happen, that you compare two strings, which looks exactly sames, but they are processed as not equal. Also when you use SELECT DISTINCT and still there are rows that looks same, like DISTINCT is not working. Dimensional attribute in OLAP can return errors for duplicities even you used DISTINCT for dimension. This is the right time to search invisible/hidden characters in string.  RTrim and LTrim function not stripping whitespace.