Click here to Skip to main content
15,860,844 members
Home / Discussions / Database
   

Database

 
QuestionCannot create a foreign key reference (probably my fault) Pin
Richard MacCutchan31-Jul-14 0:38
mveRichard MacCutchan31-Jul-14 0:38 
AnswerRe: Cannot create a foreign key reference (probably my fault) Pin
Simon_Whale31-Jul-14 1:27
Simon_Whale31-Jul-14 1:27 
GeneralRe: Cannot create a foreign key reference (probably my fault) Pin
Richard MacCutchan31-Jul-14 1:36
mveRichard MacCutchan31-Jul-14 1:36 
AnswerRe: Cannot create a foreign key reference (probably my fault) Pin
Eddy Vluggen31-Jul-14 1:28
professionalEddy Vluggen31-Jul-14 1:28 
GeneralRe: Cannot create a foreign key reference (probably my fault) Pin
Richard MacCutchan31-Jul-14 1:39
mveRichard MacCutchan31-Jul-14 1:39 
GeneralRe: Cannot create a foreign key reference (probably my fault) Pin
Eddy Vluggen31-Jul-14 11:08
professionalEddy Vluggen31-Jul-14 11:08 
QuestionInsert into temptable ( #tmp1 ) that execute result from 1 procedure ( return 2 results ) Pin
LTMKH30-Jul-14 22:30
LTMKH30-Jul-14 22:30 
AnswerRe: Insert into temptable ( #tmp1 ) that execute result from 1 procedure ( return 2 results ) Pin
Mycroft Holmes30-Jul-14 22:51
professionalMycroft Holmes30-Jul-14 22:51 
You have a some of choices, the obvious one is to split the child procedure into 2 procs, this is by far the better choice.

You could also use a global temp table in the child procs declare as ##TableName. IE create the global temp in the parent proc and call the insert proc, then consume the results in the parent proc. I would consider this a really crappy solution as it is fraught with problems.

You could also modify the child proc to use a UNION and return only 1 table (assumes if you are going to insert the data into 1 table then it is the same structure)

MS did a great disservice when they allowed multiple result sets to be returned from a single proc.
Never underestimate the power of human stupidity
RAH

GeneralRe: Insert into temptable ( #tmp1 ) that execute result from 1 procedure ( return 2 results ) Pin
LTMKH31-Jul-14 15:53
LTMKH31-Jul-14 15:53 
GeneralRe: Insert into temptable ( #tmp1 ) that execute result from 1 procedure ( return 2 results ) Pin
Mycroft Holmes31-Jul-14 16:15
professionalMycroft Holmes31-Jul-14 16:15 
QuestionHow to Calculate Total Time Difference Pin
Robymon28-Jul-14 3:06
Robymon28-Jul-14 3:06 
AnswerRe: How to Calculate Total Time Difference Pin
Corporal Agarn28-Jul-14 3:26
professionalCorporal Agarn28-Jul-14 3:26 
GeneralRe: How to Calculate Total Time Difference Pin
Robymon28-Jul-14 3:36
Robymon28-Jul-14 3:36 
GeneralRe: How to Calculate Total Time Difference Pin
Corporal Agarn28-Jul-14 3:39
professionalCorporal Agarn28-Jul-14 3:39 
AnswerRe: How to Calculate Total Time Difference Pin
David Mujica28-Jul-14 3:28
David Mujica28-Jul-14 3:28 
AnswerRe: How to Calculate Total Time Difference Pin
Andrius Leonavicius28-Jul-14 11:32
professionalAndrius Leonavicius28-Jul-14 11:32 
GeneralRe: How to Calculate Total Time Difference Pin
Mycroft Holmes29-Jul-14 13:05
professionalMycroft Holmes29-Jul-14 13:05 
GeneralRe: How to Calculate Total Time Difference Pin
Andrius Leonavicius29-Jul-14 14:03
professionalAndrius Leonavicius29-Jul-14 14:03 
GeneralRe: How to Calculate Total Time Difference Pin
Mycroft Holmes29-Jul-14 14:25
professionalMycroft Holmes29-Jul-14 14:25 
GeneralRe: How to Calculate Total Time Difference Pin
Andrius Leonavicius29-Jul-14 14:39
professionalAndrius Leonavicius29-Jul-14 14:39 
AnswerRe: How to Calculate Total Time Difference Pin
Mycroft Holmes29-Jul-14 14:29
professionalMycroft Holmes29-Jul-14 14:29 
AnswerRe: How to Calculate Total Time Difference Pin
Swinkaran4-Aug-14 16:28
professionalSwinkaran4-Aug-14 16:28 
QuestionSQL SERVER DBA--- HELP ME WITH THIS.... Pin
Member 1097517927-Jul-14 20:57
Member 1097517927-Jul-14 20:57 
AnswerRe: SQL SERVER DBA--- HELP ME WITH THIS.... Pin
Tim Carmichael28-Jul-14 2:58
Tim Carmichael28-Jul-14 2:58 
AnswerRe: SQL SERVER DBA--- HELP ME WITH THIS.... Pin
Mycroft Holmes29-Jul-14 14:33
professionalMycroft Holmes29-Jul-14 14:33 

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.