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

    DTS Script, Array problem

    I am writing a script that is getting used a DTS package for SQL server 2000. The VBScript parser is hanging on the following snippet, specifically the first line. Parsing error, expected ')'. Anyone have any ideas? Maybe my syntax is way off, I'm a bit rusty... Dim aryPCOLevel(0 To 2) As...
  2. nollieflip

    Update query taking forever

    I have the the following update running and it seems to be running too long. I've let it go 20 minutes and it still hadn't finished. It updates about 45,000 records. UPDATE BuildAccount SET EmailAddress1 = (SELECT EmailList.EmailStandard FROM EmailList WHERE BuildAccount.AccountNumber =...
  3. nollieflip

    Update problem

    Worked perfect. Thanks!
  4. nollieflip

    Update problem

    I need to update a column that I did not originally populate on the first pass of my DTS script. In my DTS I needed to combine our accountid's and account locations into one string. The problem now is how to write a update statement and the source data has the id's and locations still...
  5. nollieflip

    Update statement help

    I need to update a column that I did not originally populate on the first pass of my DTS script. In my DTS I needed to combine our accountid's and account locations into one string. The problem now is how to write a update statement and the source data has the id's and locations still...

Part and Inventory Search

Back
Top