Click here to Skip to main content
15,861,168 members
Home / Discussions / Database
   

Database

 
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 
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 
CHill60 wrote:
You might get a better response with some sample data and expected results
My comment still stands.
Indian143 wrote:
when removed the FOR XML PATH from the query it is giving error
Are you are expecting us to guess what that error might be?

There are plenty of people who would like to help you solve your problem, but you're not giving us much to go on. We do this in our spare time so expecting us to wade through the SQL to try and create some tables to match it so we can see what is being produced so we can work out how to replace the FOR XML and get appropriate results ... would take more time than most of us have available.

See Some guidelines for posting questions in the forums[^]
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 
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 

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.