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

  • Users: lhrpa
  • Order by date
  1. lhrpa

    Training Seminars

    Great info in this thread, thanks! I'm trying to track down some desktop type training, like CD or DVD, for sql server 2000 administration, no going to classes for us! Any suggestions? Thanks! Linda
  2. lhrpa

    Want to change connection string in Excel query

    Hello there! I have a workbook that pulls data from a SQL Server 2000 database using several different queries for different parts of the workbook. I built the queries using the "New Data Query" option in Excel and I have the query properties set to refresh on open. Everything works...
  3. lhrpa

    Autofill method of Range Class Failed

    That did the trick - thank you!!! You made my day!! Linda [sunshine]
  4. lhrpa

    Autofill method of Range Class Failed

    Help (again!) I'm trying to autofill a column of data with a sequence number. I can find the range I need to fill no problem (thanks to the wonderful FAQ section :-) ), but for some reason I'm getting an error on my autofill. Any suggestions? Thanks a million! Linda Sub fillit() Dim...
  5. lhrpa

    Save copy of spreadsheet after refreshing data from SQL Server

    I added that to my macro and it worked like a champ! Thanks so much!! Linda
  6. lhrpa

    Save copy of spreadsheet after refreshing data from SQL Server

    Hello there! I have a spreadsheet that on file open will refresh data from SQL Server into the spreadsheet. I want to be able to save and keep that data in a spreadsheet as of that point in time. If I do a "Save As", it of course saves the spreadsheet with the queries, and then the...
  7. lhrpa

    left pad a column with zero

    Thanks, you both were a big help! I ended up combining both of your tips,and used this in my insert stmt: insert into mytable (cola) select REPLICATE('0',12-LEN(colb)) + CAST(colb) AS VARCHAR(12)) from inputtable colb is numeric in my input data. Thank you again! Linda
  8. lhrpa

    left pad a column with zero

    I need to load a numeric column into a varchar(12) column, and I need to left pad with zeros. The numeric values could be of varying lengths from 5 - 11. For example, a 12345 from my input data file needs to look like 000000012345 once loaded into the table column. Does anyone know a good...
  9. lhrpa

    Determine last day of the month

    Thanks, that's perfect! I'll also check out the other thread. Thanks a lot for your help, Linda
  10. lhrpa

    Determine last day of the month

    I would like to be able to compare a date within my data to the last day of the previous month, is there a last day function of some sort in SQL Server? Thanks for any guidance! Linda

Part and Inventory Search

Back
Top