Click here to Skip to main content
15,867,594 members
Home / Discussions / Database
   

Database

 
QuestionFind Last week dates? Pin
Member 387988114-Jul-08 3:04
Member 387988114-Jul-08 3:04 
AnswerRe: Find Last week dates? Pin
subai14-Jul-08 3:21
subai14-Jul-08 3:21 
AnswerRe: Find Last week dates? Pin
leoinfo14-Jul-08 3:35
leoinfo14-Jul-08 3:35 
AnswerRe: Find Last week dates? Pin
TheFM23414-Jul-08 6:26
TheFM23414-Jul-08 6:26 
JokeRe: Find Last week dates? Pin
leoinfo14-Jul-08 18:27
leoinfo14-Jul-08 18:27 
GeneralRe: Find Last week dates? Pin
TheFM23415-Jul-08 3:24
TheFM23415-Jul-08 3:24 
GeneralRe: Find Last week dates? [modified] Pin
Member 387988114-Jul-08 18:47
Member 387988114-Jul-08 18:47 
QuestionHow to write query Pin
BalasubramanianK14-Jul-08 0:23
BalasubramanianK14-Jul-08 0:23 
Hi,

My Table structure is look like this.....Code, Q1, Q2, Q3 and records are like...

Code Q1 Q2 Q3
1 Good Good Average
2 Poor Average Average
3 Good Excellent Average
4 Excellent Good Good
etc.....

I need to write a single query, which will give result look like.

Excellent Good Average Poor
Q1 1 2 0 1
Q2 1 2 1 0
Q3 0 1 3 0

Actually, this table is used to get the feedback from the users. User has given their feedback by selecting options. I need the details that how many persons answered Excellent for Question1 (Q1), Question2 (Q2), etc...As well as How many answered Good for Q1,Q2,Q3, etc....I need this format. Please help me.

Balasubramanian K.

AnswerRe: How to write query Pin
TheFM23414-Jul-08 6:53
TheFM23414-Jul-08 6:53 
GeneralRe: How to write query Pin
BalasubramanianK14-Jul-08 18:17
BalasubramanianK14-Jul-08 18:17 
QuestionDelete Query Pin
sjs4u14-Jul-08 0:10
sjs4u14-Jul-08 0:10 
AnswerRe: Delete Query Pin
subai14-Jul-08 0:29
subai14-Jul-08 0:29 
AnswerRe: Delete Query Pin
Declan Bright14-Jul-08 1:19
Declan Bright14-Jul-08 1:19 
AnswerRe: Delete Query Pin
TheFM23414-Jul-08 7:20
TheFM23414-Jul-08 7:20 
QuestionAccessing multiple result sets from a stored procedure Pin
Rashmi Deshpande13-Jul-08 23:56
Rashmi Deshpande13-Jul-08 23:56 
AnswerRe: Accessing multiple result sets from a stored procedure Pin
Declan Bright14-Jul-08 1:26
Declan Bright14-Jul-08 1:26 
QuestionError message in Stored procedure Pin
IamAmit13-Jul-08 23:21
IamAmit13-Jul-08 23:21 
AnswerRe: Error message in Stored procedure Pin
leoinfo14-Jul-08 2:54
leoinfo14-Jul-08 2:54 
AnswerRe: Error message in Stored procedure Pin
TheFM23414-Jul-08 6:31
TheFM23414-Jul-08 6:31 
QuestionAutomate database backup ? Pin
rajg8213-Jul-08 22:03
rajg8213-Jul-08 22:03 
AnswerRe: Automate database backup ? Pin
Syed Mehroz Alam14-Jul-08 0:51
Syed Mehroz Alam14-Jul-08 0:51 
AnswerRe: Automate database backup ? Pin
leoinfo14-Jul-08 3:10
leoinfo14-Jul-08 3:10 
QuestionSQL SERVER DATABASE Pin
Anubhava Dimri13-Jul-08 21:54
Anubhava Dimri13-Jul-08 21:54 
AnswerRe: SQL SERVER DATABASE [modified] Pin
Syed Mehroz Alam14-Jul-08 0:42
Syed Mehroz Alam14-Jul-08 0:42 
Questiongeneralized statements for update delete insert Pin
santosh04213-Jul-08 21:37
santosh04213-Jul-08 21:37 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.