First thought would be looking at any looping (i.e. ForEach) iteration's configuration. Next would be a file system problem where a parent folder is mounted in a child folder, could...

Use the same method, just null the date in the subquery

😎

USE tempdb;

GO

declare @t table (v1 int , v int, v2 datetime)

insert into @t values(4,10, '2014-01-01 10:00:00')

insert into @t values(5, 20,'2014-01-01...

Quick question, what is the expected output?

You could use MAX with the right window specification

😎

USE tempdb;

GO

declare @t table (v1 int , v int, v2 datetime)

insert into @t values(4,10, '2014-01-01 10:00:00')

insert...

Quick pointer, the query is only a character string in the code and it never gets executed. Change the code to include the query not using a string.

😎

Quick question, what is your SQL Server version?

😎

Jeff Moden (6/30/2014)

---

... sooooo, throw the packages out,

you...

WayneS (7/1/2014)

---

SQLRNNR (7/1/2014)

---

Jeff Moden (6/30/2014)

---

... sooooo, throw the...

DECODE can be replaced by a case statement as it is...

Quick question, is the compatibility level the same for both databases?

😎

Quick question, is the compatibility level the same for both databases?

😎

Quick thought, this article might get you started

Using the XMLTable() Function

😎

...he's reading all your posts

and counting your mistakes

so you better...

😎

bleroy (6/29/2014)

---

Thanks a lot Eirikur! This is what I needed.

And I really like your choice of fun! this is exactly the kind of stuff I want to do with it...

Adding a little fun to it

😎

;WITH XMLNAMESPACES (

...

This is simply a question of getting the namespaces right, this should get you passed the hurdle

😎

USE tempdb;

GO

DECLARE @TXML XML = '<?xml version="1.0" encoding="UTF-8"?>

<gpx

version="1.1"

creator="RunKeeper - http://www.runkeeper.com"

...