T-SQL How to Print one Column data based on another column data?

Question

Post reply

T-SQL How to Print one Column data based on another column data?

durga.palepu

Hall of Fame

Points: 3530
More actions
June 11, 2016 at 5:12 am

#308348

Hi Friends,
I have a problem, please help me out.
The table has 2 columns c1, c2.
clc2
A5
B3
C2
Write a SQL query to return the output where column c1 printed column c2 times i.e. A printed 5 times:
A
A
A
A
A
B
B
B
C
C
Thanks in advance,
Durga Prasad.

Viewing 7 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

Ed Wagner SSC Guru Points: 287026 More actions · Answer 1

This sounds a lot like homework. What have you tried thus far?

Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions

durga.palepu Hall of Fame Points: 3530 More actions · Answer 2

This is an interview question, I have tried with this solution;

SELECT Replicate(c1, c2);

the result I got is:

AAAAA

BBB

CC

Ed Wagner SSC Guru Points: 287026 More actions · Answer 3

My first question is about the interview. How'd you do? Or is this an online interview or something?

This is entirely possible. Have you heard of a Tally table before? It's also called a table of numbers. I'm asking because I think the interviewer is trying to assess your knowledge of sets versus loops.

If you haven't heard of it, then Jeff's excellent article at http://www.sqlservercentral.com/articles/T-SQL/62867/ is an excellent place to start. To post the answer is simple, but it would skip the learning of a new skill. This is a great opportunity to learn a new skill that will serve you well.

Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions