• Join for merging records

    I'm trying to figure out what the best type of join I could use in TSQL for merging records in about 6 tables where there is a match. So I have 6 different tables where there are many matching records. So I figured that I would use a left join in my first join, keep those records that were matched...

    Eabouzeid175 pointsBadges:
  • Sponsor Post: Secure End Point Live Expert Chat – Tomorrow @ 11am ET

    Join this expert chat tomorrow, July 13th from 11am-2pm ET, to learn how Microsoft Forefront solutions protect client and server operating systems from emerging threats and information loss, while enabling more secure access from virtually anywhere. Click here for reminder email to access the...

    ITKE347,940 pointsBadges:
  • Linking Lists in SharePoint

    I have 3 lists, A, B and C. A has data x, m and y as columns with 500+ records, B has data x and z as columns and C has data z as columns. I need to link A, B and C so that I may add all data m and y colums and place them under heading z.

    KristinaB5 pointsBadges:
  • Sponsor Post: Cloud Migration Pros and Cons Live Chat Today

    Today's live chat from 1-3 pm EST provides an exclusive opportunity to get your cloud migration questions answered directly from industry experts. Get tips on how to improve your ability to recover in any type of loss or disaster while keeping your budget in check and gain insight into: Data...

    EmNichs3,250 pointsBadges:
  • Index with page numbers in Access

    We have created a form that we use for a directory in Access. We have created an index as well, but how can I add page numbers that correspond to the correct person/record?

    Celtyshan5 pointsBadges:
  • Oracle-developers

    WHILE ASSIGNING A VALUE TO PROCESSED_TIME=:NEW.JMS_TIMESTAMP-:NEW.INS_TIME (All are timestamp type ) how to subtract that one.  CREATE OR REPLACE TRIGGER SAUUSER.TRG_MSGES_STATISTICS AFTER UPDATE OR UPDATE ON SAUUSER.TSAU_PRE_MSGES REFERENCING NEW AS NEW OLD AS OLD FOR EACH ROW DECLARE BEGIN IF...

    RizwanSharief30 pointsBadges:
  • the gateway will not transmit the Mac address of my wireless devices connected to it.

    I am setting up a corporate WiFi hotspot. (Internet)--Router---Dell 2650 Server with hotspot software---Mesh corporate network system. The issue I am having is that the gateway will not transmit the Mac address of my wireless devices connected to it. It sees any device that connects to it as having...

    Komputerguy15 pointsBadges:
  • How can I transfer a file from th as/400 to my documents as a csv file using client access?

    How can I transfer a file from th as/400 to my documents as a csv file. When I try to copy now I get a a bit map file with using 40 for blanks. I'm trying to use client access to move the data.

    nitzinger385 pointsBadges:
  • Setting up a field to store .png file in Access 2007 Database so that it can be merged with Word document

    I have an Access 2007 database that includes a company logo( .png file) field.  I have set up the field as an "attachement" data type and I have also tried OLE data type.  The problem is that when I use the database as part of a merge with a Word document, the logo does not display.  Only the...

    TDrotos5 pointsBadges:
  • DB2 / ODBC file availability

    We have a new web app that we want to be able to run 24/7. My question from our web staff is  "when the data is available? ". There are 2 situations I can think of that will pose an issue. 1. when we are running file back ups, it most likely will not be available due to object locks. We could do a...

    ToddN200011,820 pointsBadges:
  • JDBC connection to DB2/400

    Hi, We have application which runs on Java Server connects DB2/400 using JDBC connection. would like to know what is the maximumnumber of database connections supported on DB2/400 and how can I adjust this connection activity so that it is not impacting our application running on as/400 i.e. how to...

    rajsubhyd105 pointsBadges:
  • How can I write a SQL query to get the database name ?

    How can I write a SQL query to get the DB name ? Usually we use SELECT DB_NAME() AS DataBaseName, but at that time teh DB is in use. If we didn;t write use [dbname][/dbname], is there any way to get the DB name ?

    KulkarniMandar5 pointsBadges:
  • How to connect db2 to rad 7.5

    how to connect db2 to rad 7.5

    Paulsundarsingh40 pointsBadges:
  • JDBC Connection from JAVA to iSeries DB

    I have a simple class that resides on my local drive. I am attempting to connect to iSeries I5V4 environment and do "select" from one of the DB files. When I run my .class file in Rational Application Development I ghet a "class not found" exception. How do I set classpath in RAD? Should my...

    Lenny2113115 pointsBadges:
  • Export AS/400 to MS Access

    My auditor wants me to export files from my AS/400 to MS Access and I don't have a clue how to do that or if it can be done. I hope someone does.

    Dowagiac5 pointsBadges:
  • MS Access – AS400 file transfer

    I am trying to move data from a .dbf file to the AS400. I have tried several differnet methods from access and none of them worked. I tried setting up an ODBC table pointing to the as400 and doing an update query and also an export. I could not get either of these to work. One of them kept bringing...

    Ddune35660 pointsBadges:
  • Linking users of Access 2003 to SQL Server 2008 database

    We plan to go to SQL Server 2008. We need to link our Microsoft Access 2003 users to the databases created in SQL Server 2008. Will we be able to do this considering ODBCAD32 is what we use, and the databases we create will now be 64-bit?

    Mike8005 pointsBadges:
  • Changing over to DR database from SQL 2005

    I have set up log shipping from my production SQL2005 databases to my DR server and all seems to be working fine. On examing my DR databases they are all in (Restoring...) mode.  How do I now access my DR databases if/when my production system goes down?  There does not seem to be any obvious...

    Swales1015 pointsBadges:
  • ORA-00902 invalid datatype when trying to create a table with primary key based on two columns in Oracle 10g

    I was trying to create a table with primary key based on two columns. Here is the create table statement: CREATE TABLE SECURITY_PASSWORD ( USER_NAME VARCHAR2 (25 BYTE) NOT NULL, USER_PASSWORD VARCHAR2 (25 BYTE) NOT NULL, CREATED_DATE DATE NOT NULL, CONSTRAINT security_password_pk PRIMARY_KEY...

    Techguys90 pointsBadges:
  • In Microsoft Access is there a way to put IIF statement criteria into a table for easier management and reference?

    I have some data with a list of Product IDs and I want to assign the Product IDs a category name based the criteria below. <br><br> IIF Product ID = #*C#* then category name = Cable<br><br> IIF Product ID = 00#* or 497* then category name = Component<br><br>...

    As2301495 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