• 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:
  • Help needed for date dimension which is not rolled up properly.

    I'm new to SSAS and I have dim_date table. Which have DateKey which is int and primary key (Eg data 19010101, 19010102 etc.,), date which is datetime(eg: 1901-01-02 00:00:00Z), year - smallint(Eg: 1901), month -tinyint(Eg: 01), monthname -varchar(January), day -tinyint (Eg: 1), dayname - Varchar...

    Sree11195 pointsBadges:
  • sql scripts

    Hi all, i'm updating a new 'commun management' software n i wanna update the database bcoz i added many extra tables. i did write scripts for all the tables this way: Create........... Drop........... Alter........ so our clients would be able to have access to it. but i have been asked to write...

    JARON5 pointsBadges:
  • Problem converting Access SQL query to T-SQL 2005

    I have a SQL Server 2005 database. One of my co-workers has put a MS Access front-end on it, because of the ease of designing queries in Access. I need to convert an existing query from Access SQL to T-SQL to put it into production. So far, I have removed all the obvious differences between the 2,...

    Chunkydrew15 pointsBadges:
  • Creating JCL to execute a large merged file of SQL for DB2

    I need to create a JCL that will execute - individually - SQL statements within a merged file (multiple SQL) and write the SQL results to a single output file. Suggestions?

    Jonty Walker105 pointsBadges:
  • Can SQL make noises?

    can you get SQL to 'make a noise' to indicate when a query has been executed? I.e. for long running queries, you wouldn't have to keep checking

    Melanie.king5 pointsBadges:
  • sql instance

    what is a sql server instance for? thanks.

    CarlosH5 pointsBadges:
  • Veritas vs. SQL Server 2005

    Why will SQL Server not accept files restored from Veritas backups?

    Patticake5 pointsBadges:
  • iSeries DB2 SQL subquery to compare yesterday sales to 120 day ternd

    Hi, I have an SQL query that I would like to populate with veriable date information each time it runs. If I hard code the dates, I get the results I expect. However, I can not get the date parameters to work with my query. Here's the " Hard coded version (Works) SELECT...

    MarcGreen20 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