Thanks to you too Lowell for your input. Squirelled away for later use I'm sure !

Matthew

@Cnporteus, yes saw that one, didn't work for high enough hours though.

@Laurie - Thanks for this tweaked it to:

declare @time decimal(5,2);

set @time = 95.75

select replace(cast(convert(decimal(10,2),cast(@time as int)+(((@time-cast(@time as int))*.60))) as...

Hi,

Thank you for your responses. I guess the final answer is... the code is efficient as it is going to be. I thought about JOINS, but it is a bit...

Lynn Pettis (6/19/2011)

---

Sorry, but I'm confused as to what you are trying to accomplish. You provide some very basic table structures and sample data but you really to show...

Ahhh. Thank you very much for taking the time to answer.

Matt

TST1 (6/14/2011)

---

Hi,

I have an SP which runs at night to populate certain tables from production to Dev. The job runs fine but it didn't seem to populate the tables....

Indeed she does..... thank you very much for the pointer.

What is XP 2007 SP2 ?

If you are on XP, then I would get SP3 first from windows update.

Hi,

Thank you to everyone for your input. The application already exists as a legacy payroll system. The problem is that the old code is cusoring through large tables collecting gross...

Jeff Moden (7/11/2010)

---

m.dunster (7/11/2010)

---

Hi,

I've managed to successfully adapt this to solve my problem. Now I'll have to spend some time trying to understand exactly what is happening.

Point noted about the...

Hi,

I've managed to successfully adapt this to solve my problem. Now I'll have to spend some time trying to understand exactly what is happening.

Point noted about the data provision.

Many thanks,

Matthew

Hi Lutz,

I've tried this, and it updates every weeknumber to be 1.

Perhaps I am putting it into the Update incorrectly. I need to examine the syntax and figure out what...

Thank you for your reply.

I'm not building a calendar table. I'm calculating something which requires totals to be broken down into weeks. It could just as easily be blocks of...

Jeff Moden (4/2/2010)

---

Thanks for the feedback, Matt, but could you explain the business reason behind this? ...

Jeff Moden (3/17/2010)

---

Not trying to be a smart guy here...

It's normally a very bad idea to programatically add a column as a matter of course and it's usually really bad...