Search results for query: *

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

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

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

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?

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

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

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

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

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

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

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

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

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.

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

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

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.

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

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

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