Michael DeYoung

ETL for Free-Form Data

This article demonstrates how to extract, transform and load free-form data into a structured form like a staging table by way of XML conversions.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(12)

You rated this post out of 5. Change rating

2008-03-20

5,595 reads

My life has some crazy travel stretches for sure. Between speaking, office visits, customer...

In Part 1, we saw how ‘Vamana’ represents vectors as nodes, connects them with...

I’m excited to announce the release of a new open-source project that fully automates...

Comments posted to this topic are about the item ORDER BY alias

Comments posted to this topic are about the item Optional Parameter Plan Optimization in...

Comments posted to this topic are about the item AI Experience Gap that we...

There is a table tmp_tab:

CREATE TABLE tmp_tab (
id int,
val int
);

INSERT INTO tmp_tab VALUES
(1, 1),
(2, NULL),
(3, 3),
(4, 4),
(5, 5);

You want to order the rows ids by the following expression:

    ISNULL(val, id) + 1

Which of the following queries produces the expected ordering and why? (Select all correct)