Viewing 4 posts - 1 through 4 (of 4 total)
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
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
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
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
Viewing 4 posts - 1 through 4 (of 4 total)