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,180 reads
Vinay
How many times the T-SQL inside the CTE is executed?
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,567 reads
SSRS – Download all RDL files from Report Server in one go.
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,393 reads
SQL Server – Generate Calendar using TSQL
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,247 reads
SQL Server – Generating PERMUTATIONS using T-Sql
Were you ever asked to generate string Permutations using TSql? I was recently asked to do so, and the logic...
2013-03-11
890 reads
SQL Server – TSql to find Records matching certain criteria in all the tables of a DB.
Generally, we try to find out records matching a certain criteria from a single or few tables. However, there are...
2013-03-07
1,993 reads
SQL Server # Database Backup Report using T-SQL
Today, I am going to share few very useful scripts which will report us on Database Backup from different view...
2012-10-18
7,056 reads
SQL Server # TSQL to Convert STRING in PROPER format
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,502 reads
SQL Server # Storing Hierarchical Data – Parent Child n’th level # TSQL
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,831 reads
Last Execution Date Time of a Stored Procedure
On many forums I have found a very basic yet important query - “How can I know when was my Stored...
2012-03-12
21,691 reads
Blogs
T-SQL Tuesday #198 Invitation: How Do You Detect Data Changes?
It's time for T-SQL Tuesday #198! This month's topic is change detection. The post T-SQL...
Understanding Fabric MCP
By James Serra
Model Context Protocol, or MCP, is one of those technical ideas that sounds more...
AWS RDS Aurora - our first approach
When starting with AWS RDS Aurora for managing relational databases in the cloud, many...
Forums
BCA KCP Yos Sudarso WhatsApp 08388331786
Call cs 08388331786.Jl. Kebon Bawang VII No.40 2, RT.2/RW.6, Kb. Bawang, Kec. Tj. Priok,...
SQL Password enforcing
Hi to all We have situation at a client where someone is illegally changing...
SQL Password enforcing
Hi to all We have situation at a client where someone is illegally changing...
Question of the Day
Creating a JSON Document III
I have this data in a table called dbo.NFLTeams
TeamID TeamName City YearEstablished ------ -------- ---- --------------- 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933 3 Packers Green Bay 1919 4 Chiefs Kansas City 1960 5 49ers San Francisco 1946 6 Broncos Denver 1960 7 Seahawks Seattle 1976 8 Patriots New England 1960If I run this code, how many rows are returned?
SELECT TOP 2
json_objectagg('Team' : TeamName)
FROM dbo.NFLTeams;
See possible answers