Forum Replies Created

Viewing 4 posts - 1 through 4 (of 4 total)

  • RE: Eval equation, which is a string in a table

    Why do we use dynamic equations at all? I don't know. Maybe because nobody has rights to change The Stored Procedure.

    My example was wrong. Of course it should be

    something like:

    exec("select...

    February 27, 2002 at 2:36 pm

    #424586

  • RE: From SQL Server to Excel-macro variable ?

    Not Excel to SQL Server.

    SQL Server (or anything) to Excel with ODBC.

    

     With ActiveSheet.QueryTables.Add(Connection:= _

            "ODBC;DSN=ORA2;UID=ca;PWD=*****;DBQ=prod;DBA=W;APA=T;PFC=2;TLO=0;", _

      ...

    February 14, 2002 at 8:55 am

    #423830

  • RE: Indexing in SQL Server 7.0/2000

    quote:

    ...A date is often a better choice, even though these are often unique, lots of queries need items in a range.

    Steve Jones

    February 5, 2002 at 1:33 pm

    #423213

  • RE: What do you like best about databases?

    Best things:

    1) Database design with datawarehousing properties. That´s more fun than pure relational style.

    2) Designing multicolumn indexes and star-joins. Year and month -columns to every result tables and other methods...

    February 5, 2002 at 12:39 pm

    #423205

Viewing 4 posts - 1 through 4 (of 4 total)