Click here to Skip to main content
15,503,456 members
Home / Discussions / Database
   

Database

 
AnswerRe: SQL report to get average amount of time for helpdesk closures Pin
Wendelius19-Oct-14 1:35
mveWendelius19-Oct-14 1:35 
GeneralRe: SQL report to get average amount of time for helpdesk closures Pin
Danpeking9-Nov-14 23:27
Danpeking9-Nov-14 23:27 
GeneralRe: SQL report to get average amount of time for helpdesk closures Pin
Wendelius10-Nov-14 9:33
mveWendelius10-Nov-14 9:33 
QuestionRoadmap to learn SSIS Pin
arunUB16-Oct-14 16:47
arunUB16-Oct-14 16:47 
AnswerRe: Roadmap to learn SSIS Pin
Peter Leow16-Oct-14 17:05
professionalPeter Leow16-Oct-14 17:05 
AnswerRe: Roadmap to learn SSIS Pin
Shweta N Mishra20-Oct-14 3:31
professionalShweta N Mishra20-Oct-14 3:31 
QuestionCreate 2 sets of results using old school foxpro or dbase III dbf files Pin
jkirkerx16-Oct-14 11:49
professionaljkirkerx16-Oct-14 11:49 
AnswerRe: Create 2 sets of results using old school foxpro or dbase III dbf files Pin
David Mujica17-Oct-14 3:54
David Mujica17-Oct-14 3:54 
I think you are on the right track.

Create 2 queries but use a union statement which will combine the result sets into one.
Good luck. Thumbs Up | :thumbsup:
Questiongood book to clear the concept of Sql,Dynamic Procedures and User defined Functions Pin
johnpol1215-Oct-14 1:04
johnpol1215-Oct-14 1:04 
AnswerRe: good book to clear the concept of Sql,Dynamic Procedures and User defined Functions Pin
ZurdoDev15-Oct-14 6:45
professionalZurdoDev15-Oct-14 6:45 
QuestionConvert row to columns in SQL View or Procedure Pin
Member 1115418814-Oct-14 20:52
Member 1115418814-Oct-14 20:52 
AnswerRe: Convert row to columns in SQL View or Procedure Pin
Mycroft Holmes14-Oct-14 22:09
professionalMycroft Holmes14-Oct-14 22: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 10:14
professionaljkirkerx14-Oct-14 10: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 10:23
professionalKornfeld Eliyahu Peter14-Oct-14 10: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 10:33
professionaljkirkerx14-Oct-14 10: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 10:38
professionalKornfeld Eliyahu Peter14-Oct-14 10: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 10:53
professionaljkirkerx14-Oct-14 10:53 
QuestionString or binary data would be truncated. Pin
vJay Yadav6-Oct-14 23:33
professionalvJay Yadav6-Oct-14 23:33 
AnswerRe: String or binary data would be truncated. Pin
Mycroft Holmes7-Oct-14 0:09
professionalMycroft Holmes7-Oct-14 0:09 
GeneralRe: String or binary data would be truncated. Pin
vJay Yadav7-Oct-14 3:28
professionalvJay Yadav7-Oct-14 3:28 
AnswerRe: String or binary data would be truncated. Pin
Richard Deeming7-Oct-14 2:39
mveRichard Deeming7-Oct-14 2:39 
GeneralRe: String or binary data would be truncated. Pin
vJay Yadav7-Oct-14 3:28
professionalvJay Yadav7-Oct-14 3:28 
AnswerSQL Server 2008 R2 log growth question - solved! Pin
GuyThiebaut4-Oct-14 9:28
professionalGuyThiebaut4-Oct-14 9:28 
SuggestionRe: SQL Server 2008 R2 log growth question Pin
Richard Deeming6-Oct-14 2:51
mveRichard Deeming6-Oct-14 2:51 
GeneralRe: SQL Server 2008 R2 log growth question Pin
GuyThiebaut6-Oct-14 2:58
professionalGuyThiebaut6-Oct-14 2:58 

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.