Viewing 15 posts - 31 through 45 (of 51 total)
I found a way to make it work. I used OPENQUERY and linked them together that way and it seems to be working. Don't ask why the other way...
January 30, 2003 at 2:42 pm
Well I made some progress and got the OPENROWSET syntax correct and it is now looks as follows:
SELECT L.[DATE],E.* FROM LOGS AS L INNER JOIN OPENROWSET('Ardent.UniOLEDB','localud;user;password;','LOGS') As E on L.contractornum...
January 27, 2003 at 1:29 pm
Thanks, I didn't think there was any type of limitation. I was not sure if Xeon processors running SQL Server required that you have SQL Server Enterprise edition. Cool...
November 11, 2002 at 6:05 pm
yeah that solved the problem... I accepted the date as a varchar and in the string itelf I put in a Cast to convert it to a datetime and now...
October 1, 2002 at 1:51 pm
hmmm once I did that you are right it tells me it cant convert datetime to a character string. I tried casting the 2 date fields as datetime. ...
October 1, 2002 at 1:16 pm
That did the trick bill. I wish I thought of that. Thats gonna come in handy.
Steve: IN is like an OR except less code for multiple...
September 5, 2002 at 11:48 am
Hmm I am so screwed once again. No support for CASE in unisql. if there is possibly another way I am all ears.
Matt
September 5, 2002 at 8:00 am
hmm I don't think that is what I am looking for. Let me try to explain myself better. All that stuff that has AND in between it has...
September 5, 2002 at 7:51 am
Well my result set looks like this:
termnum,username,page
termnum,username,null
termnum,null,null
--------------------
termnum,username,page
termnum,username,null
termnum,null,null
null,null,null
hmm I see whats going on now. Termnum is unique but I could have multiple username's. So its calculating the totals for...
August 30, 2002 at 7:05 am
What does the 101 mean on the convert? I looked it up on books online but didnt see anything on 101.
Matt
July 9, 2002 at 1:30 pm
Never mind, I figured exactly how to do it. I will store all the data in the 1 table and in the 2nd table I will store the 2...
June 28, 2002 at 10:29 am
Unidata is NOT a relational db system. ITs whats called an extended relational database system (like OLAP I guess) and well its indexed. Actually indexing the PK,FK of...
June 28, 2002 at 9:21 am
I understand what you mean under linked servers but there is nothing under linked server for ANSI_NULLS & WARNINGS.
I did set the connection thing in SQL Server properties and for...
June 24, 2002 at 2:36 pm
OMG that worked. I am highly impressed. Though the query took 6 seconds to run. But its not indexed yet, hopefully if its indexed it will take...
June 21, 2002 at 8:26 am
I figured it out I think. I wrote it sql query analyzer under the master db. Well it pulled in data but when I used the Set rowcount...
June 21, 2002 at 7:49 am
Viewing 15 posts - 31 through 45 (of 51 total)