Dynamic Sorting in SSRS
Introduction
Many times while developing any report we come across a situation where we need to SORT the TABLE columns or...
2017-05-19 (first published: 2011-12-26)
21,119 reads
Introduction
Many times while developing any report we come across a situation where we need to SORT the TABLE columns or...
2017-05-19 (first published: 2011-12-26)
21,119 reads
Introduction
Common Table Expression (CTE) has become very popular these days. However, many users of CTE still have a myth that...
2017-02-08 (first published: 2011-12-15)
11,534 reads
Introduction
People working on SSRS are well aware that “Report Manager” does not support downloading all the report files (.rdl files)...
2013-08-12 (first published: 2013-08-07)
13,385 reads
Introduction
Recently, I was asked to develop a SSRS based report for the Event Management module in MS Dynamics CRM 2011....
2013-04-18 (first published: 2013-04-09)
13,231 reads
Were you ever asked to generate string Permutations using TSql? I was recently asked to do so, and the logic...
2013-03-11
882 reads
Generally, we try to find out records matching a certain criteria from a single or few tables. However, there are...
2013-03-07
1,980 reads
Today, I am going to share few very useful scripts which will report us on Database Backup from different view...
2012-10-18
7,048 reads
Problem Statement
SQL Server has got in-built functions to convert the given string into LOWER() or UPPER() format but it does...
2012-10-18 (first published: 2012-10-15)
13,473 reads
Introduction
Today, I would like to explain one way in which we can store the HIERARCHICAL data in SQL tables. A...
2012-03-28
1,824 reads
On many forums I have found a very basic yet important query - “How can I know when was my Stored...
2012-03-12
21,505 reads
By Steve Jones
I’ve been very happy with Docker Desktop for years, running it on both laptop...
By Rayis Imayev
(2025-June-15) Long gone are the days when a data engineer could simply focus on building...
By Ed Elliott
I recently encountered an interesting issue with ADF where the publish feature suddenly attempted...
Comments posted to this topic are about the item How Many Can Be the...
Comments posted to this topic are about the item How to process images and...
Comments posted to this topic are about the item Patching the Patch
I am trying to analyze a number of columns in a large table to determine the highest value for each row. In SQL Server 2022, we have the GREATEST function, which will return the greatest value from those columns passed in. How many columns can I include in an expression like this:
select GREATEST( col1, col2, col3, ...)See possible answers