Thanks for your response, I typed a full explanation which got eaten by a browser crash.

The upshot was I will try both!

This is quite a small system in fact and, apart from my bulk insert to import existing data, the likelyhood of their being bulk inserts is small.

Thanks for you help.

Colin

Thanks for confirming that functions don't work that way

The function is

Create function fn_Calendar_GetArrayDates

(

@SDATE DATETIME,

@DURATION INT

)

RETURNS @DATES TABLE

(

DATE DATETIME

)

AS

BEGIN

DECLARE @EDATE DATETIME

SET @EDATE =

(SELECT c.Date

FROM FLITE_Calendar...

Thanks for your opinions.

I am writing a Windows app using VB6, I looked at the standard Microsoft grids, but they didn't have all of the features I needed.

I have ended...

Thanks to everyone for your contributions. At least I understood the problem, even if I couldn't find a way around it!

I am currently looking at Noggin's suggestion of the...