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

Database

 
AnswerRe: How to create a insert trigger on just one table? Pin
Richard Deeming22-May-18 2:30
mveRichard Deeming22-May-18 2:30 
AnswerRe: How to create a insert trigger on just one table? Pin
Mycroft Holmes22-May-18 14:09
professionalMycroft Holmes22-May-18 14:09 
GeneralRe: How to create a insert trigger on just one table? Pin
CHill6022-May-18 22:56
mveCHill6022-May-18 22:56 
GeneralRe: How to create a insert trigger on just one table? Pin
Mycroft Holmes23-May-18 13:20
professionalMycroft Holmes23-May-18 13:20 
GeneralRe: How to create a insert trigger on just one table? Pin
Member23622-May-18 23:04
Member23622-May-18 23:04 
GeneralRe: How to create a insert trigger on just one table? Pin
Mycroft Holmes23-May-18 13:23
professionalMycroft Holmes23-May-18 13:23 
QuestionFOR XML PATH is not creating Child elements if they are coming with null values Pin
indian14316-May-18 12:39
indian14316-May-18 12:39 
AnswerRe: FOR XML PATH is not creating Child elements if they are coming with null values Pin
CHill6022-May-18 1:32
mveCHill6022-May-18 1:32 
Last tuesday I made a suggestion to you that would probably help you get assistance.
CHill60 wrote:
You might get a better response with some sample data and expected results
You've given us the outputs but still haven't provided any sample data ... on the tables (or views) vw_ServicesXML5010, vq_ServiceFacilityXML5010, vw_OwnerXML5010 or dbo.vw_SDMCPhaseTwoParentLevelXML

You have said that you don't understand how the two scripts are different, yet one of them is reading from vw_OwnerXML5010 but the other is reading from dbo.vw_SDMCPhaseTwoParentLevelXML having been given an alias of vw_OwnerXML5010. I suggest you start by comparing the output of the following sql commands
SQL
SELECT * FROM vb_OwnerXML5010
and
SQL
SELECT * FROM dbo.vw_SDMCPhaseTwoParentLevelXML
introducing an appropriate WHERE clause to both.

We can't help you any further without sample data.
QuestionEquivalent of the following query without FOR XML PATH Pin
indian14314-May-18 12:03
indian14314-May-18 12:03 
SuggestionRe: Equivalent of the following query without FOR XML PATH Pin
CHill6015-May-18 0:11
mveCHill6015-May-18 0:11 
GeneralRe: Equivalent of the following query without FOR XML PATH Pin
indian14315-May-18 6:39
indian14315-May-18 6:39 
GeneralRe: Equivalent of the following query without FOR XML PATH Pin
CHill6015-May-18 22:11
mveCHill6015-May-18 22:11 
GeneralRe: Equivalent of the following query without FOR XML PATH Pin
indian14317-May-18 14:56
indian14317-May-18 14:56 
RantLatest Oracle Connection method Pin
Mycroft Holmes6-May-18 14:56
professionalMycroft Holmes6-May-18 14:56 
GeneralRe: Latest Oracle Connection method Pin
Jörgen Andersson16-May-18 0:20
professionalJörgen Andersson16-May-18 0:20 
GeneralRe: Latest Oracle Connection method Pin
Mycroft Holmes16-May-18 0:27
professionalMycroft Holmes16-May-18 0:27 
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 
AnswerRe: Insert dynamic SQL Values into Temp Table Pin
Richard Deeming26-Apr-18 8:00
mveRichard Deeming26-Apr-18 8:00 

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.