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 TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: wfairban
  • Content: Threads
  • Order by date
  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

    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...
  4. 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...
  5. 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?

Part and Inventory Search

Back
Top