• SQL Server: Query is filling up TEMPDB database

    I'm using SQL Server and my partner and I need to figure out how we can identify which query / stored procedure continues to fill up our trans log in our TEMPDB database. It's really starting to become an issue. Thank you.

    ITKE435,865 pointsBadges:
  • Automating a SQL query

    I want to run a SQL query automatically and getting the output in Outlook from remote desktop daily. How do I automate it?

    ansarkhan5 pointsBadges:
  • Move SQL query results to another table

    I have this query: SELECT a.* FROM devices_staging a INNER JOIN ( SELECT ComputerName, MAX(SystemSync) max_date FROM devices_staging GROUP BY ComputerName ) b ON a.ComputerName = b.ComputerName AND a.SystemSync = b.max_date And the results I get are correct. How do I move these results to another...

    icelander5 pointsBadges:
  • SQL query: Find out the count of employee whose name is more than one time

    In SQL, how do I find out the count of employee whose name is more than one time in a table?

    meghanap5 pointsBadges:
  • Get all table names by SQL

    Hi, How can I get all the table names of a bib by a SQL-query? Thank you.

    Oli0015 pointsBadges:
  • Create a sequence called Store_seq with the following values: increment by 10, start with 500

    Create a sequence called Store_seq with the following values: increment by 10, start with 500

    VB RD45 pointsBadges:
  • SQL query for employees in my department

    We need to find 50% of employee from each department, who is getting max salary. And every department have different employee count. ex. finance may have 100 employees and sale may have 40 employee. How do I write a query for this?

    mukeshkumar1230 pointsBadges:
  • Update a subquery with different tables

    I am trying to update a table and use a subquery for the argument. I think I have both queries correct but since but since they are from two tables I am not tying together correctly. Can you tell me what I need to do? update MVXJDTA.MITMAS set MMSTAT ='01' where MVXJDTA.MITMAS.MMITNO =...

    Bartbart50 pointsBadges:
  • Learn to use SQL queries

    I'm a beginner in computer science so how can I make grip on Oracle SQL Plus. Is there any website or any electronic book that contains preset queries on SQL which can help me in working in SQL. I want a guide book which has queries to start and work in SQL Plus and developer.

    Yasir oracle5 pointsBadges:
  • show zero sum in sql query

    i want to display for all regions sum value. The region 4 is 0 but it is not displaying 0

    Rola77720 pointsBadges:
  • How to kill session in Oracle application express

    I created a report through SQL query "select sid,serial# from v$session" with check boxes beside them. I want to kill session using sid,serial# of checked row by creating process in PL/SQL.

    hemanthroy3695 pointsBadges:
  • Issues deleting records in SQL database

    I'm having issues deleting records in a SQL database. What should I do?

    rockquery45 pointsBadges:
  • Slow performance for a SQL query

    I have a SQL query I am running, but it is experiencing significant slowdown. The main table - has over 1 million records and a unique key of cusID. It has a one to many relationship with the other two tables mentioned. The query code is as follows: Select customer.cusID,customer.VisitDate,...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Using .NET gridview control with AS/400

    I am tiring to update a table in the AS/400 with the .NET gridview control and I am having trouble binding the parameters to the SQL query. My select query work if I use a liked server but it is slow. Next I tried the ODBC driver but my select query is not working with the same input parameters....

    DJJIII5 pointsBadges:
  • Using SQL code to read a filename

    Can you write a SQL query that will read PDF filename from a dir and then match the filename to a data element in a table having the same name? For instance, the filename is 12345.pdf where 12345 is actually an invoice number. Can the query read the filename and then locate the same invoice number...

    Teedee5 pointsBadges:
  • Using SQL to insert records into a table

    I have a table with a period in the table name, i.e. AB.CDE that I need to insert some records into. When I query the table (Select * from "AB.CDE") it works fine. When I try to insert records (insert into "AB.CDE"), however, I get a file not found message. Does anybody know why this is happening?

    GaryF60 pointsBadges:
  • row_number in SQL 2000

    How do I find out the row_number in SQL 2000 like using row_number() function in SQL 2005?

    Rl10 pointsBadges:
  • How to check JDBC agent connected with RTCP?

    Currently I'm working with JDBC virtualization IBM RIT. I created testcase for database with a basic SQL query and it is working fine. Now I'm facing issues while creating stub with database. It's showing DJBC agent not connected with RTCP. I got struck up with that step. Don't know how to proceed...

    Mathumathi5 pointsBadges:
  • Find the employees who earn a salary greater than the average salary for their departments using a SQL query

    Find the employees who earn a salary greater than the average salary for their departments using a SQL query

    Sameera5 pointsBadges:
  • Equivalent for crosstab query

    Is there any function in MySQL that can create a query similar to crosstab query in MS Access?

    Sgheorghian5 pointsBadges:

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