OK, I'm really intimidated my what everyone else has written so far, but here goes anyway.

If you're re-assessing the data structure then is this not, as Tomm Carr alludes to...

I agree, there's plenty of companies that will do this for you.

But if this is something you're going to have to do more of, then I'd advise you to make...

So we want sales for a particular day, and we've got a date to order by in that master table. The trigger isn't a problem. I've been thinking all along...

So say the moxt recent 30 buns cost 3 each, and the 30 before that cost 2. Total cost for all these is 30x3 + 30x2 = 150.

But you've only...

I think there's a couple of reasons for the multiple rows. If you're running the function with an actual value

select dbo.fn_pes_CONCAT1(8) from stringtest

then you're concatenating the values for projectid 8,...

And here is one without cursors:

CREATE FUNCTION fGetSTR_DATAList (@XX INT, @YY INT)

RETURNS VARCHAR(1000) AS

BEGIN

DECLARE @STR_DATAList VARCHAR(1000)

SELECT @STR_DATAList = ISNULL(@STR_DATAList + ', ', '') + TableC.STR_DATA

FROM

WHERE TableC.XX=@XX AND TableC.YY=@YY

RETURN...