Click here to Skip to main content
15,879,474 members
Home / Discussions / Database
   

Database

 
GeneralRe: Latest Oracle Connection method Pin
Jörgen Andersson16-May-18 0:37
professionalJörgen Andersson16-May-18 0:37 
QuestionSQL 2016 Optimization ... Pin
Member 138060854-May-18 1:10
Member 138060854-May-18 1:10 
RantRe: SQL 2016 Optimization ... Pin
CHill604-May-18 1:13
mveCHill604-May-18 1:13 
AnswerRe: SQL 2016 Optimization ... Pin
Eddy Vluggen5-May-18 1:14
professionalEddy Vluggen5-May-18 1:14 
QuestionSQL 2016 Optimization ... Pin
Member 138060854-May-18 1:10
Member 138060854-May-18 1:10 
QuestionHow to stop execution of other tasks in SSIS if a script task gets Dts.TaskResult = (int)ScriptResults.Failure; Pin
indian1432-May-18 14:12
indian1432-May-18 14:12 
AnswerSelf answered just if somebody has similar problem it would be helpful. How to stop execution of other tasks in SSIS if a script task gets Dts.TaskResult = (int)ScriptResults.Failure; Pin
indian1433-May-18 8:41
indian1433-May-18 8:41 
QuestionInsert dynamic SQL Values into Temp Table Pin
indian14326-Apr-18 7:03
indian14326-Apr-18 7:03 
Hi,

I need to insert Dynamic SQL Values into Temp table, but I am able to insert values into Global Temp table but I don't know how to insert Global Temp table values into Temp table back again. Any help would be greatly helpful. Any sort of implementation to insert Dynamic SQL values into Temp table is fine, directly or indirectly is fine.

Here is how I am able to insert the Dynamic SQL Values into Global temp table, but not able to do the same for the Temp table, even if I can insert from Global Temp table to Temp table is also fine. Any help would be greatly helpful - thanks in advance buddies.
DECLARE @sqlCommand varchar(max) = 'SELECT TABLE_NAME INTO ##TableNames FROM INFORMATION_SCHEMA.TABLES where TABLE_SCHEMA='''+ @schema + ''''

    EXEC (@sqlCommand)
    EXEC ('SELECT * FROM [##TableNames] ')

Thanks,

Abdul Aleem

"There is already enough hatred in the world lets spread love, compassion and affection."
AnswerRe: Insert dynamic SQL Values into Temp Table Pin
Richard Deeming26-Apr-18 8:00
mveRichard Deeming26-Apr-18 8:00 
GeneralRe: Insert dynamic SQL Values into Temp Table Pin
indian14326-Apr-18 10:09
indian14326-Apr-18 10:09 
Questionmysql query Pin
Member 1360728325-Apr-18 16:47
Member 1360728325-Apr-18 16:47 
AnswerRe: mysql query Pin
Jörgen Andersson25-Apr-18 21:48
professionalJörgen Andersson25-Apr-18 21:48 
GeneralRe: mysql query Pin
Member 1360728326-Apr-18 10:56
Member 1360728326-Apr-18 10:56 
GeneralRe: mysql query Pin
Jörgen Andersson26-Apr-18 21:22
professionalJörgen Andersson26-Apr-18 21:22 
QuestionShipping tracking Link output to google search from MYSQL Database Pin
bfg9000d36025-Apr-18 4:51
bfg9000d36025-Apr-18 4:51 
AnswerRe: Shipping tracking Link output to google search from MYSQL Database Pin
Eddy Vluggen25-Apr-18 5:37
professionalEddy Vluggen25-Apr-18 5:37 
GeneralRe: Shipping tracking Link output to google search from MYSQL Database Pin
bfg9000d36025-Apr-18 7:19
bfg9000d36025-Apr-18 7:19 
GeneralRe: Shipping tracking Link output to google search from MYSQL Database Pin
Eddy Vluggen25-Apr-18 8:19
professionalEddy Vluggen25-Apr-18 8:19 
GeneralRe: Shipping tracking Link output to google search from MYSQL Database Pin
bfg9000d36025-Apr-18 8:31
bfg9000d36025-Apr-18 8:31 
GeneralRe: Shipping tracking Link output to google search from MYSQL Database Pin
Eddy Vluggen25-Apr-18 8:38
professionalEddy Vluggen25-Apr-18 8:38 
GeneralRe: Shipping tracking Link output to google search from MYSQL Database Pin
Richard Deeming25-Apr-18 9:46
mveRichard Deeming25-Apr-18 9:46 
GeneralRe: Shipping tracking Link output to google search from MYSQL Database Pin
bfg9000d36025-Apr-18 9:50
bfg9000d36025-Apr-18 9:50 
GeneralRe: Shipping tracking Link output to google search from MYSQL Database Pin
Richard Deeming25-Apr-18 10:08
mveRichard Deeming25-Apr-18 10:08 
GeneralRe: Shipping tracking Link output to google search from MYSQL Database Pin
bfg9000d36025-Apr-18 10:12
bfg9000d36025-Apr-18 10:12 
GeneralRe: Shipping tracking Link output to google search from MYSQL Database Pin
Richard Deeming25-Apr-18 10:16
mveRichard Deeming25-Apr-18 10:16 

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.