TSQL Challenge 68 - Generate kaprekar kernel or series from numbers
This challenge invites you to Generate kaprekar kernel or series from numbers.
2011-10-31
885 reads
T-SQL Challenges
TSQL Challenge 67 - Find the longest sequence of alphabets in a string
This challenge invites you to identify the largest sequence of alphabets from a string.
2011-10-17
948 reads
TSQL Challenge 66 - Find the most relevant advertisement based on keyw
A website wants to display most relevant ads on each of its web pages based on the keywords associated with each page.
2011-10-03
566 reads
TSQL Challenge 65 - Solving the Running Total Problem
This challenge invites you to solve one of the most common calculation challenges seen in applications that deal with financial -transactions.
2011-09-19
1,647 reads
TSQL Challenge 64 - A Payroll calculation Challenge
This challenge invites you to solve a payroll challenge which requires special calculation of holidays and absences that are adjacent to holidays
2011-09-05
1,372 reads
2011-08-22
1,898 reads
TSQL Challenge 62 - Break a long sentence in groups of 5 words
Read the input string and break each sentence into groups of 5 words. A row may contain more than one sentence. Each sentence in the input should start a new group.
2011-08-08
1,220 reads
TSQL Challenge 61 - Generate an HTML calendar in TSQL
This challenge is to generate an HTML calendar based on the data stored in a table.
2011-07-25
1,836 reads
TSQL Challenge 60 - Generate a relational tree structure from a string
Your job is to read a string containing product hierarchy information and generate a relational table (result set) representing the hierarchy of categories.
2011-07-11
987 reads
TSQL Challenge 59 - Playing Chess in TSQL – Part 2
Your job is to generate a string using Forsyth-Edwards Notation which represents the final position of pieces after performing a series of moves from the original position
2011-06-27
852 reads
Blogs
Setting Up a Mac for Data Engineering and AI Work
If you work with data pipelines, SQL, notebooks, or machine learning models, a Mac...
Want to look at cloud reporting but not sure what the costs will be?
By ChrisJenkins
Have you been thinking about migrating your reporting to Microsoft Fabric or Snowflake but...
The Joyful Craftsmen and the Revolt BI join forces
The Joyful Craftsmen has become the new owner of Revolt BI. The merger creates...
Forums
SQL Art, Part 4: Happy 4th of July — A British DBA's Guide to Celebrating a War We Don't Talk About
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
Alamat BCA KCP Pejaten Tlp,Cs:0821-8154-393
WA:08218154393 Ruko, Jl. Pejaten Mas Raya Jl. Raya Pasar Minggu No.Km.20 No. 98F &...
Alamat kantor BCA KCP Galuh Mas Telp:0818751777
WhatsApp:0818-751-777 Area Street Festival, Ruko No 1 & 1A, CBD, Jl. Galuh Mas Raya,...
Question of the Day
BIT_COUNT I
In SQL Server 2025, I have a table (dbo.UserPermission) that contains this data:
UserID UserPermissions 15 23 37What is returned when I run this code:
select bit_count(UserPermissions) as PermissionCount from dbo.UserPermission where UserID = 3;See possible answers