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

  • 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;", _
    ...
  • 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

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

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