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

    Transaction log issues

    I have a table that I update in my database once a month. The data comes from a 7+ GB flat file I usually end up with well over 100 million rows in a table with 5 columns. My problem is that during this insert the transaction log blows up to over 100GB. After the insert I truncate the log. I...
  2. ehenry

    Bulk Import Issues with large files

    I am attempting to bulk insert from a CSV file to a table. The CSV is a 6GB file with 5 columns, I am unsure of how many rows are in the data, but it is over 10 million. Any Bulk Insert runs into an error "Attempting to grow LOB beyond maximum allowed size" Is there any other way to import...
  3. ehenry

    Select max update time for each ID

    I have a staging table with an update time column and an ID column. In the final table the ID is unique, but in this table there are multiple IDs with different update times. I need to select the Max Update time for each ID in the staging table to perform an update on the final table. What is...
  4. ehenry

    Freeze last row datagridview

    I have a datagridview I am trying to freeze the last row which contains totals. Using DataGridView.Rows[DataGridView.Rows.Count-1].Frozen = true; will freeze all rows, Is there a way to Just freeze the last row so it is always visible?
  5. ehenry

    Help with Aggregating based on Date

    I have a query that outputs three columns, [Date], [Type], and [Volume] over the past seven days. I need to SUM [Volume] with [Type] = I or [Type] = W for each date, so I would have 7 dates rather than 14. each of the 7 with two entries, one for I and W. Rather than this: |Date...
  6. ehenry

    Partitioning

    I have a View That contains a list of 200 Points with a Measurement date and a Volume associated with that date. I am selecting data for the past 5 days, but rather than having a table of 1000 rows i would like to have a 200 row table and 5 extra columns for each day. I was wondering if there...
  7. ehenry

    Help with Cursors and inserting rows

    I have a table that contains trade deals, there are some trades known as Strips that come in as one deal, however they need to be displayed as if they were multiple deals. For example a Jul-10 - Aug-10 Strip would show up as one row in the table, I need to display this as two rows with the same...
  8. ehenry

    Adding a Value of a previous row to the current row

    I have a table that holds some pricing data, there is a column that contains a settlement price. This table is updated continuously throughout the day, so I was wondering if there was a way to make a view that could select all the columns from this table, but for the Settlement column I want it...
  9. ehenry

    DataGridView Updating

    I have an application that links a datagridview to a table on a SQL Server Database. I have it set to refresh every 15 seconds. I was wondering if anyone knew of a way to check if the new values coming in were different than the values already there. The reason I ask is because I want to make...
  10. ehenry

    BULK INSERT FORMATFILE Help

    I am trying to use bulk insert to dump a bunch of CSV files into different tables. I am creating a dynamic stored procedure that takes in the csv filename and the table to insert to. Basically my issue is that some of the columns in the csv files have quotes around the values which I need to...
  11. ehenry

    Update Help

    I Have a table that contains Temperature data For a list of 230 Stations The table has a Station ID, a Date column, and an Avg Temp column with data in it. I have added another column to hold the 7 day trailing average, which is simply the average of the past seven days. Each day when new data...
  12. ehenry

    PDFMaker Help

    I am looking for a way to PDF some excel sheets with Graphs on them using vba. I was previously using the Microsoft Save as PDF and XPS and it worked fine. I use it for pretty much anything I need to make into a PDF, then one day with this particular file it started cutting off parts of the...
  13. ehenry

    ORDER BY

    Is there a method to ORDER BY a specific order. I have a table where I ORDER BY [Station ID]. I was wondering if there was a way to set the specific order of the stations. Ex. ORDER BY [Station ID] (1234,1235,1236,1237,1239,1238). Any help would be appreciated.
  14. ehenry

    HELP With Cursors

    I have a Cursor loop that performs a select statement 230 times for each Station ID I have. The select statement gets temperatures for Jan 1st over the past ten years for the current Station ID, Dumps it into a temporary table, then I take the average for Jan 1st over the 10 years and save it...
  15. ehenry

    Question about date formatting...

    I am trying to store the the the previous days date in a variable in the format 'MMDDYYYY' so I can use it as a portion of a CSV filename in a bulk insert statement. So far I have: SELECT @fdate = CONVERT(VARCHAR(8), DATEADD(day,-1,GetDate()), 112) AS [MMDDYYYY] I am getting the following...
  16. ehenry

    SQL Server Agent CmdExec Excel

    I am trying to make the SQL Server Agent open excel as one of my job steps. "c:\program files\microsoft office\office12\excel.exe" The job just runs endlessly and does not open excel. Any help on this would be appreciated.
  17. ehenry

    Run External EXE from Sql Server

    Is there a way to trigger a program to start running from SQL Server? What I have is a database that is scheduled to update on a daily basis. After this update I want to open an excel file. The excel file will pull the data it needs automatically to produce a report. I can have the file open...
  18. ehenry

    Concatenate Problem

    I am appending data to a table with fields: Unique ID, Station ID, Dates The data I am appending comes in on a daily basis with 225 rows the date being the same and then a unique station ID and some other data irrelevant to the issue. While appending the data I am creating a Unique ID as a...
  19. ehenry

    BULK INSERT ERROR with SQL statement

    I am getting an error when attempting to use BULK INSERT to add data from a small csv file to a table. Here is the SQL statement: BULK INSERT Temp FROM 'c:\Actuals.csv' With ( FIELDTERMINATOR = ',', ROWTERMINATOR = '\r\n' ) Here is the CSV file...

Part and Inventory Search

Back
Top