Click here to Skip to main content
14,448,118 members
   

Database

 
GeneralRe: How to create a insert trigger on just one table? Pin
Mycroft Holmes23-May-18 14:23
MemberMycroft Holmes23-May-18 14:23 
QuestionFOR XML PATH is not creating Child elements if they are coming with null values Pin
indian14316-May-18 13:39
Memberindian14316-May-18 13:39 
AnswerRe: FOR XML PATH is not creating Child elements if they are coming with null values Pin
CHill6022-May-18 2:32
mveCHill6022-May-18 2:32 
QuestionEquivalent of the following query without FOR XML PATH Pin
indian14314-May-18 13:03
Memberindian14314-May-18 13:03 
SuggestionRe: Equivalent of the following query without FOR XML PATH Pin
CHill6015-May-18 1:11
mveCHill6015-May-18 1:11 
GeneralRe: Equivalent of the following query without FOR XML PATH Pin
indian14315-May-18 7:39
Memberindian14315-May-18 7:39 
GeneralRe: Equivalent of the following query without FOR XML PATH Pin
CHill6015-May-18 23:11
mveCHill6015-May-18 23:11 
GeneralRe: Equivalent of the following query without FOR XML PATH Pin
indian14317-May-18 15:56
Memberindian14317-May-18 15:56 
I can understand by can you please help me how can I create dummy values for the views vw_ServicesXML5010, vw_ServiceFacilityXML5010, as those views are not fetching any records, the xml is not generating those elements, is it possible to help me in that regards.

For example if I don't have any records for the View vw_ServicesXML5010 for that where condition I want to have empty value for the elements Procedure_Code, Modifier1, Modifier2, Modifier3, Modifier4, From_Date, To_Date, Revenue_Code, Place_Of_Service, Taxonomy_Code

Same thing applies to the View: vw_ServiceFacilityXML5010, if it doesn't have any records then at least one record set with empty values for the Service_Facility_NPI, County_Owned_Indicator.

Can you please help me buddy, thanks in advance.

Thanks,

Abdul Aleem

"There is already enough hatred in the world lets spread love, compassion and affection."

RantLatest Oracle Connection method Pin
Mycroft Holmes6-May-18 15:56
MemberMycroft Holmes6-May-18 15:56 
GeneralRe: Latest Oracle Connection method Pin
Jörgen Andersson16-May-18 1:20
communityengineerJörgen Andersson16-May-18 1:20 
GeneralRe: Latest Oracle Connection method Pin
Mycroft Holmes16-May-18 1:27
MemberMycroft Holmes16-May-18 1:27 
GeneralRe: Latest Oracle Connection method Pin
Jörgen Andersson16-May-18 1:37
communityengineerJörgen Andersson16-May-18 1:37 
QuestionSQL 2016 Optimization ... Pin
Member 138060854-May-18 2:10
MemberMember 138060854-May-18 2:10 
RantRe: SQL 2016 Optimization ... Pin
CHill604-May-18 2:13
mveCHill604-May-18 2:13 
AnswerRe: SQL 2016 Optimization ... Pin
Eddy Vluggen5-May-18 2:14
professionalEddy Vluggen5-May-18 2:14 
QuestionSQL 2016 Optimization ... Pin
Member 138060854-May-18 2:10
MemberMember 138060854-May-18 2:10 
QuestionHow to stop execution of other tasks in SSIS if a script task gets Dts.TaskResult = (int)ScriptResults.Failure; Pin
indian1432-May-18 15:12
Memberindian1432-May-18 15: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 9:41
Memberindian1433-May-18 9:41 
QuestionInsert dynamic SQL Values into Temp Table Pin
indian14326-Apr-18 8:03
Memberindian14326-Apr-18 8:03 
AnswerRe: Insert dynamic SQL Values into Temp Table Pin
Richard Deeming26-Apr-18 9:00
communityengineerRichard Deeming26-Apr-18 9:00 
GeneralRe: Insert dynamic SQL Values into Temp Table Pin
indian14326-Apr-18 11:09
Memberindian14326-Apr-18 11:09 
Questionmysql query Pin
Member 1360728325-Apr-18 17:47
MemberMember 1360728325-Apr-18 17:47 
AnswerRe: mysql query Pin
Jörgen Andersson25-Apr-18 22:48
communityengineerJörgen Andersson25-Apr-18 22:48 
GeneralRe: mysql query Pin
Member 1360728326-Apr-18 11:56
MemberMember 1360728326-Apr-18 11:56 
GeneralRe: mysql query Pin
Jörgen Andersson26-Apr-18 22:22
communityengineerJörgen Andersson26-Apr-18 22:22 

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.