• SQLRPGLE Cursors and Recursion

    I'm trying to recursively call a PI in my SQLRPGLE program. Problem is, I get an SQLCODE error of -519 and I'm sure it has to do with cursors and the prepare statement in my PI. Here's the code: pprintPrograms    b      dprintPrograms    PI      d...

    Dcantwell480 pointsBadges:
  • ssma_oracle.to_char_date

    ssma_oracle.to_char_date function was missing in the conversion. Do you have the code for the function?

    ayso2976005 pointsBadges:
  • Types of JOINs in SQL

    What are the types of JOINs in SQL?

    vijaykumar110 pointsBadges:
  • Writing a hidden trigger against a SQL table

    How do I write a hidden trigger against a SQL table?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Convert Crystal Reports to SSRS

    What's the best way to convert Crystal Reports reports over to SSRS? Over the next few weeks, I have to convert a bunch of them but I'm not sure of the best way. I know how to do it manually but I was wondering if there was an automatic solution?

    ITKE978,235 pointsBadges:
  • How to fit SSRS report into PDF page

    Hello, I need my SSRS report as a PDF page. What's the process for this? Appreciate the help.

    ITKE978,235 pointsBadges:
  • How to upload CSV file into SQL Server

    I have a very large CSV files and it needs to be uploaded into SQL Server using C#. How can I do that? It has thousands of rows / roughly 20-30 columns. Thanks so much.

    ITKE978,235 pointsBadges:
  • No tables available when importing CSV file into SQL Server database

    For the past few days, I've been trying and trying to import a CSV file so I can insert data into an existing database table. This is for SQL Server. Here's the issue: When I'm trying to select source tables / views for the destination, I don't see any at all. Nothing is coming up. It's basically...

    ITKE978,235 pointsBadges:
  • How to view content damaged MS SQL Server database?

    Help! Dead computer and all the information. Computer to reinstall formatting (otherwise failed). With the help of programs to restore files managed to pull Fail SQL database (.mdf). But on the other computer does not accept the file. Writes an error. Already tried everything. How do I restore the...

    hanamor11005 pointsBadges:
  • How can I restore a database from .mdf file?

    How can I restore a database from .mdf file? I only have .mdf backup file.

    SQL Server Ask the Experts2,585 pointsBadges:
  • Creating a new database using an MDF file

    My database saves as MDF. I want to know what are the steps to restore or create a new database using a MDF file? I tried to restore as usual but it shows an error. Please help.

    Thrstorm5 pointsBadges:
  • Oracle SQL script to deactivate customers records with possible multiple debt some paid some not paid

    I want to write a Oracle SQL script that will only deactivate a customer record with no outstanding debt.

    lindadawes5 pointsBadges:
  • How to take a table-level backup in SQL Server 2008

    Does anyone know how to take a table-level backup in SQL Server 2008? Can we use the backup database command? Thank you!

    ITKE978,235 pointsBadges:
  • SQL database is crashed

    Hello, Our server was hit by some unknown virus which seems to have corrupted header information for many of our files including an important databases and some of its backups. However the log file (.LDF) for the live DB was not affected. We also have a relatively old .BAK backup file. Is it...

    morrisonn5 pointsBadges:
  • How I can do a row ID in SQL Server

    Hi, excuse me, I want to do some ask for you. How I can do a row ID in SQL Server because I need a row ID CE517DED-7A39-48B0-85BD-73B95018FACB. Because in Oracle I know than this is possible, but in SQL Server, I don't know. I hope you can help me please.

    LuisFer5 pointsBadges:
  • Exporting VB6 data to PDF using SQL select query from MS Access

    Hi my name is vishal. I think I have a problem in exporting VB6 data to PDF using SQL select query (join query from multiple tables). I have a form in which when user selects a GRNno from combobox and then press button with caption: Generate it should generate a PDF report regarding GRNno. Given...

    Ametuer30 pointsBadges:
  • SSRS print button not showing in Firefox

    I'm currently using SSRS and it's working great but there's one issue - The print button is not showing in Firefox. It's showing in Internet Explorer but I don't want to use that. Can anyone help me out?

    ITKE978,235 pointsBadges:
  • Sending an email alert to addresses in the database and getting a return email as notification

    Dear Sir/Madam, I have this PL/SQL Store Procedure that sends out email with query result in HTML table format to email addresses in my database but I want to be notified what was the data send to each customer email every time a email is send. Can anybody help me with how to get this done?

    ADagoseh25 pointsBadges:
  • SQL query for customer’s data

    The owner of the shop would like to see each customer's id (name the column cus_id), name (name the column cus_name) id of their latest purchase (name the column latest_purchase_id) the total quantity of all flowers purchased by the customer, in all purchases, not just the last purchase (name the...

    Shruti16095 pointsBadges:
  • SQL Server statement

    The table name is students and the column name is ID contains 1 2 3 4 5 6 7 I want to know the statement should proceeding till 5 and it should be false at 6 and go to again 1 (i.e. without do while....and go...condition). Please!

    sabariram5 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