Click here to Skip to main content
15,348,004 members
Home / Discussions / Database
   

Database

 
AnswerRe: Multiple Queries in one Stored procedure Pin
Wendelius18-Feb-15 4:37
mveWendelius18-Feb-15 4:37 
GeneralRe: Multiple Queries in one Stored procedure Pin
sudevsu18-Feb-15 5:11
Membersudevsu18-Feb-15 5:11 
GeneralRe: Multiple Queries in one Stored procedure Pin
Wendelius18-Feb-15 6:41
mveWendelius18-Feb-15 6:41 
SuggestionRe: Multiple Queries in one Stored procedure Pin
Richard Deeming18-Feb-15 5:43
mveRichard Deeming18-Feb-15 5:43 
GeneralRe: Multiple Queries in one Stored procedure Pin
sudevsu18-Feb-15 6:21
Membersudevsu18-Feb-15 6:21 
GeneralRe: Multiple Queries in one Stored procedure Pin
Wendelius18-Feb-15 6:42
mveWendelius18-Feb-15 6:42 
AnswerRe: Multiple Queries in one Stored procedure Pin
Smart00324-Feb-15 23:18
professionalSmart00324-Feb-15 23:18 
AnswerRe: Multiple Queries in one Stored procedure Pin
Abdulnazark9-Mar-15 7:08
MemberAbdulnazark9-Mar-15 7:08 
add one column of to identify the table name like

Select 'T1' as tbl, T1CL1 as col1,T1CL2 as col2 from T1 where T1CL3 = 'Something'
union all
Select 'T2', T2CL1,T2CL3 from T2 where T1CL2 = 'prm1'
union all
Select 'T3', T3CL3,T3CL4 from T3 where T3CL2 = 'prm2'
union all
Select 'T4',T4CL1,T4CL3 from T4 where T4CL2 = 'prm3'
union all
Select 'T5',T5CL1,T5CL3 from T5 where T1CL2 = 'prm4'
AnswerRe: Multiple Queries in one Stored procedure Pin
deepankarbhatnagar11-Mar-15 0:02
professionaldeepankarbhatnagar11-Mar-15 0:02 
QuestionMYSQL SUM SEVERAL COLUMN VALUES Pin
KipkoechE17-Feb-15 10:29
MemberKipkoechE17-Feb-15 10:29 
AnswerRe: MYSQL SUM SEVERAL COLUMN VALUES Pin
Richard Andrew x6417-Feb-15 11:13
professionalRichard Andrew x6417-Feb-15 11:13 
GeneralRe: MYSQL SUM SEVERAL COLUMN VALUES Pin
KipkoechE17-Feb-15 17:47
MemberKipkoechE17-Feb-15 17:47 
AnswerRe: MYSQL SUM SEVERAL COLUMN VALUES Pin
Richard Andrew x6418-Feb-15 4:58
professionalRichard Andrew x6418-Feb-15 4:58 
GeneralRe: MYSQL SUM SEVERAL COLUMN VALUES Pin
KipkoechE18-Feb-15 11:30
MemberKipkoechE18-Feb-15 11:30 
GeneralRe: MYSQL SUM SEVERAL COLUMN VALUES Pin
Richard Andrew x6419-Feb-15 4:55
professionalRichard Andrew x6419-Feb-15 4:55 
GeneralRe: MYSQL SUM SEVERAL COLUMN VALUES Pin
KipkoechE19-Feb-15 19:45
MemberKipkoechE19-Feb-15 19:45 
QuestionSQL server 12: Displaying column cell values in single cell Pin
Swap917-Feb-15 2:35
MemberSwap917-Feb-15 2:35 
SuggestionRe: SQL server 12: Displaying column cell values in single cell Pin
ZurdoDev17-Feb-15 2:54
professionalZurdoDev17-Feb-15 2:54 
GeneralRe: SQL server 12: Displaying column cell values in single cell Pin
Swap917-Feb-15 2:58
MemberSwap917-Feb-15 2:58 
GeneralRe: SQL server 12: Displaying column cell values in single cell Pin
ZurdoDev17-Feb-15 3:00
professionalZurdoDev17-Feb-15 3:00 
GeneralRe: SQL server 12: Displaying column cell values in single cell Pin
Swap917-Feb-15 3:15
MemberSwap917-Feb-15 3:15 
AnswerRe: SQL server 12: Displaying column cell values in single cell Pin
ZurdoDev17-Feb-15 3:24
professionalZurdoDev17-Feb-15 3:24 
GeneralRe: SQL server 12: Displaying column cell values in single cell Pin
Swap917-Feb-15 3:40
MemberSwap917-Feb-15 3:40 
QuestionRe: SQL server 12: Displaying column cell values in single cell Pin
Eddy Vluggen17-Feb-15 4:38
professionalEddy Vluggen17-Feb-15 4:38 
AnswerRe: SQL server 12: Displaying column cell values in single cell Pin
Richard Deeming17-Feb-15 4:01
mveRichard Deeming17-Feb-15 4:01 

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.