thank you for your help!!!!

I have found the solution:

DECLARE @date as VARCHAR (10)

SET @date = convert(varchar, DATEADD (week, -1, getdate()), 103)

DELETE FROM table

WHERE @date > columName

Thanks:D

thank you for your answer.

I have to take in account the day of today, instead of doing a select of MAX(date) because it's going to be an SP executed...

It works but after if (...) goes begin not then.

IF NOT EXISTS (SELECT Data, ResetFinreset, NumeroDeDispositivo, NumeroDeZona, NumeroDeError

FROM Telifrais.dbo.HIST_RESET

WHERE Data =...

Mi table doesn't have any primary keys. It's compound by 5 columns and the table doesn't have any relationship with other tables.

So I need something to don't repeat the...

Matt Miller (5/14/2008)

---

Combining that into a Windows service is likely to be your best bet. Once you wire up the FSW event to fire as you like, triggering the...

Ok, I made a mistake doing the question in that way.

I mean that if there is a stored procedure running (doesn't mind what is doing to the database) and...

Yes, I have. Take a look about the last update date: 2003.

I have to say that the interface that we can...

Matt Miller (5/14/2008)

---

If the CSV show up once per day/gets modified just once in a while, running something continuously in the hopes of catching the mod time is, well -...

mtassin (5/14/2008)

---

Not 100% sure I follow,

1. You have an application that drops csv files to a specific folder on an ad-hoc type of basis

2. You need to read those...

I know that we cannot know what is going to happen, because a database is non deterministic. So as you have told me, a querie can last between 5 or...

Hello,

My purpose is to read some csv files from an application. And to do that I thought that the best way was to bulk that csv to the data...

The stored procedure that makes the bulk takes 120-500 milliseconds. But as I am doing the bulk each second it would be 12%-50% of a second that is too much,...

Without installing the dll it gives me the same error using

EXEC master.dbo.xp_filesize @Filename, @filesize OUTPUT

It's normal for SQL SERVER 2005 to not have that dll?

Anyway, do you know how...

My boss has told me to not install that library. So I am trying to do it in another way. He has told me to do it with incremental bulk...