Forum Replies Created

Viewing 15 posts - 31 through 45 (of 51 total)

  • RE: Using OPENROWSET

    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...

  • RE: Using OPENROWSET

    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...

  • RE: SQL Server system requirements

    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...

  • RE: Dynamic IN with strings.

    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...

  • RE: Dynamic IN with strings.

    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. ...

  • RE: Question/problem with OR

    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...

  • RE: Question/problem with OR

    Hmm I am so screwed once again. No support for CASE in unisql. if there is possibly another way I am all ears.

    Matt

  • RE: Question/problem with OR

    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...

  • RE: Question about Rollup

    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...

  • RE: Using dateadd

    What does the 101 mean on the convert? I looked it up on books online but didnt see anything on 101.

    Matt

  • RE: Db Design question

    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...

  • RE: Db Design question

    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...

  • RE: Linked Server Issue

    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...

  • RE: How do you write a top without top

    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...

  • RE: How do you write a top without top

    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...

Viewing 15 posts - 31 through 45 (of 51 total)