Author: James

SQL Server Management Studio – Order by different columns based on values in the different columns

Wrap your head around this one!

Here is an example of an order by in a SQL Statement that shows how specific you can get when ordering your data.
order by location_3,
case 
 when location_3 ='c' then
 case 
 when location_4
…

SQL Server Reporting Services (SSRS) – Order by different values from the same database table column

Let’s say you want to order your data in your tablix by last name, but you want certain names to be sorted first.

1) Double click the first grouping under Row Groups.
2) Select ‘Sorting’.
3) Click the ‘Add’.
4)

…

Microsoft Excel: File May Have Been Changed by Another User Since You Last Saved It. In That Case, What Do You Want to Do?

Many people claim that they know what causes the issue. For me, it just started out of the blue one day when I attempted to save an excel file into my OneDrive folders. All the other computers in my house …