Looks like you need to talk to Oracle

This works:

declare @sql nvarchar(4000)

set @sql= 'exec xp_fileexist ''' + @DbFilePath + ''''

insert into #fileExist

exec sp_executesql @sql

homebrew01 (4/29/2015)

---

I have a flat file from a vendor, with 244 columns, pipe delimited. Some columns have dates, email, status codes etc, but some have a few sentences of text...

gward 98556 (4/28/2015)

---

The topic was teaching beginners how to move things into a CROSS APPLY from other parts of the query, so they can be reused instead of repeating their...

gward 98556 (4/27/2015)

---

It's worth being aware that CROSS APPLY works kind of like an inner join, but OUTER APPLY works kind of like an outer join, so if your APPLY...

First of all, NOLOCK doesn't deliver on it's promise. It *does* take locks (e.g. schema stability locks).

Second, it's a synonym for READUNCOMMITTED, which is what I recommend...

Get rid of NOLOCK

Justified, for the most part.

I try to avoid both cursors and while loops at all costs. I find them both quite expensive in terms of performance. unless forced to because of what is happening...

Hugo Kornelis (4/15/2015)

---

But note that supplying an offset only produces the expected results if you can be sure that there is exactly one row per month in the sales table....

Martin Schoombee (4/13/2015)

---

To be honest, I like to stay away from the built-in FTP task as I always seem to encounter issues with it.

My guess with the limited information is...

Oops! Good catch!!

Yes, that is true. The section "Using Apply" is about half-way down the page.

INCREDIBLEmouse (4/2/2015)

---

Nice article. Good points. And all that Jazz.

But - I was stunned by the use of underscores as source aliases.

cross apply (something) as _

cross apply (somethingelse) as...

arvin_d (4/2/2015)

---

Hi.

Wouldn't the logic of the APPLY syntax be logically similar to the following:

SELECT

T.[ModelRegion]

,T.[TimeIndex]

,Sum(T.[Quantity]) AS [Quantity]

...