H Guys, thank you for all the posts. Its great support to know that there all these experts available on this forum!

Well done, correcting the spelling error of ApptTime has...

Anyone ???

Doh!!!

I see now I need to change the final CTE to a temporary table so the dynamic sql is ab leto use it.

While the crosstab may be quicker than PIVOT...

Hi Luis, I am sure there is nothing wrong with it, but I am a SQL beginner and am finding dynamic sql quite confusing. I need something very simple...

HERE is my latest attempt to solve the problem...

while it produce a correct list of dates on my @cols string. I need the dates to be wrapped with singel...

Hi Guys, I have the above code running well now but have run into another problem with a pivot table

,AllData AS

(

SELECT A.Dates , C.ApptTime, C.Details

FROM DailyDates A

LEFT...

Hi Luis,

Thanks for your prompt reply.

I know your code works as I have tested it out before. I know it creates a cte of dates but would you mind explaining...

Hi SSCarpal,

I love CTE they make perfect sense to me and I have all of my sp done that way already...so there's no going back...

But thanks for commenting anyways...

Hi, As promised here is the code I have prepared to give me the 3 tally tables I may need.

The first Tally example uses a number of cte's that (as...

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...