• Online report missing data that is in PDF

    When we view a report on Report Manager it shows 5 rows and a group count of 10. If you spool the report out to PDF or print it, it shows 10 rows and a count of 10. If you search online, the data in rows 6-10 cannot be found but they are there in the PDF and the printed version. Why is the data...

    AndreaFl5 pointsBadges:
  • SQL split column into multiple rows.

    I'm going nuts.. I have a table with 30+ columns. One of the columns has a string with serial numbers that are comma separated. What I'm trying to do is create a new temp table with the identityID and the serial number. This way I can add each parsed out serial number value to our production data...

    ToddN200042,930 pointsBadges:
  • RUNSQLSTM command failed

    I have created one member with SQL table type under which I have written create table query. But when I tried to compile program using RUNSQLSTM, it's showing RUNSQLSTM command failed. I am using pub1 demo server.

    nabamita30 pointsBadges:
  • Using Count in SQL database

    I have a database with students results, for test and assignments also examination final marks so I want to count the number of student who wrote a certain test, count the number of those who passed and those who failed. How can I implement that in SQL?

    EllyodM5 pointsBadges:
  • Can we use neverfail for data replication between SQL Ent and SQL Standard version?

    Does anyone know if we can use neverfail for data replication between SQL Enterprise and SQL Standard versions?

    qaziaamir5 pointsBadges:
  • TOP SQL statement not working

    I am running a simple SQL query on toad SELECT TOP 2 HRS_OFF_ID FROM PS_HRS_OFFER but it keeps on telling me that 'FROM' keyword not found where expected. What wrong am I doing here?

    ashwin255 pointsBadges:
  • SQL query: Fetch all records from date field

    Hi, How to fetch all records from the date field less than current date's records provided date field format is centuray(C):YY/MM/DD Thanks.

    6r1,665 pointsBadges:
  • Help using oracle Analytical function.

    I am trying to create a query that will do two parallel select from the data available. I want to write one select statement using analytical functions, What I want to do is as follows: I one single query I want to find out the count of the transactions in the last 7 days from sysdate and last 6...

    Prativa0 pointsBadges:
  • Receiving SQL error message: ORA-01722

    In Oracle / SQL, I keep getting an error message when I'm trying to an insert. Here's the message: ORA-01722: Invalid number error. What does that mean? What can I do about it? INSERT INTO CUSTOMER VALUES (1,'Michael','Claire','27 Smith St Caulfield','0419 853 694'); INSERT INTO CUSTOMER VALUES...

    ITKE392,170 pointsBadges:
  • How to get unique values from column without using Distinct keyword in Oracle?

    I have a table in which the column has duplicate values in it. If i need to get unique value from that column without using distinct keyword then what will be the query?

    Sheeldk5 pointsBadges:
  • How can I write my name with this condition (First name can only contain alphanumeric characters, hyphens and apostrophes)

    How can I write my name with this condition (First name can only contain alphanumeric characters, hyphens and apostrophes)? Can anyone help me?

    Nurwarsame5 pointsBadges:
  • File size more than 180 GB for the data extracted from an internal table

    If I'm getting a file size more than 180 GB for the data extracted from an internal table. How do I resolve this issue?

    prateekdevnani5 pointsBadges:
  • How to find 10 sequencing date for today in SQL query

    It's like date 1 2 3 4 5 6 7 8 9 10 with month and year. How can I do this using a SQL query?

    sundramkharya5 pointsBadges:
  • Display only the duplicate records in SQL

    I need a query to display only the duplicate records alone. For an example, distinct filtr the duplicate records and displays the actual record. Here I need only duplicate records.

    NARMATA50 pointsBadges:
  • SQL: How to display the last name alone from the emp name where first name n lastname is in a single colum

    Is there a way to display the last name alone from the emp name where first name n lastname is in a single column?

    NARMATA50 pointsBadges:
  • Should I run a SQL view in my SQL Server database?

    For SQL Server, should I run a SQL view in my database? My friend told me to just run a stored procedure but I would rather run a view for security purposes. What should I do?

    ITKE392,170 pointsBadges:
  • SQL query replacing not in

    I wrote this query with not in replace the not in with not exist. SELECT LASTNAME , TITLE FROM NOR_EMPLOYEES WHERE EMPLOYEE_ID not in (SELECT E1.EMPLOYEE_ID FROM NOR_EMPLOYEES E1,NOR_EMPLOYEES E2 WHERE E1.EMPLOYEE_ID=E2.REPORTS_TO);

    vscbobbadi5 pointsBadges:
  • How can I change SQL language and date format?

    I'm using an older version of SQL Server (2005 to be exact). So when I try to execute, DBCC USEROPTIONS, it's giving me a foreign language and the date format DMY. I need the language to be in English / format in MDY. Is there a way to change this? Thank you very much

    ITKE392,170 pointsBadges:
  • How to change SQL editor coloring in Eclipse

    In SQL, I was able to change my syntax coloring in Eclipse preferences but my normal text still remains in black. Is there a way I can change the setting?

    ITKE392,170 pointsBadges:
  • ORA-00936 error with SQL NVL statement

    I'm using Oracle and I have this SQL NVL statement: select a.*, case when NVL (SELECT max(b.field1) FROM b where b.field2 = a.tbl_a_PK , 'TRUE') = 'TRUE' then 'has no data in b' else 'has data in b' end as b_status from a My SELECT is returning one value (as it should) but I'm also getting...

    ITKE392,170 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.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

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

Following