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: dreameR25
  • Content: Threads
  • Order by date
  1. dreameR25

    SQL View output to Excel

    Hi guys, Could someone help me write some code that would allow me to list the names of SQL Server queries in an Excel datasheet then press a button which would then load the content of each view in to a new datasheet? I've been surfing the web for help for the last 4 hours and have found...
  2. dreameR25

    Excel VBA - Help!

    Hi all, I am completely new to VBA and I need to do the following task pretty urgently. A spreadsheet called Work containing columns A, B, C, D and E. I need to reformat the spreadsheet so that only columns B, C and E remain. I know I can delete the columns but I want some sort of utility...
  3. dreameR25

    Selecting min(date)

    OK.... I will try and explain this as best as I could. I have a table consisting of two columns, member_key and a date. Each record is unique combination of member_key and a date. I also have a second table which hold multiple records for each member_key. For example, Table1 Member_key |...
  4. dreameR25

    Index problems

    Hi there, I have a table of 8000+ records but when I try and do a simple update such as, update bpd set title = upper(title) it takes a very long time.. in fact it took 1 minute to update 4 records, so at that pace it would take over 30 hours for the whole set of records. I tried creating an...
  5. dreameR25

    Number sequence...

    Salute, Say I have two columns consisting of MEMBER_KEY | SURNAME with the SURNAME column populated and the MEMBER_KEY column with NULL values. How do I populate the MEMBER_KEY column with values ranging from 1 to 250 for example.... Thanks.
  6. dreameR25

    .csv file to SQL server

    Hi there, I have a .csv file containing 65536 records. I want to transform the data into an SQL server table using a DTS package. Any advice on how to do it as I am new to SQL Server. I have SQL Server 2000 and I am using windows 2000. Regards. Cres.

Part and Inventory Search

Back
Top