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 Mike Lewis 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: *

  1. waddies

    DTS Permissions problem

    I have a DTS job which has 2 steps. Step1. Generates an Excel spreadsheet on the server. Step2. Tries to rename the Excel file to something else using the following VBScript code in an ActiveX. sSourceFile = "\\servername\foldername\filename.XLS" sSourceFile2 =...
  2. waddies

    Select Stored Number of Random Records without Using Cursors

    Thanks anyway James.
  3. waddies

    Select Stored Number of Random Records without Using Cursors

    Thanks James, That works. However it only works when you specify the values for @qtype & @qgrade. What I'd like is something which would process all the records in the Matrix table at the same time. Would a possible answer be to put your code in a user defined function and call it from a...
  4. waddies

    Select Stored Number of Random Records without Using Cursors

    I hope someone can help, tblMatrix QuestionTypeID QuestionGradeID Quantity 3546 1261 2 3548 1262 3 3548 1263 1 tblQuestions QuestionID...

Part and Inventory Search

Back
Top