This can be achieved by a FLWOR operation.

DECLARE @x XML = '

<Root>

<Student>Jhon </Student>

<Student> Luka </Student>

<Post>1</Post>

<Post>2</Post>

</Root>'

SELECT @x.query ('

for $i in (Root)

let $s := $i/Student

let $p := $i/Post

return

<Root>

<Students> {$s} </Students>

<Posts>{$p}</Posts>

</Root>

')

/*

Produces:

<Root>

...

You can use Denali CTP3

Most people submit their solutions in the first two weeks after the challenge is published. The evaluation then might take another 2-4 weeks to complete. The solutions will be available...

The last example clearly mentions that it will work only on SQL Server 2008 and above. Are you running the example on SQL Server 2005?

This is caused by a limitation in the number of characters the title can take 🙂

Yes, it is possible to have several purchases in a month.

Differential backups and partial backups are not the same.

The backup/restore operations of a FILESTREAM database is expected to be the same as NON-FILESTREAM databases.

I just tested this and verified that the differential backup includes FILESTREAM data files...

Glad to know it helped.

You will need to build a dynamic query and execute it (to have the value of a column transformed as an element name).

Look at the link given in my previous reply. That link will take you to the page where the function is listed.

No, this is not an in-built function. The article had a link to download the source of this function.

You can find it here.

Well, this may be considered as a 'better wheel' because the other 'wheel' does not turn well. If you closely observe the results produced by this function and compare it...

Yes, the next item in the task list is to support namespaces.

Thanks, Fixed both places.