Assuming birth is required, the following 3 results were found.
SELECT [sequenceID], [student_reference], [student_title_code], [student_name], [student_gender_code], [student_country_birth_code], [student_country_domicile_code], [student_nationality_code], [student_ethnicity_code] FROM [sourcedb].[dbo].[events]...
an XML element as NULL using the attribute "xsi:nil". I'm going to use a very short example by providing a blank date of birth value: -- What I have: // -- What I want: Why? Outputting from SITS:Vision to our staging environment, the application would...
to bring back both the code and the lookup value in our XML to our Staging environment. Why? Let's take the country of birth of a person as an example as it is expected to be a long list and where just using the parameter &S is not workable. Instead I...