If you look under your linked servers and the database name is default you should query the linked server as such. [linked server]..[schema]., as SQL Server will know to...

From my experience it may help by using skipping the database name in the four part name. For example:

[LinkedServer]..[Schema].[Table]

Jason,

I achieved the same results as you, but they seemed skewed. I dug a little deeper and realized that you created a cluster index on your tally table, which...

Is this what you are looking for?

declare @test-2 table

(

[dayofyear] datetime,

dailytotals int

)

insert into @test-2

select '01-01-2007', 01 union all

select '01-01-2007', 05 union all

select '01-01-2007', 10 union all

select '01-02-2007', 28 union all

select '01-03-2007',...

Is the table name and Column uppercase on the Oracle server? These should match the results of your sp_tables_ex @table_server=CUSTOMERLINK, @table_schema='CUSTOMER1' command.

Have a look at these two articles:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;280106

http://support.microsoft.com/kb/240340/

Jason,

Which script from PW did you compare to yours, the CTE or the subquery one?

Thanks Antares, I will take a look at the link.

Nice!:cool:

Does anyone know if Oracle 9i has data access tools for a 64 bit server. I am running into this vary issue; however, I cannot find any 64 bit...

Yeah, I stopped and thought about it and a light went off :hehe:

Great solution Jason. 😉

The original specification required that the data be in a not incrmental format. For example, if A11 has 2 then it should be displayed as

1...

Thanks guys for the post :D. I will take a look at the suggested methods. Lynn, per your request, I am attaching a sample of the text file....

Yeah. XQuery really get its power from querying and modifying XML. This is just a method for getting data from xml into SQL Server. You will note...

Is this even possible?

Thanks,

Adam

Yes, It actually says "total record - Last record on file", before the second set of data starts.

the second set of data is actually meta data. It sums up...