Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!
Course Of The Month
10 days, 1 hour left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
XML Select "TYPE=" or Version=""
Posted on 2011-03-04
How can I take my code below and when there's no OrganizationalType return this
<OrganizationalType Type="NOType"/>
Instead of this
<OrganizationalType />
<OrganizationalType Type="NOType"/>
Instead of this
<OrganizationalType />
Select blah...blah...blah...,
debtOrganizationalType 'Debtors/Names/IndividualName/OrganizationalType'
from
research.dbo.r_data_ucc where debtLastName Like 'B%'
for xml path('Record'
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
2-
2
4 Comments
Active 6 days ago
Select blah...blah...blah...,
isnull(debtOrganizationalT
from
research.dbo.r_data_ucc where debtLastName Like 'B%'
for xml path('Record'
isnull(debtOrganizationalT
from
research.dbo.r_data_ucc where debtLastName Like 'B%'
for xml path('Record'
Active today
derekkromm
That returns
<OrganizationalType>NOType
I need
<OrganizationalType Type="NOType"/>
That returns
<OrganizationalType>NOType
I need
<OrganizationalType Type="NOType"/>
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
In part one, we reviewed the prerequisites required for installing SQL Server vNext.
In this part we will explore how to install Microsoft's SQL Server on Ubuntu 16.04.
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.
Suggested Courses
Earn Certification
HTML5 Specialist - Certification
Free withPremium
Course of the Month10 days, 1 hour left to enroll
623 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.