What?
An article on how to declare 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:
//
-- ...
... 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 ...
... [student_country_birth_code],
[student_country_domicile_code],
[student_nationality_code],
[student_ethnicity_code]
FROM
[sourcedb].[dbo].[events]
Simple bit of ...
What?
This took me a while to find so I've posted an article below detailing how to parse or extract values from a string containing XML code.
Why?
I'm working with a system which stores XML strings ...
... these.
I would recommend using the DataTumble script over this one as this leaves data very difficult to work with:
Before:
StudentID StudentName DateOfBirth
...
What?
This is a stored procedure I've nabbed from some consultants from my day job. It shuffles the records and matching data values:
Before:
ID Name DateOfBirth
--------- ------------ ...
... Example:
My stored procedure will do the following:
Get a student ID number based on the student username
Get a student's names and date-of-birth based on the student ID number
Agenda Outline
Note: ...
Thought I'd add a note as I was getting confused with the built-in function "FormatDateTime()". The example is shown as:
=FormatDateTime(Fields!BirthDate.Value, DateFormat.ShortDate)
The ...
We use cookies to improve your experience on our website. By browsing this website, you agree to our use of cookies. Read more about our Privacy Policy.