It depends how your role has been set-up. It may be that the role has been set up so that each individual stored proc needs to be explicitly permissioned for...

A couple of thoughts off the top of my head: Is the procedure created in the same schema that the db_execute role has access to? Is the procedure schema qualified and...

I'd be happy if an error message at least indicated the row number and column before throwing the rattle out of the pram.

I've updated the code that Lynn kindly provided to produce this. This will group multiple reciepts against an invoice to provide outstanding balances.

DECLARE @test-2 TABLE

As Phil mentioned, you can use Datepart and Group By to achieve this.

DECLARE @t table (TimeValues time)
INSERT INTO @t VALUES
('00:20:00'),
('01:25:00'),
('01:30:00'),
('01:45:00'),

Firstly let me say that this is a great tool!

However I am getting the following error whenever the jobs try to send an email.

Executed as user: NT AUTHORITY\NETWORK SERVICE. Warning:...

Excellent work - many thanks for sharing.

The variable @MyCount is in a different scope to teh dynamic SQL that you have declared.

Oops - I got it wrong:blush:

Evil Kraig F (11/22/2011)

---

... As a brief example, I've gotten half of the projects at my current position shot down after explaining why the difficulty of what they're asking...

I'm glad that you got so much out of it....

Hi all

Thanks for the feedback on the question. The results as they stand make for some interesting reading. Only 31% got the answer correct. So this shows that the loss...

If you can't work that out, then there's no way you should be on a SQL Server. I can imagine...

Ninja's_RGR'us (10/3/2011)

---

Depends on how you guys edited the table in EM.

Far too often the code defaults to something like this :

begin tran

create table2 (new definition)

insert into table2 SELECT *...

This will severely bloat your your transaction log. Do you have enough space on the disk where your transaction log is located? If not, it could bring your server down.