• 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:
  • Rookie Prolem: Using DIGITS() function on an INTEGER value

    Folk, here's my problem: My SQL knowledge is weak, but I know the basics based on RDBMS work. I have an SQL statement that contains the following statement: SUBSTR(DIGITS(b.SIN),2,9) My output looks like this: ".&114172661" (Quotes added for clarity. The SIN is a 9 digit INTEGER (114172661). It's...

    Jonty Walker105 pointsBadges:
  • cube data fails to display

    Working through the Foodmart 2000 sample sales cube in SQL Analysis Manager, all goes smoothly but at the end data does not display. The error message is "unspecified error", unable to browse the cube. This is the Sales cube created with the Quickstart example on Foodmart 2000.mdb.

    Psf55 pointsBadges:
  • Linked Servers????

    Hi everybody, I'm an IT student and i'm doing professional practices. A simple project was assigned to me. This company uses SMS to collect information of all his PC's and stores this information in a MSSQL database. A manager checks this information and fills another database located in another...

    EVX5 pointsBadges:
  • Looking for a database name query in SQL

    Is there a query in SQL that could return me the name of a database, or whether it is connected to SQL Server or Oracle?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Trim 2 right characters in a string

    In sql how would I trim off the 2 right characters in a variable length string

    Scooby9995 pointsBadges:
  • PL/SQL performance tuning…

    I need to move data between to schemas. I have a created packaged code to accomplish this. The problem is the execution time. When running the insert statements from the source schema to insert data into the target schema, it takes considerably longer to complete the statement than if I copied the...

    Jelewis0 pointsBadges:
  • V8 CMP EDM Pool

    Strobe shows very high CPU in Module DSNGEDM Sections DSNGECMP & DSNGEPUF (which free expanded EDM Pool Storage) for dynamic SQL in a CICS Region. Is this an EDM Pool sizing issue?

    Winger19515 pointsBadges:
  • Learning SQL

    If I am a beginner at SQL and want to learn more , what class would you reccomend I start with?

    Devee05 pointsBadges:
  • Using co-related queries in SQL

    How do you use co-related queries in SQL and why would they be useful? Is there any effect on performance when executing a co-related query?

    SQL Server Ask the Experts2,585 pointsBadges:
  • RPG/ILE re-entering workforce

    I am 45 & want to re-enter workforce after 3 years out of IT. I used RPG for 15 years(not even ILE) and have BPCS experience. I have just picked up a couple of books (SQL and Free-format RPG) to study at home. I think it will be very difficult to get back in .... any ideas/hints/tips would be...

    Bazza710 pointsBadges:
  • Finding the appropriate settings for copying tables within databases

    I have a table in a database that has 104456 records. I would like to copy the data to another table within that database. When I execute the command “insert into ChangeInsuranceTxnHistory select * from ChangeInsuranceTxn”, the following error occurs: "Could not allocate space for object...

    SQL Server Ask the Experts2,585 pointsBadges:
  • T-SQL how to identfiy tables that have dulicate roaws

    I have a MS 2000 SQL server. How can I search the db and indentify the tables that have duplicate raws. Thanks

    Techzon1225 pointsBadges:
  • Need help with a slow pl/sql script

    Hello. I am running this script and it is taking over 3 hours on Oracle 10. Can anyone help. ---------------------------------- spool noaddressusagerelfix.LOG set timing on; SET SERVEROUT ON; DECLARE vpartyCustomerNo TableB.I_OCPRTY_USAGES%TYPE; vI_OCPOSTAD_USAGES TableB.I_OCPOSTAD_USAGES%TYPE;...

    Darrankavanagh20 pointsBadges:
  • How to delete a duplicate SQL Server entry in a single redundant table?

    How do you delete a duplicate SQL Server entry in a single redundant table?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Is there a way to partial field (or substring) a DESCR254_MIXED (long character field) in a SQL statement?

    Is there a way to partial field (or substring) a DESCR254_MIXED (long character field) in a SQL statement? Have tried the following, which do not work: column descr254_mixed format A30 set wrap off select descr254_mixed from PS REQ_LINE SELECT left(descr254_mixed, 20) from PS_REQ_LINE

    SQL Server Ask the Experts2,585 pointsBadges:
  • Copy Attachments to Folder

    Anyone have a lotusscript to copy attachments to a folder? Also need to extract to excel a view but right now i think i can handle that with NotesSQL ODBC. The attachments part is buging me the most. This is not a mail system.... We have a database setup for document approvals. Lotus Domino 6.5

    Maramor140 pointsBadges:
  • Executing a Stored procedure using Excel Macro

    I am an amateur in SQL programming. Could you please tell me how to execute a Stored procedure using Excel Macro (VBA Programming) and then save the record set into different Excel sheets?

    SQL Server Ask the Experts2,585 pointsBadges:
  • SQL SERVER REPORTING SERVICES

    can anyone explain what is presentation delivery utilizing reporting services?

    Swaroopa5 pointsBadges:
  • msforeachdb

    Could not locate entry in sysdatabases for database, when using msforeachdb

    Llsnowinaz5 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