Just read that it goes back to 8i. FYI

Do you happen to know if the Oracle Instant Client is compatible with previous versions.  Say, anything between 8i and 10g.

I was thinking about your comments and how to create a UDF that looks at GETDATE and say an argument for the number of months when it occured to me...

How many posts do I need before I can get rid of that NEWBIE moniker?!!

Another interesting approach! 

I ran both queries against a million-row table to compare the execution plan.  David's suggestion showed a subtree cost of 7.  Yours originally had a subtree cost of...

You rock.  Thank you very much for sharing this innovative approach.  Works perfectly. 

I use OWC against Views, but I would like to run OWC reports against Analysis Services cubes.  Is this possible??

SAM

Yo Remi...no question, just a general post of how to do this because I couldn't find it anywhere else.  If you feel inclined to bend your mind a bit, make...

First you need to determine the length of the file (DOS???  If not use Perl, VBS? JS), then you do something like the following.  I dont know how to drop...

I just went through this headache....the following will work with a few tweaks for your specific needs.

------------------------

If Object_Id('tempdb..#tmpPVS') is Not Null

DROP TABLE [dbo].[#tmpPVS]

CREATE TABLE #tmpPVS

(

ViewDate datetime,

PageID nvarchar(255),

CountryCode varchar(2),

LanguageCode varchar(2),

ViewCount int,

)

INSERT...