Cool - good to hear!

Evaleah -

Is your stored proc working the way you're expecting it to? Are you still having an issue? Jonathan mentioned some good advice, but it does assume...

Since you're aliasing the table - I think you need to start with using the alias in the top of the UPDATE statement, as in:

UPDATE SD

Since you can only update...

Have you tried turning the UPDATE statement into a SELECT statement and see how many rows you get back?

Jeff Moden (10/31/2008)

---

ry.rith (10/31/2008)

---

Thank so much,

that you tell me about the solution.

I also do the same of yours to complete the crosstab-report, but something that i want is to know...

Sounds to me like that should be something stored in the user profile table (a.k.a when does their week start?).

Let's break the problem down a little. (let's call this a "hint")

How would you identify the rows in TableA that need the rows? What would the SQL look like...

Matt Miller (10/31/2008)

---

I'd think Lynn's solution is the best (meaning - handle these from within the stored procs.

That being said - it's been a while since I've had...

I'd think Lynn's solution is the best (meaning - handle these from within the stored procs.

That being said - it's been a while since I've had to do...

Agreed. Never mind a...

I thought you needed to fire the execution off from the pipe side, and not the "old" way?

As in -

SQLContext.Pipe.ExecuteAndSend(command);

and not

command.ExecuteNonQuery();

jgrubb (10/31/2008)

---

Jeff Moden (10/30/2008)

---

Jonathan Kehayias (10/30/2008)

---

As resistent as you are to CLR inside SQL, it is actually becoming more and more popular, even among MVP's for things just like this....

dmc (10/31/2008)

---

I think this points out how there is not one way to do things. I agree with rbarryyoung the most. There are really two options. We...

Stopping the agent is a good solution only if no jobs are running at the moment (since it will prevent any jobs from starting). Stopping the agent really isn't a...

I was going to say you could probably use Dilbert's advice on this. Next time they go to the bathroom, peak into the books. The content should give...