This problem can be solved using CROSS JOINs as well.

My solution is followed:

create table #tblfootball

(

ID INT IDENTITY(1,1)

,NAME VARCHAR(100)

);

INSERT #tblfootball(NAME)

VALUES('a'),('b'),('c'),('d'),('e');

select *

from #tblfootball;

select row_number() over(order by t1.name) as matchnum, t1.name as...

I request you to do minimum ground work before posting a question like CREATE VIEW syntax.

Just little googling can help you for syntax.

Thank you!!

Thanks, that's awesome solution.

Your approach to provide hints so that I would work on actual solution is excellent so that I could learn my self.

Here follow's my solution implementations:

using GROUP...

Thanks for the quick response!!

However this solution is not serving the purpose.

meanwhile I have tried and my solution is as followed, the problem with solution is unique record(s) from duplicate...

Hi all,

Yes, its an interview question.

As already mentioned in my post, I have implemented the solution using Cursors but the interviewer looking for solution using single SQL query which I...

Thanks a lot.

I learned a new thing today from you.

Thanks for the reply.

My performance in interview is not up to the mark, but I have positive attitude to learn from my mistakes.

I knew the number table but not by...

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

SELECT Replicate(c1, c2);

the result I got is:

AAAAA

BBB

CC

Thank you, you saved my day 🙂

Matt Miller,

Thanks a lot, its solved the issue which I am struggling for last 2 days!!

Thanks, its helpful for me to proceed further in my work.

Hi,

Please find the solution at below thread,

http://serverfault.com/questions/152904/unable-to-connect-to-sql-server-analysis-services-on-windows-vista/153625#153625