I have used them.

The client app would request various sets of data from the server. These sets of data sometime contained data for the last 6 months or...

My databases do this sometimes. If you run DBCC UPDATEUSAGE in QA for the database then it should correct itself.

I know it doesn't answer your question about why but...

Is it possible to create an array of the data and pass that to SQL Server? You might not be able to fit all the data into one array...

On a similar vein, I have used a field terminator or "," (double quote comman double quote).

The downside to this is that the first double quote and the last double...

Should we have a thread for Frank hitting 2000 posts?

Printable answers only.

Well done Frank. I always look foreward to your comments.

Jeremy

Have a look at this topic. It is about capturing web pages rather than downloading files but there might be something helpful to you:

http://www.sqlservercentral.com/forum/link.asp?TOPIC_ID=17881

Jeremy

It might be the while clause.

open reps_cursor

fetch next from reps_cursor into @r

while (@@fetch_status =0) begin

set @mail = @mail + @r + ';'

fetch next from...

I suspect that as exipration date is in the future, your datediff will result in a negative number and never be > 90.

Try swapping the dates around:

datediff(dd,getdate(),eoexpirationdate) > 90)

Jeremy

Thanks for all the replies.

I've had a look at Planet115's excel app and it seems to do what I need - and it's legal.

There is nothing sinister in what I...

I believe that reindexing on a regular basis is a waste of time (generally speaking). If you have properly defined indexes with appropriate fill factors then you should not...

I'm not sure about c# but with ADO you can check the value of the return value from a procedure.

In the procedure you can add

return @@rowcount

Jeremy

In this particular case, you could do:

select distinct *

from OrderDetail

The problem with removing duplicates is that there are so many variations that no one solution fixes all. You...

Try Bill Wunder's archive utlitity (available in Products|Freeware). It scripts the items out to disk and into Visual Source Safe. If there are any changes then these get...

Planet115,

That would be great if you could email me what you have got.

click on my name in the left hand column to see my email address.

Thanks

Jeremy

Try this link from MSDN:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/script56/html/jsFSOTutor.asp

Jeremy