The correct behavior for an aggregate concatenation query is undefined.

That is, the correct result of the query that...

What does "no luck" mean? Error message? Unexpected results?

And if you add PRINT @sql what do you see?

But if the table is small, why not filter on the SQL Server...

You convert to format 111 which is YYYY/MM/DD, and then you tell Oracle to convert to YYYY-MM-DD, and then it goes downhill from there.

Try format 121 instead.

And if Oracle is...

To add what Gail says, you need to run the query once saving the data into a temp table, wait for time, and then run again to compute the delta....

Yes, but you should also add

> nul

to the command line. Since...

No, it is because it uses...

rajborntodare (8/27/2013)

---

Yes, is there a LOG directory? And in such...

And this user is also a user in SQL Server with sysadmin permission?

And you did use SQL Server Configuration Manager to set the service account, didn't you?

A two-word answer is: it depends.

That said, generally, using a multi-statement table valued function lowers your odds for good performance, because the optimizer has no clue about how many rows...

Do you have file C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Log\SQLAGENT.OUT?

In such case, does it include anything interesting?

Note that the exact path varies depending on your installation. The above assumes a default...

Eric1/2aB (8/26/2013)

---

6 - What would you suggest for fill factor on a table like this? 100%?{/quote]

For indexes on GUIDs, an idea is to have a low fill factor, say...

Easier to...

There is always that the caveat that the optimizer might change.

However, it's a little difficult to see why it would happen in this case. Changes in the optimizer are usually...

Jeff Moden (8/25/2013)

---

At this point, I guess I'll have to say "To each their own". The Developers I've talked with (both SQL Server and Front-Enders) are glad to have...

Glad to hear that there was a happy ending!