Recent content by NeelyJ

I am importing a csv into SQL2000. Below is a small sample of the file... 436,"KID'S TRKY "," ",0,1,199 445,"KID'S "," "," ",0,5,299, 445,"KID'S "," "," ",0,5,299, "PRICE CHANGE RECS" 129,"BREAD...

Should have explained further. It is a stored procedure to feed a datagrid. The query compares this year to last year. I only want a comparison for days that have been entered for this year. ie, on the first day of the month, don't want to show 1 day vs the previous year's 30. Just want to...

Here is the query. Maybe it will help explain the problem. declare @Store_number int declare @Date_Start datetime declare @Date_Stop datetime declare @Date Datetime set @store_number = 4 set @Date_Start = '1/1/03' set @Date_Stop = '2/1/03' -- Determine the last date a cashier's report is...

I need to compare 2 dates and find the minimum of the two. something like min(@date1, @date2). I am sure there is an easy way to do this, but I can't seem to figure it out. Thanks.

I need a way of uploading a file to a server in an intranet enviornment silently. The user clears their terminals (not web based) which generates a set of csv files. They then open a web form which needs to upload the files for the day and read them into the form. I can parse out the date...

Thanks for your response. The situation is I have a single table of 11 gig (74 mil rows). I deleted 20 mil rows, but the size stayed the same. I have tried dbcc shrinkfile, and it didn't help. Does "shrinkdatabase" do something different? If so, could you tell me the command line...

I deleted several million rows from a table in SQL, but never saw the change in drive space. How do I regain this space?