• SQL multiple files

    On our iSeries I need to find out if fld01 or fld02 or fld03 in file "C" contains a value that is obtained from file "B" using a value from file "A". How would I do this using SQL?

    Floyd02320 pointsBadges:
  • Using Case Statement Inside SQL Join

    Hi, I am trying to convert dynamic sql into static sql due to permission issue, I faced a challange when i am trying to convert this part of code given below -- join to ADDR_DETAIL SET @join_sql = 'inner join ADDR_DETAIL on ADDR_DETAIL.GRP_CONTACT_ID = pm.GRP_CONTACT_ID AND ' IF (@ChannelEntity =...

    Bmdayal5 pointsBadges:
  • maxdop hint

    I have encountered the bug with MS and the processor issue with Mutlitple processors, the solution is to put the MAXDOP hint. SInce I have never used this and all the MS KB say to use it but not where and how, what is the proper syntax. ( I have a dual processor quad-core new dell)

    tcstl95 pointsBadges:
  • Tagged text in Windows to be inserted into Db2 Clob column on Mainframe

    I have a string-combinatino of rich text and tagged test: ex: "test msg <p><STRONG></P>" on Windows machine. How i can insert data 'AS IS' without any data loss into a Db2 clob column. Db2 is residing on mainframe and we are using Db2 version 8.

    Narayananv5 pointsBadges:
  • Daily trigger in SQL

    I'm trying to create a trigger to execute daily and calculate a few averages for me. Please help!

    Barend IT15 pointsBadges:
  • SQL (Oracle) Date Constraints

    Can someone tell me how to create a constraint to prevent entering a date prior to 1 Jan 2007? I am tryin g to do it in a create script. Thanks Lock

    Lock10 pointsBadges:
  • C#.Net

    Does anyone know of a good place to find people with C#.net experience besides the big job boards? We have several positions in the Financial/Trading industry in Chicago but we are having a hard time finding enough people with this skill set. Any Blogs, User Groups or Niche Sites you can recommend?...

    Cmcwag0 pointsBadges:
  • ms sql case statement

    I have written a case statement in MS SQL that is returning a single phone number for a single id. This is valid as the database contains multiple phone numbers attached to the same id number, with differentiation based on phone type. Once I have found the prefered phone number, I do not want to...

    Espqueen5 pointsBadges:
  • SQL Right Trim Nulls

    How can I trim any trailng nulls from a selected record set. I have a table with up to 17 cols that I need to extract data from which included all embedded nulls but no trailing nulls

    Tim442025 pointsBadges:
  • Using SQL and given a table X with columns labeled A, B, C, and D -how do you get the count where column A = ‘TREK’

    Using SQL and given a table X with columns labeled A, B, C, and D - how do you get the count where column A = 'TREK'?

    Shellken6940 pointsBadges:
  • Using SysObjects Table

    I have a database that I need to know what tables are in it and also what views. I also need to know what tables are used in the views. Is this possible with the Sysobjects table? Any help would be greatly appreciated. TIA SQL Newby

    Gdckboyer20 pointsBadges:
  • Why is the query using the index even though the perecentage of unique values is 52%?

    I have a table with no primary key and a non-clustered composite index of two columns. When I look at the number of distinct values (selectivity ratio), the table has a ratio of 52% unique values. I thought an index should be at least 90% unique in order for it to be used. Yet when I run the query...

    Abbi20 pointsBadges:
  • SQL MERGE

    I have a view like below generated from my time and attendance software. staffNo EmployeeName title TransactionType Cdate time 556 JOHN WEB DEVELOPER IN ENTRY 24/01/2008 13:47:30 556 JOHN WEB DEVELOPER OUT ENTRY 24/01/2008 16:38:33 556 JOHN WEB DEVELOPER OUT ENTRY 24/01/2008 16:40:03 556 JOHN WEB...

    Binu.emiliya10 pointsBadges:
  • RPG with Dynamic SQL Problem – SQLCOD 501/312

    I'm trying to do simple dynamic SQL in a program to select records for a subfile but it doesn't seem to be working. sSql = 'SELECT orderno FROM ordhdr ' 'WHERE custno = :scSrchCust '; following this I have: exec SQL CLOSE @Orders; exec SQL Prepare Stmt from :sSQL; exec SQL Declare @Orders SCROLL...

    MMAGuy85 pointsBadges:
  • rows to columns

    I have a table containing answers from different forms. the forms are created dynamically so some forms will have 3 answer fields, some will have as much as 20 answerfields. ex : form_id field_id unique_id field_value 1000 631 1 john doe 1000 632 2 washington 1000 633 3 john@ws.com 1000 631 4 anny...

    Aabbccddee25 pointsBadges:
  • ROW_NUMBER in SQLServer

    In Oracle, I can use the analytic ROW_NUMBER function to assign sequence numbers to output rows, re-starting the sequence as certain values change (e.g., there's a separate count for each deptno in this example:) SELECT deptno , ename , ROW_NUMBER () OVER ( PARTITION BY deptno ORDER BY ename ) AS...

    FrankKulash1,240 pointsBadges:
  • SQL Server Schema Best Practices

    I am in the process of establishing a "sandbox" database for a mix of users with SQL development skills. I have done this before with Oracle but not with SQL Server. What I would like to do is build a database whereby each user has their own play area. We are running SQL Server 2005 so I thought of...

    MortimerSchnurd0 pointsBadges:
  • SQL 2000 to Yukon Migration

    We have 4-5 applications on the front end of a portal. On the backend we have mapped these applications to SQL server 2000 Databases. Now, we are planning to migrate on the backend databases to Yukon and map it to the application on the front end. My question: Is it possible to use Yukon for one of...

    Kilaru0 pointsBadges:
  • SQL Packages

    I have a query on SQL packages.Is it necessary to create an SQL package every time we connect to a remote system?Is there any other alternative?

    Sweta30 pointsBadges:
  • Query Criteria

    Hello. I have a report with multiple subreports. User enters date range when prompted from query in main report. I want to refer the subreport date criteria to the date range the user enters for the main report, via the query. I used this in the query criteria under the date...

    Bec10 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