TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
Santhosh Kumar Jayaraman
NA
7.1k
3.6m
Display Blank when column values are repeated
Jun 12 2012 7:59 AM
My stored proc out put is
Week Name
1220 LOndon
1220 AUstralia
1221 London
1221 Singapore
1221 Zurich
But i dont want to repeat week again in columns. So i am expecting something like below
Week Name
1220 London
Australia
1221 London
SIngapore
Zurich
I dont want to do this in Excel, i just want to do it in Stored proc output. Can anybody help me??
Reply
Answers (
2
)
PIVOT and UNPIVOT in SQL Server
Aggregate Functions in SQL Server