The user definitely has permissions because the total number of eligible records prior to running the cursor was 15,261 and after it was 14,441, which means it updated 820 records.

As...

OK, well that's a simple answer.  Thanks!

Thanks!  I have one more question though.  If the tabs already exist, how do I get rid of them so that I can recreate them?  DROP TABLE doesn't seem to...

Thanks, but I still have the question as follows.

Let's say there is no other value being inserted but the description field.  If I use this statement:

UPDATE address

, description =...

OK, thanks.  One other question.  Should I do this for every field in the table that might be updated because at times, only the address name or the zone would...

OK, this is all new to me, so please bear with me.  How do I do the update in the ELSE?  I looked at the sample and don't see where...

I tried the following trigger:

create TRIGGER trg_u_address ON Address INSTEAD OF UPDATE

AS

-- Make sure that all of the data meets the CHECK constraint.

IF EXISTS(SELECT *

          FROM inserted

          WHERE id =...

Could you give me a sample "Instead of" trigger?

thanks!

IN addition, the procedure I wrote has some columns defined as follows:

(select count(distinct id) from customers where id in (select customerid from orderheader where date_delivery between @startdate and @enddate and...

I've given this a try and here is the case statement I've come up with for the order by clause:

<procedure declaration and code here then the order by...>

order by

(

case...

Thanks for the advice. The only part I did not understand how to accomplish is using the CASE statement to create the ORDER BY clause. I'd love to...

Actually, your approach is similar to the one I'm using that isn't returning the proper information. Consider the following (real) sample data:

1 2003-08-10 00:00:00 1899-12-30 12:15:00

2...

Another good idea, but that won't work because the time_targetdelivery column has different values in it and the grouping won't help me determine the shift splits.

That would not work. It would return the following information:

Monday breakfast: 3

Monday lunch: 2

Tuesday lunch: 2

Tuesday dinner: 5

Wednesday dinner: 6

Thursday lunch: 3

Friday dinner: 8

TotalCount = 24

I should also...

I fixed the error and the CASE way works great! Thanks alot to everyone who replied. I learned alot more about how to create these complex queries. ...