Recent content by wfairban

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~~!

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!

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

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...

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

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...

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)...

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...

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...

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..............

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?