Click here to Skip to main content
15,922,427 members
Home / Discussions / Database
   

Database

 
AnswerRe: Access SSRS reports from outside network Pin
Simon_Whale11-May-17 5:19
Simon_Whale11-May-17 5:19 
AnswerRe: Access SSRS reports from outside network Pin
Member 1491271312-Aug-20 1:40
Member 1491271312-Aug-20 1:40 
QuestionHow to read & write data in queue in sql server Pin
Tridip Bhattacharjee3-May-17 22:51
professionalTridip Bhattacharjee3-May-17 22:51 
AnswerRe: How to read & write data in queue in sql server Pin
Victor Nijegorodov4-May-17 0:47
Victor Nijegorodov4-May-17 0:47 
GeneralRe: How to read & write data in queue in sql server Pin
CHill604-May-17 2:42
mveCHill604-May-17 2:42 
QuestionProblem with installing oracle database Pin
VISWESWARAN19982-May-17 0:13
professionalVISWESWARAN19982-May-17 0:13 
AnswerRe: Problem with installing oracle database Pin
Victor Nijegorodov2-May-17 7:23
Victor Nijegorodov2-May-17 7:23 
GeneralRe: Problem with installing oracle database Pin
VISWESWARAN19982-May-17 20:14
professionalVISWESWARAN19982-May-17 20:14 
AnswerRe: Problem with installing oracle database Pin
John C Rayan4-May-17 0:58
professionalJohn C Rayan4-May-17 0:58 
GeneralRe: Problem with installing oracle database Pin
VISWESWARAN19984-May-17 6:31
professionalVISWESWARAN19984-May-17 6:31 
AnswerRe: Problem with installing oracle database Pin
John C Rayan4-May-17 1:00
professionalJohn C Rayan4-May-17 1:00 
QuestionProblem creating new username in sql language Pin
Member 1316151629-Apr-17 11:08
Member 1316151629-Apr-17 11:08 
AnswerRe: Problem creating new username in sql language Pin
Mycroft Holmes29-Apr-17 14:50
professionalMycroft Holmes29-Apr-17 14:50 
QuestionRe: Problem creating new username in sql language Pin
ZurdoDev2-May-17 10:14
professionalZurdoDev2-May-17 10:14 
AnswerRe: Problem creating new username in sql language Pin
Victor Nijegorodov2-May-17 11:23
Victor Nijegorodov2-May-17 11:23 
Questionhow to get metadata of table from database in php? Pin
Member 1314302421-Apr-17 1:37
Member 1314302421-Apr-17 1:37 
AnswerRe: how to get metadata of table from database in php? Pin
Afzaal Ahmad Zeeshan21-Apr-17 2:22
professionalAfzaal Ahmad Zeeshan21-Apr-17 2:22 
AnswerRe: how to get metadata of table from database in php? Pin
Eddy Vluggen21-Apr-17 3:52
professionalEddy Vluggen21-Apr-17 3:52 
QuestionWant to avoid Dynamic Sql even if the Table name is random Pin
indian14317-Apr-17 8:40
indian14317-Apr-17 8:40 
AnswerRe: Want to avoid Dynamic Sql even if the Table name is random Pin
Wendelius17-Apr-17 8:53
mentorWendelius17-Apr-17 8:53 
GeneralRe: Want to avoid Dynamic Sql even if the Table name is random Pin
indian14317-Apr-17 9:46
indian14317-Apr-17 9:46 
GeneralRe: Want to avoid Dynamic Sql even if the Table name is random Pin
indian14317-Apr-17 10:04
indian14317-Apr-17 10:04 
QuestionRe: Want to avoid Dynamic Sql even if the Table name is random Pin
CHill6018-Apr-17 4:19
mveCHill6018-Apr-17 4:19 
GeneralRe: Want to avoid Dynamic Sql even if the Table name is random Pin
Mycroft Holmes18-Apr-17 14:33
professionalMycroft Holmes18-Apr-17 14:33 
Chilli is right, dynamic sql is unlikely to be your problem, query design is almost certainly the cause of slow processing.

You need to create a temp table that hold all the field from the various sources and feed the records into that table to make the structure the same.
Never underestimate the power of human stupidity
RAH

GeneralRe: Want to avoid Dynamic Sql even if the Table name is random Pin
indian14320-Apr-17 12:58
indian14320-Apr-17 12: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.