• What effect will changing system date have on Exchange/Blackberry?

    We have Windows Small Business Server 2003 with Exchange and Blackberry installed. SAP Business One and SQL are working smoothly. Now we want to change the system date from the last three months back for some upload work with SQL(SAP). If I could change the date, would my server continue to work...

    0 pointsBadges:
  • How do i replace a sql tables field value with another value

    I have the following script that works in Access but not in sql. I trying to replace the the value in the field "RSAMSTORE" with another value I give it (i.e. 999994, etc.) when the data is displayed. In otherwords when the select distinct is ran instead of seeing the value in the table "RSAMSTORE"...

    Ilfoprog50 pointsBadges:
  • Receiving an error consistently in SQL

    I receive the following error constantly in SQL: "Notice: Use of deprecated function sql_query in /var/www/html/includes/sql_layer.php on line 43 Notice: Use of deprecated function sql_fetch_array in /var/www/html/includes/sql_layer.php on line 64" It repeats over and over, and I am not sure how to...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Automation of SQL Report

    Hi, I need to automate a certain report which we take from 2 different databases and paste the data in the Excel and send it to certain email IDs? can someone help me??

    Ramesh63635 pointsBadges:
  • How to sent SQLMAIL in SQL Server 2005, through SSIS job, when my particular field is updated in database, can we sent SMS also through the SSIS script.

    How to sent SQLMAIL in SQL Server 2005, through SSIS job, when my particular field is updated in database, can we sent SMS also through the SSIS script.

    Deepanshu35 pointsBadges:
  • SQL DB2 COBOL date reformatting

    Hi and thanks in advance, I want to use DB2 SQL in COBOL to reformat a date from CCYY-MM-DD to MM-DD-YY. What is the simplest and most efficient way to do this? Christy

    Ctrevino10 pointsBadges:
  • Catching an uncaptured error in SQL

    This is a batch of SQL code I’ve been using: BEGIN TRY begin BULK INSERT DBXMRPAS2.dbo.[STG_drive] FROM '\Wdmyitpxmdev1xmmsbcpcsvfile20080715drive.200807151100.extracting' WITH ( MAXERRORS =1000, FIELDTERMINATOR = '^', ROWTERMINATOR = '|n' ) end END TRY BEGIN CATCH SELECT 'Error Caught'...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Getting the number of a row from a flat file source in SQL

    How might I get the number of a row from a flat file source with a script component in SQL?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Crystal – number of printed pages based on database field

    I'm relatively new to Crystal Reports, and most of the reports I’ve written are in Ver 7.0, I do have Ver 11, I have not done much with it yet. I have a Crystal Report that is used to generate a shipping label from a packing list in SQLBase. Most of the packing lists have more than line one item,...

    Flame14,925 pointsBadges:
  • SQL: Using a column created in the SELECT in the WHERE CLAUSE

    Can I use a column in the WHERE clause that I created with 'AS' in the WHERE clause. I have tried and SQL tells me that the column is not in the table? Thanks, Ray

    RayT30 pointsBadges:
  • Explaining certain functions in SQL

    What do the MOD function and the ROUND function do in SQL?

    SQL Server Ask the Experts2,585 pointsBadges:
  • 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:

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