Filtering a select based on the value of one column and the max value of another column
I’ve created a temp table and need to further select some data from it. Seems simple. The temp table contains thousands of orders, an action code (C or D)and a seq_ID for each order. Each order has multiple instances of the C and D action codes, but I only want a list of those where [...]

Answer Question   |  February 28, 2012  6:07 PM
SELECT, Temp Tables

Temp Tables
Hi, My question is basic and should be simple to answer I assume. I’m a beginner so I don’t know much about Temp Tables? Can you please show how Temp tables work and the concept behind them. Thanks, o

Answer Question   |  November 6, 2008  6:27 PM
Temp Tables

How to find out what is happening in a Database?
We have an old server that runs SQL Server 7 on an NT system. One database has processes running that are not documented. I have written triggers to report any deletions, inserts or updates made against the database’s tables. All I can report is that an insert, update or delete has occurred, the Date and [...]

Answer Question   |  July 15, 2008  11:01 PM
SQL Server, SQL Server logs, Temp Tables, Triggers, Unknown processes

Temp Tablespace in 10G
have a Oracle 10g database that is with its temporary tablespace full. Is there any way to clean this tablespace? I tried to restart the database, but i’ve no effect

Answer Question   |  January 25, 2008  7:42 PM
Oracle 10g, Temp Tables

view and temp. table which one works better in T-SQL?
please tell me which one performs better view or temp table ?

Answer Question   |  February 22, 2008  12:13 AM
Oracle Views, T-SQL, Temp Tables