Thanks for the reply. But, as I started with, I don't want to use cursors if that can be avoided. Mangal Pardeshi's reply works very well and very fast I...

Wow..... fabulous forum, don't even have the time to get a cup of coffee before answers come in.

Thanks for the replies! The CTE solution is magic to me, but it...

Thanks for all ya guys' input. I'll start trying a few ideas....

Hey folks,

Thanks for all your replies. I think that using CROSS JOIN is the best, because it's a newer syntax.

Thx,

Ray

Oh, I love to see code names mixed up in languages And also nice to read something in dutch all of a sudden. This topic was great though, some...

Hi Peso,

Well finally it's done! I can't thank you enough, not just because you helped me finish something

I needed, but also because it gave me insight to a new...

Hi,

I had a same kind of issue, and it is discussed and solved (at least for me) in this thread:

http://www.sqlservercentral.com/Forums/Topic619245-338-1.aspx

Maybe it is helpful you u2

Hi Barry,

I will look into your link asap.... sounds like something I really need to know more about.

Hi Peso,

I bow to thee...... I just came out of a meeting and...

Jeez, you're a real wizard! I'm learning a lot from you.... THANKS!

No 3) was the showstopper, I think to tackle 1) and 2) I must add an agenda table on...

Hi,

I do encounter 3 drawbacks:

1) What if an appointment lasts more than one day? Of course "appointment" could be anything such as a two-week holiday.

2) Salesmen also have what I...

Hi Peso,

Got the edits!

I have never used the table master..spt_values before, so I'm a bit in the dark how it all exactly works. I do understand that master..spt_values is...

Hi there,

Thanks for all your input.

I would like to comment on one reply:

A bigint gives you 16 hours a day to schedule appointments for your salesmen. If that is...

Yep, y'r right, I made a typo.

However, I got the problem fixed, this does the trick:

DECLARE @a BIGINT

SET @a = POWER(CAST(2 AS BIGINT),CAST(62 AS BIGINT))

PRINT

Hi,

I have to grab a number of salesmen's agenda's (lets say 20), that cover 30 - 60 days, and find the spots where I can add a new appointment in...

Hi,

Thanks for your reply. Indeed using two bigint's is a solution, but it will make coding a bit more complicated, and of course execution would take more time.

Ray