Continue to Site

Eng-Tips is the largest engineering community on the Internet

Intelligent Work Forums for Engineering Professionals

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

Search results for query: *

  • Users: dba123
  • Content: Threads
  • Order by date
  1. dba123

    Cannot connect to Database in Server Management Studio

    THIS IS DRIVING ME NUTS!! I currently can't connect to my database in SQL Server 2005 (enterprise) but as soon as I try to use any functions, I get cryptic errors found below. I am about to pull my hair out. Everything was working fine for around 4 days and now everything just blows up. I've...
  2. dba123

    Need help splitting out columns for each row into new table

    Let's say I do a select statement and the results are Acct # Zip Phone Addr 11223 23232 333-444-5555 6556 Duns Rd. 12345 34343 222-444-3333 1000 Aspire Blvd. I need to create a record using the Acct # and column for each column as well...
  3. dba123

    Loop through each record and then each field within each record

    I need to essentially do 2 loops. One loops through each record and then inside each record row, I want to perform an insert on each column. Something like this maybe using a cursor or something else: For each record in my table (I'll just use the cursor) For each column in current...

Part and Inventory Search