Click here to Skip to main content
15,905,068 members
Home / Discussions / Database
   

Database

 
QuestionRoadmap to learn SSIS Pin
arunUB16-Oct-14 15:47
arunUB16-Oct-14 15:47 
AnswerRe: Roadmap to learn SSIS Pin
Peter Leow16-Oct-14 16:05
professionalPeter Leow16-Oct-14 16:05 
AnswerRe: Roadmap to learn SSIS Pin
Shweta N Mishra20-Oct-14 2:31
professionalShweta N Mishra20-Oct-14 2:31 
QuestionCreate 2 sets of results using old school foxpro or dbase III dbf files Pin
jkirkerx16-Oct-14 10:49
professionaljkirkerx16-Oct-14 10:49 
AnswerRe: Create 2 sets of results using old school foxpro or dbase III dbf files Pin
David Mujica17-Oct-14 2:54
David Mujica17-Oct-14 2:54 
Questiongood book to clear the concept of Sql,Dynamic Procedures and User defined Functions Pin
johnpol1215-Oct-14 0:04
johnpol1215-Oct-14 0:04 
AnswerRe: good book to clear the concept of Sql,Dynamic Procedures and User defined Functions Pin
ZurdoDev15-Oct-14 5:45
professionalZurdoDev15-Oct-14 5:45 
QuestionConvert row to columns in SQL View or Procedure Pin
Member 1115418814-Oct-14 19:52
Member 1115418814-Oct-14 19:52 
I have table looks like below.

EMPID	QID	QDesc	         Reason	Sub Reason	Remarks
201	1	Question 1	Reason1	Break	Taking break
201	2	Question 2	Reason2	Poor	
201	2	Question 2	Reason3	Good	
201	2	Question 2	Reason4	Average	
201	2	Question 2	Reason5	Good	
201	2	Question 2	Reason6	Average	
201	2	Question 2	Reason7	Average	
201	2	Question 2	Reason8	Average	
201	3	Question 3			NA
201	4	Question 4	Reason9		
201	5	Question 5	Reason10		Yes



Required Output from the above table should be in the below format. Please help.

Emp ID	Question 1 		     Question 2			Question 3  Question 4	Question 5   Remarks
      Reason  Sub reason  Remarks   Reason2  Reason3  to Reason8				


modified 15-Oct-14 2:25am.

AnswerRe: Convert row to columns in SQL View or Procedure Pin
Mycroft Holmes14-Oct-14 21:09
professionalMycroft Holmes14-Oct-14 21:09 
QuestionJoin a 3rd table, in which multiple records with the same id exist, but I just need 1 of them Pin
jkirkerx14-Oct-14 9:14
professionaljkirkerx14-Oct-14 9:14 
GeneralRe: Join a 3rd table, in which multiple records with the same id exist, but I just need 1 of them Pin
Kornfeld Eliyahu Peter14-Oct-14 9:23
professionalKornfeld Eliyahu Peter14-Oct-14 9:23 
GeneralRe: Join a 3rd table, in which multiple records with the same id exist, but I just need 1 of them Pin
jkirkerx14-Oct-14 9:33
professionaljkirkerx14-Oct-14 9:33 
AnswerRe: Join a 3rd table, in which multiple records with the same id exist, but I just need 1 of them Pin
Kornfeld Eliyahu Peter14-Oct-14 9:38
professionalKornfeld Eliyahu Peter14-Oct-14 9:38 
GeneralRe: Join a 3rd table, in which multiple records with the same id exist, but I just need 1 of them Pin
jkirkerx14-Oct-14 9:53
professionaljkirkerx14-Oct-14 9:53 
QuestionString or binary data would be truncated. Pin
vJay Yadav6-Oct-14 22:33
professionalvJay Yadav6-Oct-14 22:33 
AnswerRe: String or binary data would be truncated. Pin
Mycroft Holmes6-Oct-14 23:09
professionalMycroft Holmes6-Oct-14 23:09 
GeneralRe: String or binary data would be truncated. Pin
vJay Yadav7-Oct-14 2:28
professionalvJay Yadav7-Oct-14 2:28 
AnswerRe: String or binary data would be truncated. Pin
Richard Deeming7-Oct-14 1:39
mveRichard Deeming7-Oct-14 1:39 
GeneralRe: String or binary data would be truncated. Pin
vJay Yadav7-Oct-14 2:28
professionalvJay Yadav7-Oct-14 2:28 
AnswerMessage Closed Pin
6-Oct-14 6:45
askbbrewer6-Oct-14 6:45 
AnswerSQL Server 2008 R2 log growth question - solved! Pin
GuyThiebaut4-Oct-14 8:28
professionalGuyThiebaut4-Oct-14 8:28 
SuggestionRe: SQL Server 2008 R2 log growth question Pin
Richard Deeming6-Oct-14 1:51
mveRichard Deeming6-Oct-14 1:51 
GeneralRe: SQL Server 2008 R2 log growth question Pin
GuyThiebaut6-Oct-14 1:58
professionalGuyThiebaut6-Oct-14 1:58 
QuestionMax throughput Microsoft SQL Server? Pin
devvvy2-Oct-14 13:05
devvvy2-Oct-14 13:05 
GeneralRe: Max throughput Microsoft SQL Server? Pin
PIEBALDconsult2-Oct-14 13:36
mvePIEBALDconsult2-Oct-14 13:36 

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.