• ‘m trying to verify that a SQL DATABASE is empty ,

    I am modifying a VB program that is taking ALL the tables from an ACCESS Database and converting them to a SQL DATABASE. They VB Program opens the SQL DATABASE, but I want to verify the database is completely empty. Is there a function or call that can be added to the code??

    MAB TRIBEFAN5 pointsBadges:
  • using a local variable to build an sql-statement beyond datatype nvarchar(4000) and execute with sp_executesql

    I build a sql-statement and put it in a local variable so i can execute it using sp_executesql, but a local variable cannot be a text or ntext data type, and a varchar data type cannot be used by sp_executesql. So the maximum lenght of the statement cannot be more than nvarchar(4000)... is there...

    Aabbccddee25 pointsBadges:
  • Accounts payable records search

    I'm trying to pull up information from an accounts payable database. I'm looking for amts paid that are the same and greater than one & vendors paid that are the same - where the amounts paid were on different check numbers. Any advice? Table contains these fields: VendorNumber, PONum, AmtPaid,...

    Vincevaughn75 pointsBadges:
  • migrating from foxpro to SQL7.

    Hi All, I have around 95 tables on FoxPro that I need to migrate on SQL7. These tables are stand alone data tables and are not part of any database as of now. I have tried exporting these tables into XLS format and then importing these tables to SQL7 using enterprise manager but there are certain...

    Namitgrover5 pointsBadges:
  • SQL Query that only Returns the Newest Invoice date for an ITem

    I am try to write a query that will give me a list of ITems that have a a quanity of greater than 0 on hand and only latest date and Item was invoiced. Here is what i have come up with so far SELECT IV00101.ITEMNMBR, IV00101.ITEMDESC, IV00101.CURRCOST, IV00102.QTYONHND,SOP30200.SOPNUMBE,...

    Ken Foster20 pointsBadges:
  • how to insert 1940 length char type field to a 1024 length longchar database field

    how to insert 1940 length char type field to a 1024 length longchar database field in ecc 6.0 unicode system without changing field length in the database WA-MANDT = sy-mandt. WA-BUDAT = SY-DATUM. WA-SERIALNO = '00007865'. WA-REGISTER = 'ABCd'. WA-EXGRP = 'ABc'. WA-KEYID = 'ABC1234'. WA-USNAM =...

    Abrao5 pointsBadges:
  • retrieve NOT related data many to many relation

    I have 3 tables. one of the tables is a linked table, so it contains the primary key from table 1 and primary key from table 2 as foreign keys. together they make up the primary key for the linked table. Now i need to find out which items are not in the linked table. example : table A contains...

    Aabbccddee25 pointsBadges:
  • OUTPUT query

    hi i have am osql script (.cmd file) with 80 line query in it , i run every 1 hours once. i shedule in o/s through task manager. i want the output in different xls every time ie: first xls for first hour second xls for second hour ........ till the last hours that is for hours thanxs

    D1972125 pointsBadges:
  • DDS or SQL

    We have an existing COBOL application using files defined in DDS format. We are considering to move from DDS to DDL for future development. What is the best strategy to take this approach?

    Uiiuo50 pointsBadges:
  • sql question on autogenerating customer numbers

    I want to create a table that automatically assigns a customer number to every email address that is entered into a table.

    Triciameza10 pointsBadges:
  • sql-programming the ‘in’ statement

    I'm working on a task ; the issue is: There are number of criteria for each category; the relation between the criteria's is OR and between the category is AND. The CSR can select number of criteria for each category (or not select anything); I supposed to get as an input all the selected criteria...

    ADBA5 pointsBadges:
  • HOW TO INCLUDE LOG IN INFORMATION IN AN SQL SCRIPT

    Please I have an SQL update statement which I want to put in an SQL script which users can run to update an oracle9i database running on a windows 2003 server.The statement is as follows: update jobs set JOBSTATE = 3 where APPID = 5 ; COMMIT; Exit I do not want users to be opening the script and be...

    IdongesitDaniel5 pointsBadges:
  • Comparing column values in different rows.

    sample table: A B C D E F G 1 d 3 t j 0 e 2 0 l o e p d 1 d 3 t k 0 f Ok, so in the table, column A should be unique. As you can, see row 1 and row 3 have the same value in column A. However, they differ in columns E and G. A quick aside, this is a metadata table, where column A is the key back to...

    Rcn3c5 pointsBadges:
  • How to use subselect in a case statement

    Getting error... "Token EXISTS was not valid...." on case statement... ,case when g.GFGSTS = '2' and not exists (select a.GFTSEQ from GFTP010 a where a.GFCSQ# = g.GFCSQ# and a.GFGSTS = '3' ) then count(*) end as Void#

    Qpgmr5 pointsBadges:
  • Trouble getting a count with union statements

    How do I get a count from unioned statements, then subtract some of the values from a sum of the others? For example, say I have a table called EMPLOYEE, and I want to see how many more male employees I have than female employees. Therefore, I want: COUNT(*) WHERE EMPLOYEE.GENDER = 'M' - COUNT(*)...

    JimmyIT1,725 pointsBadges:
  • DTS error after deleting xls file with script

    All, After I have deleted a xls file using an ActiveX script the DTS Package fails because the file is not there. I then have to go into the properties of the task and go to the destination tab and click the create button. The I have go to the Transformation tab and then run the package for it to...

    Gdckboyer20 pointsBadges:
  • How to update in SQL using DS

    My problem is that I’m basically doing an interactive update/create file (similar to DFU). The user is able to maintain a file in the screen, so how do I go about updating the ENTIRE File without having to manually update every record? I have a datastructure (cpRec) to put in the info from the...

    MMAGuy85 pointsBadges:
  • SQL and CL

    I would like to learn more about putting SQL in CL and RPGLE. What is a good way to learn about this?

    Popers40 pointsBadges:
  • Cursor using update and order

    I'd like to declare a cursor to traverse a file in keyed order, updating some records It looks like I can do one or the other, but not both, that is I can set up the cursor with the order phrase or the update phrase buy not both. Is there a reason for this limitation? ec/exec sql c+ declare...

    Unknowingone195 pointsBadges:
  • Need help with running an external SQL query from within VB.Net code.

    Hi all, I'm in a bit of a bind and new to SQL. I have built a DB using the SQL Manager and it works perfectly in my code. I have used SQL Manager to build the SQL to rebuild my DB as I want to use it in my VB.Net code. When I execute this SQL in the SQL management studio it works 100 %. When I...

    Comtrendz5 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