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
Parth Dave
NA
332
71.8k
Cross tab query/ Pivot. How should i do???
Mar 9 2014 10:18 AM
I got stuck at a place while making attendance application. VB.
GUYS CAN SUGGEST ME QUERY FOR FOLLOWING .
NO STORE PROCEDURE PLEASE,
I have a table in my sql database.
2 columns , name and dates.
NAMES | DATES
abc 1-1-2014
abc 2-1-2014
cde 2-1-2014
cde 3-1-2014
efg 3-1-2014
hij 4-1-2014
i want a query so that i can show this information in GRID.
NAMES 1-1-2014 || 2-1-2014 || 3-1-2014 || 4-1-2014
abc yes yes no no
cde no yes yes no
efg no no yes yes
hij no no no yes
Can u guys suggest me a query for this. I'll do the by myself.
i am not much good at database. Thank u .
Reply
Answers (
1
)
renaming column
How to create the table for these expecting output?