• Can embedded SQL in a SQLRPGLE program be used as a stored procedure?

    I am successfully using (external) stored procedures with many RPGLE programs. (Some of these are SQLRPGLE programs because they return a result set.) All of this works fine. But if I try to replace some of the RPG I/O in a RPGLE program with embedded SQL, creating a SQLRPGLE program, and run it as...

    Warykat20 pointsBadges:
  • Syncronizing between Distributor and Subscriber in Merge Replication

    HI everybody, i am using merge replication. my concept is that: a publisher publishes a file and then it synchronized with distributor in a schedule (publisher and distributor are in same server). Then Subscriber subscribes (Sync) from (with) distributor not publisher. I want distributor to act as...

    Jah5 pointsBadges:
  • Duplicating records in a table with a SQL query

    How can I duplicate every record in a table with a query in SQL?

    SQL Server Ask the Experts2,585 pointsBadges:
  • COPY data between to files with SQL in iSeries

    hi, i need help with this: i have two files in Iseries one of them is new and other have old records and i pretend with sql copy some records. But file 1(new) and file 2(old) they don't have same collums file1 file2 fielda fielda fieldb fieldb fieldc filedd fieldd how can i make the correspond...

    BUG68225 pointsBadges:
  • Concatenating two note fields into one, but need them to be on their own line

    sort of like update table set master_note = Note1 + CRLF + Note2. result should be Note1 Note2 I cant find the syntax fir the CRLF part. Any suggestions?

    Macsterling5 pointsBadges:
  • Reporting Services 2000: Deployed results different from preview in Visual Studio

    I have 1 main report that contains lists. In each list are many subreports. The subreports are called multiple times based on the grouping in the list Problem: There is one particular subreports that shows the zero amount after deployment. However, the results are accurate when viewed in Visual...

    Droozy15 pointsBadges:
  • Differences between SQL Server 2005 and SQL Server Express

    How much does it cost to buy SQL Server 2005 Standard or Enterprise Edition, and how do they differ from SQL Server Express Edition?

    SQL Server Ask the Experts2,585 pointsBadges:
  • How to check the existence of a Column in SQL Server 2000?

    - using SQL Server 2000 , Would like to know how to check any specific column exist in a database. Any method to search through the list of tables in a database. Thanks.

    Hunkgym5 pointsBadges:
  • How to process partitions (Full) in analysis services

    Hi, I have a cube which on a daily basis partitions will be created Partition names: shipment2008_12_31 shipment2009_01_01 shipment2009_01_02 shipment2009_01_03 shipment2009_01_04 .... . . . . I have to process the partition based on the day. If the day is 03 jan 09 the package has to process...

    GIG240 pointsBadges:
  • Creating a username and password on a SQL Server database

    How we can create a username and password on my SQL Server database?

    SQL Server Ask the Experts2,585 pointsBadges:
  • stored procedure component

    what is the difference between the way of using storedprocedure component in delphi5 and delphi7?

    VPL95 pointsBadges:
  • What should our next contest be on ITKnowledgeExchange.com?

    We want to kick off the new year with an exciting contest and want your input. We have done a variety of contests from the top 3 Knowledge Point earners winning prizes like an XBOX 360. Also we have had Amazon.com gift cards for the top 10 point earners who achieve over 500 Knowledge Points. I want...

    ITKE54,665 pointsBadges:
  • Upgrading to SQL Server 2005

    I have a question regarding SQL Server upgrades. We have two active/passive clusters on which SQL Server 2000 resides. I want to install SQL Server 2005. How would I go about doing this?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Changing Compatability Level from 65 to 80

    SQL 2000 (sp4) instance with databases at compatibility level of 65 and 80. Is changing the compatibility level from 65 to 80 actually upgrading the database to 80? What should be done before and after changing the Compatibility level?

    Rah15 pointsBadges:
  • Find Next SQL AutoNumber

    Hi, I was wondering if there is a way to find the next autonumber in a SQL table before inserting the record? I tried just looking at the previous number and adding one but if I delete the last record then this wouldn't work or if I delete all the records then the number won't be 1. Any suggestions...

    RoadDust390 pointsBadges:
  • Unreported error in an order entry application designed in SQL

    I have developed an order entry application in SQL Server for a client. One of its functions is to insert invoices into the relevant tables. The procedure only does the job 997 times out of 1000 on average. In a single day, that means that hundreds of invoices are incomplete. No errors are...

    SQL Server Ask the Experts2,585 pointsBadges:
  • sql server 2005 mirroring

    i have 2 servers, with sql server 2005 standar version, running mirroring, can i see if the data is being updated? how know that? can i make backups while running my mirroring?

    RaulZ5 pointsBadges:
  • Is there a way to retrieve datatypes from stored procedures?

    I have used the following simple query to retrieve datatypes from sql 2000 tables. select TABLE_NAME, COLUMN_NAME, DATA_TYPE, CHARACTER_MAXIMUM_LENGTH from <tablename>.information_schema.columns where table_name = '<tablename>' and column_name = '<columnname>' Is there a way to...

    TlogP15 pointsBadges:
  • How to backup a SQL Server database

    Hello, I wonder if you can help. We are just about to start implemetation of SQL 2005 Server. Can anybody, let me know how we go about backing up the database? We have veritas 9.1 but I guess we need to back-up live if possible... What is our best option?

    Garrybreed45 pointsBadges:
  • Tricky Grouping problem!

    I am trying to migrate some Employee absence data, from one table to another. The data currently looks like: Employee, Date, Reason ------------------------ dave,01/01/08,sick1 dave,02/01/08,sick1 dave,03/01/08,sick2 dave,04/01/08,sick1 dave,05/01/08,sick1 bob,01/01/08,sick1 bob,02/01/08,sick1...

    EggBeard5 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