"TOP 11000" must prevent server from death.

Why these?

Why not those:

20002 0

NULL 1

20003 0

?

What is defining the order of rows in your table?

Which one is Row 2?

It's better to do it in function which will use a loop to reach the end of that chain.

Otherwise you can never guarantee that you are using enough of joins.

WHich row you consider previous?

I guess your ID in table NBillingF is not actually ID, that's why join on this ID brings a lot of duplications and wrong value as a result.

Let's simplify Marino's...

Marino, there is no need for ISNULLs because you have already eliminated all NULLs by "> 0" and "< 0" conditions.

Vandy, what's not working?

Query from Marino seems OK.

I don't...

I believe your question was answered here:

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=286040#bm286129

Even name of topics are quite similar.

I don't see what's wrong with database design. Whoever did it he did it right.

But I cannot see in those tables what does it mean "the customer is winning".

Can you...

Did you notice function STR in my post?

Did you bother to open BOL and read couple of words about this function?

declare @f float

SET @f = 38966.419371064818

select STR(@F, 18,...

Did you read every post in this topic?

Probably this may help:

IF EXISTS (SELECT * FROM sysobjects WHERE name = N'TimeSlotStart')

 DROP FUNCTION TimeSlotStart

GO

CREATE FUNCTION TimeSlotStart

 (@CurrentTime datetime, @SlotDuration datetime)

RETURNS datetime

AS

BEGIN

DECLARE @HH float

select @HH = cast(@SlotDuration as float)

 RETURN CAST(FLOOR(cast(@CurrentTime...

getdate() IS datetime by definition. So, you don't need to cast it as datetime.

To get varchar use this:

SELECT STR(CAST(getdate() AS float), 12, 4)

Answered in parallel topic.

CREATE TABLE dbo.tmp_ABC

 (

 RecID int NOT NULL IDENTITY (1, 1),

 Name varchar(100) NOT NULL,

 Address varchar(100) NOT NULL 

) 

SET IDENTITY_INSERT dbo.tmp_ABC ON

INTO dbo.Tmp_ABC

(RecID , Name , Address )

SELECT RecID ,...