Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by wfairban

  1. wfairban

    DTS Question

    I am exporting data to an excel spreadsheet. It is putting the data in a 4th sheet. How do I export the data into the spreadsheet on one and only one spreadsheet? The data is not too large for one spreadsheet. Any help would be greatly appreciated! I am stumped~~!
  2. wfairban

    DTS Transformation Question

    I would like to transform the data to html output. What VB code can I put in the transformation section of the DTS package? I am exporting the data to .xls currently but I need it to export as .html. Any help would be greatly appreciated. Thanks!
  3. wfairban

    Query to increment by 1

    Could you elaborate? I would normally do this in Oracle with a cursor.
  4. wfairban

    Query to increment by 1

    I need to increment by 1 for each record added. There are over 60,000 records I need to add. Any suggestions? If I do this INSERT INTO PRODUCTSBYCATEGORY(productid, categoryid, sequence) (Select productid, 8, (select (max(sequence) + 1) from productsbycategory where...
  5. wfairban

    Query assistance

    Sorry I did not see the rest of the query. I am trying it now.
  6. wfairban

    Query assistance

    I think you are understanding what I am saying now but I don't want to insert anything into the table. I would like to determine if there is anything in the test table. Once a requirement has been created a test can be run on it. I would like to see which requirements have not had a test run on...
  7. wfairban

    Query assistance

    Ok here it goes. REQ -- table RQ_REQ_ID (PRIKEY, INT) 1, 2, 3 RQ_REQ_NAME -FR002, FR003, FR004 REQ_COVER -- table RC_REQ_ID (PRIKEY, INT) 1, 2, 3 RC_TEST_ID (PRIKEY, INT) 1,2,3 RC_STEP_ID (INT, NULL) RC_ORDER_ID (INT, NULL) Test --table TS_TEST_ID (PRIKEY, INT)1,2,3 TS_NAME (VARCHAR, 255)...
  8. wfairban

    Query assistance

    George, I would like to see the results being all requirements without Test Cases associated with them. For example, I have a table called requirements with field B. I have a table called test with test case (ts_name). For every requirement there is not always a test ran on it. I would like to...
  9. wfairban

    Query assistance

    I am needing some assistance with a query. I would like to pull all requirements from the td.req and td.req_cover table that do not have test cases associated with them Here is my query. I would like for it to do the exact opposite. Select RQ_REQ_NAME,RQ_USER_07,RQ_USER_11,TS_NAME,TS_STEPS...
  10. wfairban

    SQL Script to append data to column"X"

    Ok that worked great. Now I have another issue. Spreadsheet has 2 columns: A = xnum and B = xnum + -E. Database has a field in various tables called pnum. I need to update pnum with all xnum from column A = pnum in db then add -E on it. I hope you are not as confused as I am..............
  11. wfairban

    SQL Script to append data to column"X"

    Currently I have column X in table A,B,C,D,etc. I need to append a "-E" on the end of all rows in Column X. What is the easiest way to do this?
See more

Part and Inventory Search

Back
Top