SQL Server Forums - Loop Function

Home | Weblogs | Forums | SQL Server Links

Active Forum Topics | Popular Articles | All Articles by Tag | SQL Server Books | About

SQL Server Forums

Register Now and get your question answered!

Username:	Password:
Save Password
Forgot your Password?

All Forums

General SQL Server Forums

New to SQL Server Programming

Loop Function

New Topic

Reply to Topic

Printer Friendly

Author

Topic

funk.phenomena
Yak Posting Veteran

Canada
98 Posts

Posted - 01/17/2013 : 15:35:10

Hi all - I'm ussing SSMS 2008 and have the following table (there's about 100 rows):


USER_ID BALLOT_COUNT
jsmith 5
mdoe   3
JRoberts 2

I'd like to output the usernames on multiple lines based on the ballot count. Any idea how I can acheive this?


jsmith 
jsmith 
jsmith 
jsmith 
jsmith 

mdoe
mdoe
mdoe

JRoberts
JRoberts


SELECT USER_ID, BALLOT_COUNT FROM TABLE1

Edited by - funk.phenomena on 01/17/2013 15:56:39

jimf
Flowing Fount of Yak Knowledge

USA
2868 Posts

Posted - 01/17/2013 : 15:49:42

DECLARE @Table TABLE (UserID varchar(10),Ballot_Count int)
INSERT INTO @Table
VALUES
('jsmith', 5),
('mdoe', 3),
('JRoberts', 2)

SELECT UserID
FROM @Table t
CROSS JOIN -- use a tally table here - table that has a lot of numbers in it, this is for demo purposes only
(
VALUES
(1),(2),(3),(4),(5)

) a(num)

WHERE t.Ballot_Count >= a.num

Jim

Everyday I learn something that somebody else already knew