What is the problem you are having? You do not provide an error message or a question really so I don't know what to help with.

I'm going to guess that Dave's solution will work, but, in my opinion, the best way to solve problems like this long-term is to create a calendar table that defines...

I'm not really sure what you mean. Could you post table definitions and an example of what you want? Or a diagram of what you want to do?

I don't think you can do what you want in SQL Server Agent, at least not easily.

Assuming the files are all in the same directory you'd be better off using...

If you are saying that the user has access via an Active Directory group then you can't drop the user from the database, the user would need to be removed...

You could do this a couple of ways both of which will require that you setup a SQL Server Agent Job to schedule the execution the process:

1. Use SSIS...

Sounds like you should read this article[/url]. While you say the account running the procedure is in sysadmin, the error certainly indicates that it does not.

As Barry has said,...

Based on the very limited data presented it seems that you could use:

Row_Number() Over(Partition By Group Order By Group Desc, Year, Month, Day)

I did the Order BY Group DESC because...

All this MVP talk. What I like is that no one mentioned thinks that they deserve it. To me that is one of the key qualifications. If...

CirquedeSQLeil (2/19/2010)

---

Grant Fritchey (2/19/2010)

---

Jack Corbett (2/19/2010)

---

I've considered it, but I've also talked to people who have done it (Grant being...

I've considered it, but I've also talked to people who have done it (Grant being one) and I don't think...

Grant Fritchey (2/18/2010)

---

I have heard the same thing, but since the only people I...

Lynn Pettis (2/18/2010)

---

Plus, from everything I have seen here on SSC, you don't even know you have been nominated until you have been awarded MVP. So, with that I...

Alvin Ramard (2/18/2010)

---

Lynn Pettis (2/18/2010)

---

Grant Fritchey (2/18/2010)

---

Roy Ernest (2/18/2010)

---

There are couple of guys/ladies here in this forum who have done quite a bit for the community and have a pretty...

Paul White (2/18/2010)

---

Grant Fritchey (2/18/2010)

---

I must stink at my job because I've got BOL open most of the time. I'm just not smart enough to remember everything. Must be why...