Click here to Skip to main content
15,170,078 members
Home / Discussions / Database
   

Database

 
AnswerRe: Arithmetic rounding Pin
Andrius Leonavicius9-May-14 16:02
professionalAndrius Leonavicius9-May-14 16:02 
GeneralRe: Arithmetic rounding Pin
Richard.Berry1009-May-14 21:45
MemberRichard.Berry1009-May-14 21:45 
GeneralRe: Arithmetic rounding Pin
Andrius Leonavicius10-May-14 5:28
professionalAndrius Leonavicius10-May-14 5:28 
QuestionFetch records efficiently Pin
avi_dadi20029-May-14 10:15
Memberavi_dadi20029-May-14 10:15 
AnswerRe: Fetch records efficiently Pin
Richard Andrew x649-May-14 11:30
professionalRichard Andrew x649-May-14 11:30 
AnswerRe: Fetch records efficiently Pin
Richard MacCutchan9-May-14 22:49
mveRichard MacCutchan9-May-14 22:49 
QuestionNeed to fetch from two data sources Pin
avi_dadi20029-May-14 10:11
Memberavi_dadi20029-May-14 10:11 
AnswerRe: Need to fetch from two data sources Pin
Richard.Berry1009-May-14 22:40
MemberRichard.Berry1009-May-14 22:40 
Sorry - never read your question properly... (Not sure about DB2)
but in any case...

Perhaps UNION ALL is what you are looking for.
(Columns in both selects must be the same)

select p, q, r
from XXX5T.MyDB5T.MyTable

UNION ALL

select p, q, r
from XXX5T.MyDB5P.MyTable

also see Linked Servers http://msdn.microsoft.com/en-us/library/ms188279.aspx[^]

modified 10-May-14 4:08am.

QuestionSSAS Cube Pin
Mycroft Holmes6-May-14 15:42
professionalMycroft Holmes6-May-14 15:42 
QuestionNeed help in forming a query Pin
Member 99559846-May-14 1:07
professionalMember 99559846-May-14 1:07 
AnswerRe: Need help in forming a query Pin
Richard MacCutchan6-May-14 1:21
mveRichard MacCutchan6-May-14 1:21 
Questionlogin and logout differenece at back end Pin
Syed Rehman5-May-14 19:59
MemberSyed Rehman5-May-14 19:59 
AnswerRe: login and logout differenece at back end Pin
Mycroft Holmes5-May-14 20:20
professionalMycroft Holmes5-May-14 20:20 
QuestionMigration error from SQL 2014 to SQL 2012 Pin
Kala Vairakkannu5-May-14 8:48
MemberKala Vairakkannu5-May-14 8:48 
AnswerRe: Migration error from SQL 2014 to SQL 2012 Pin
ZurdoDev5-May-14 10:36
professionalZurdoDev5-May-14 10:36 
QuestionMigration error from SQL 2014 to SQL 2012 Pin
Kala Vairakkannu5-May-14 8:27
MemberKala Vairakkannu5-May-14 8:27 
AnswerRe: Migration error from SQL 2014 to SQL 2012 Pin
Kornfeld Eliyahu Peter5-May-14 8:34
professionalKornfeld Eliyahu Peter5-May-14 8:34 
GeneralRe: Migration error from SQL 2014 to SQL 2012 Pin
ZurdoDev5-May-14 8:48
professionalZurdoDev5-May-14 8:48 
GeneralRe: Migration error from SQL 2014 to SQL 2012 Pin
Kala Vairakkannu5-May-14 9:16
MemberKala Vairakkannu5-May-14 9:16 
AnswerRe: Migration error from SQL 2014 to SQL 2012 Pin
LloydA1115-May-14 8:34
MemberLloydA1115-May-14 8:34 
GeneralRe: Migration error from SQL 2014 to SQL 2012 Pin
ZurdoDev5-May-14 8:47
professionalZurdoDev5-May-14 8:47 
GeneralRe: Migration error from SQL 2014 to SQL 2012 Pin
Kala Vairakkannu5-May-14 9:20
MemberKala Vairakkannu5-May-14 9:20 
GeneralRe: Migration error from SQL 2014 to SQL 2012 Pin
Kornfeld Eliyahu Peter5-May-14 9:24
professionalKornfeld Eliyahu Peter5-May-14 9:24 
GeneralRe: Migration error from SQL 2014 to SQL 2012 Pin
Kala Vairakkannu5-May-14 9:37
MemberKala Vairakkannu5-May-14 9:37 
QuestionMySQL: best for true or false, Yes or No, negative or positive Pin
Jassim Rahma3-May-14 5:44
MemberJassim Rahma3-May-14 5:44 

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.