Hi Guys,

Hoping you could help out again, I've been working on this all day long but no luck.

I got the query in the system, based on the following results, can...

Thank you SQLRNNR.

By the way, what is FWIW? 🙂

Hi Jeff, Dwain.c and SQLRNNR,

You guys are AWESOME..

I really appreciate your help and learned new tips and tricks from all of you..

God bless you all!

Just an FYI, I ended up...

Hello Dwayne,

I tried the script but it just keeps on running.

Here is the actual script:

WITH Tally (n) AS

(

SELECT TOP ((SELECT 1+CAST(4*MAX([hours]) AS INT) FROM TOTALS

...

Hi Jeff,

Actually it's 0.25,0.50, etc. format, I made up the data for the post and used the wrong format.

Thank you,

Thank you VERY MUCH for the quick solution, I will test this as soon as I get back in the office on Monday..

Thank you Wayne, I'll give it a go.

Much appreciate it.

Best Regards,

ZA

Thank you Greg, I'm using SQL 2005 and upon right clicking on my table I don't see a Modify option, however I used Design option and I'm able to insert...

Oops sorry about that Gus (GSquared), I'm a newbie and I know it shows 🙂

Thanks again.

Awesome, thanks SSCrazy for such a quick reply, I'm so glad I joined this group 🙂