Tags
Complex SQL Challenges, Complex TSQL Challenge, Interview Qs.SQL SERVER Questions, Interview questions on Joins, Interview Questions on SQL, InterviewQuestions, InterviewQuestions for SQL, Joins, Joins Interview questions, Joins Puzzle, Learn complex SQL, Learn SQL, Learn T-SQL, Objective Puzzle, Perfect Numbers, PL/SQL Challenges, Puzzles, Queries for SQL Interview, SELECT Puzzle, SQL, SQL 2012, SQL 2014, SQL 2014 Interview Questions, SQL Challenge, SQL Challenges, SQL Joins, SQL pl/sql puzzles, SQL Puzzles, SQL Queries, SQL SERVER Interview questions, SQL Skills, SQL Sudoku, SQLSERVER, T SQL Puzzles, T-SQL Challenge, Tough SQL Challenges, Tough SQL Puzzles, TSQL, TSQL Challenge, TSQL Challenges, TSQL Interview questions, TSQL Queries
T-SQL Query | [ The ASCII Puzzle ]
Puzzle Statement
We have characters A to Z if the input is A then it should be print Z, if the input is B then o/p will be Y.
Sample Input & Corresponding Expected Output
| Sample Input | Expected Output |
| Z | A |
| A | Z |
| B | Y |
| C | X |
UPDATE – 25-Apr-2015 – Solution 1
--
DECLARE @t AS VARCHAR(1)= 'C'
SELECT CHAR(ASCII('A') + ASCII('Z') - ASCII(@t))
--
|
Add a comment if you have any other solution in mind. We all need to learn.
Keep Learning
Improving my SQL BI Skills 
Pingback: SQL Puzzle | The ASCII Puzzle – II | Improving my SQL BI Skills
–Solution 1.
DECLARE @UserInput varchar(100)=’A’
DECLARE @Diff int=(SELECT ASCII(@UserInput)-65)
DECLARE @Opposite int=90-@Diff
SELECT @UserInput as SampleInput,Char(@Opposite) as ExpectedOutput
–Solution 2.
DECLARE @SampleInput table(SampleInput varchar(10))
insert into @SampleInput (SampleInput) values(‘Z’)
insert into @SampleInput (SampleInput) values(‘A’)
insert into @SampleInput (SampleInput) values(‘B’)
insert into @SampleInput (SampleInput) values(‘C’)
SELECT SampleInput,CHAR(90-(ASCII(SampleInput)-65)) as ExpectedOutput from @SampleInput
LikeLike