• SQL concatenate results

    Hi Need help here:-  I am running this sql on business object and when I prompt for the Outlet Code, I need the results to automatically add in the % on the result field like the one in the example. How can i do this? SELECT FDDWHD20.DCOUT1, FSDWHE01.FSSHIP, FDDWHD20.DCNAME, FDDWHD20.DCMKDS,...

    devan390 pointsBadges:
  • Passing an array parameter from crystal reports to a sql stored procedure

    Hi All, I am having a problem in Crystal Reports with an array parameter. The user can select one warehouse code or multiple warehouse codes. I just need to display the detail from each warehouse selected (one, multiple or ALL). Right now I'm getting duplicates. I'm not sure how to set this up in...

    Jeager6640 pointsBadges:
  • SQL statements question

    I have an accounts ENTRY table with many fields like (ac_bal, ac_id , ac_date, ...etc) and I want to retrieve the summation of each account in each month as seen in the table below. 10-01 21-04 02-11-4 ..... jan Feb mar . . . Etc. Can anyone help?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Help with embedded SQL in RPG. Dang thing hates the delete statement?

     H OPTION(*NODEBUGIO:*SRCSTMT)                             *******************************************************  FWRLDSHP   IF   E             DISK                       FWRLDSHP1  O  A E           K...

    nitzinger385 pointsBadges:
  • Would like to learn SQL. Which vendor should I go for and what certification should I get?

    Hi All, I would like to learn SQL but was wondering shich SQL package should I go for? I am looking for emplyment in the finance industry as an analyst and thus looking for the right SQL package to learn and get the right certification. Could somone please advise me accordingly. cheers! Jeevan

    Jeevan231015 pointsBadges:
  • un-format object viewer sql tab

    Hi experts, Can someone tell me, how can I turn off automatic code formating on the Object viewer's SQL tab (i.e. the sql code in the SQL tab of an opened view is automatically formated compared to the code I used to create it) Thnx in advance for yr answers

  • Complex SQL query in SQL Server 2008 tables

    Sir, i have 2 tables , first table column one is 1,2,3,4, and column two is x,y,w,z and second table  first column of 1,2,3 second column is (1;2),(1;2;3;4),(2,4), i wand to display the result as in first colum 1,2,3 and second column as (x,y),(x,y,w,z),(w,z) please help me in this regard

    Itoracle5 pointsBadges:
  • SQL Server 2005 Enterprise Edition SP3 Performance

    We have SQL SERVER 2005 SP3 Enterprise 32-bit running on a windows server 2003 Enterprise 32-bit with 32GB of RAM and 8 dual core processors. Our CPU, RAM, and I/O are always through the roof and the application is always running slow. We use AWE for buffer cache the maximum memory is 28GB, the...

    Rick Martinez585 pointsBadges:
  • Oracle opportunities

    I completed my B.E in 2009, so I want interested to go to oracle side, so I know the concept of sql and pl/sql. Relating to this I dont have a project of this. So please give me some titles of project atleast I can go through this.. regard@sadashiv

    Ingalagi5 pointsBadges:
  • SQL in CLP

    Hi, I have to create a command that permits a user to copy records from one file to another and then remove those records from the first file. We've been doing it all manually using CPYF and INCREL and then deleting the records using an SQL Delete statement. I got the idea to create a command and...

    Floyd02320 pointsBadges:
  • VIEW_TABLE_USAGE SQL 2005

    In MS SQL 2005, when I select * from VIEW_TABLE_USAGE, I get incomplete results. At least one object that is used in at least one of the views is not listed. View "PTP__MARA_MARC" uses two tables and one view, but VIEW_TABLE_USAGE only lists one table and one view.  Can you please help?

    44444Dave5 pointsBadges:
  • SQL and Dates

    Can someone date a look at this SQL and recommend a cleaner way to go about this? [BMDTOR is a date field in the file stored as CCYYMMDD] SELECT (DAYS(CURRENT DATE)-DAYS(SUBSTR(BMDTOR,5,2)||'/'||SUBSTR(BMDTOR,7,2)||'/'||SUBSTR(BMDTOR,3,2)))/30 AGE,...

    jschultz385 pointsBadges:
  • Recursive Association with compound primary key in SQL database

    Hello, I'm afraid I'm very new to this and really struggling. I have a table with a compound primary key composing of Code, Date, Client to represent an attendee on a course. I need to include a 'Lead Client' column to represent a recursive relationship where one attendee can be nominated to lead...

    Littlegreen15 pointsBadges:
  • SQL Server Plan Cache

    There is a bucket in plan cache with 75 objects in it and it is the same sql statement. Other than using DBCC FREEPROCCACHE what will clear out the cache? Restarting SQL SERVER Service? I use the code below to look up how many plans are in a bucket. SELECT   bucketid,   entries_in_bucket =...

    Rick Martinez585 pointsBadges:
  • When using IfNull in my SQL, records are ignored

    I know my data table has nulls in it. If my select statement doesn't include those fields, I get hundreds of records. If I include those fields with an IfNull, it skips all but 4 records. Here's my testing snippet: C/Exec sql C+ DECLARE C1 CURSOR FOR C+ SELECT C+ accountID, C+ ifNull(address,' ')...

    Frydaze120 pointsBadges:
  • Is it possible on iSeries that an index is defined keeping in mind an sql select criteriea however when the queryis run this index does not get used.

    Is it possible on i series that an index is defined keeping in mind an sql select criteriea however when the queryis run this index does not get used. We had an issue wherein an entire library had to be cleared and all files from had to be restored from a previous backup, after the backup was...

    JohnsonMumbai1,160 pointsBadges:
  • Two SQL server synchronization

    How can I merge two SQL Server databases? One sql server is in web  and another in local machine  both sql servers will have daily data transactions entries. how to merge those daily data transactions between the two sql server?  i am new to sql synchronization and merging. could you kind...

    Qqqqqqqqqqqqqqqqqqqq20 pointsBadges:
  • Value of() in SQL Server?

    what is the equivalent statement of valueof() of oracle in sql server?

    Prcvjr220 pointsBadges:
  • Date conversion (to_char) behavior

    Hi everybody. We are experiencing a strange behavior with a "to_char" conversion: We are using Oracle 8i and Developer 6i. An application need to know the day of the week (number of day) of a given date, and we are doing that with "to_char(given_date,'D')". This returns a 1 for sunday, and 7 for...

    carlosdl69,045 pointsBadges:
  • Problem with ++ string operator in VB.NET

    command3 = New Data.SqlClient.SqlCommand("UPDATE Products SET Stock=" + numU + " Where ProductName='" + proName + "'", connection3) At the code snippet above, numU is integer and when i execute it in insert at sql server as a double so it throws me an error and says me that its a double and you try...

    Tonis3x5 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