1
  • 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 the value for...

    CO Bill120 pointsBadges:
  • 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

    Omaleem5 pointsBadges:
  • 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...

    Mjf75 pointsBadges:
  • view and temp. table which one works better in T-SQL?

    please tell me which one performs better view or temp table ?

    HL5 pointsBadges:
  • 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

    DAC15 pointsBadges:
1

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following