Hi Guys,

Thank you so much for the replies its a great help. Your right I have also been thinking how to delete/amend a series of appointments or just 1 appt.

I...

Hi,

I've been away for a few days but looking forward to trying out tomorrow. So thanks again everyone. I will no doubt have a few more questions relating to tally's...

Thanks for the advice guys I will check it out.

Hi,

I am no sql expert and I see what the select from values is doing but when I reading Jeff Modens article on tally tables.

He suggested using the following script...

Hi Luis,

That worked a brilliantly and fast too! Thank you so much

I'll have to spend some time understanding it tho, as I have built a sql statement within a...

Hi Chris,

Wow, thank you so much... looks the business!

I had been reading about the Tally Tables but can't claim to understand it!

I copied and pasted you code into stored...

Hi, Looked at link very good but still unclear how to do it... here is the sql

CREATE TABLE [TblClientPOC](

[ID] [int] IDENTITY(1,1) NOT NULL,

[ClientID] [nchar](10) NULL,

[StartDate] [date] NULL,

[ApptTime] [time](7) NULL,

[Duration] [int]...

Hi Guys,

Yes there is a limit of either 1 week, 2 weeks or 4 weeks maximum.

So the user chooses an option 1,2 or 4 week period and 2 dates SDate...

Hi,

We are running on sql server 2008 r2 express, which I think doesn't have reporting service built in!

But once the output from the pivot table is correct I want to...

Hey Steve,

Yes that was very helpful article. They make a good point if you add a windows user into a sql database they can then use other programs other than...

Hi Steve,

Interesting read Steve.

I am testing niw on my database.

I have given my users just datareader and datawriter privileges.

Then I intend to create a database role called DB_SPUser with...

Hi Steve,

Thank you for the prompt reply. I was thinking roles might be the solution, but hadn't looked into it fully.

Cheers for the help.

Thank you for that info.

Your absolutely right I should use numeric as to avoid all sorts of rounding errors etc thank you.

I have decided to create a table to solve...

HI Thanks for your prompt reply.

When I calculate the FinalOwedHours I need to bring it back into the calculation for the next month as PrvsOwedHours !

SO I am not sure...

1234, 10/1/14, 42.75, 84.00

1234, 9/2/14, 11.25, 12.00

1111, 10/1/14, 10.50, 23.00