I'm sitting next to the house - 53-57 Customs Street. "53-57" is the number.

I live on the street wherte there are houses with numbers 25, 25A, 34, 34A, 34B.

I believe...

SP4 resolves all joined views into single join query.

The function is applied on that final "resolved" query.

To all rows returned by that final query, of course.

If I remember right MS...

If you open the code of procedure sp_help_fulltext you'll realize that it's written in the way which causes table scans by definition.

No indexes may change this behavior, they are gonna...

On our DEV server this procedure takes 1-2 seconds to execute, 5 sec at most.

But we don't have more than 10 columns with full-text index per database.

You probably need to...

What does this code

DECLARE @NEXTPAYDATEDATETIME

SET@NEXTPAYDATE = CAST('JAN 29 2007' AS DATETIME)

DECLARE @CNTINT

SET@CNT= 1

SELECT

[CPMTest].[dbo].[fn_AM_CALC_NEXT_PAY_DATE]('M', 1,

DATEADD(MM, T.N, @NEXTPAYDATE) ,

3)

FROM

[Other].[dbo].[Tally] T ...

It becomes fun.

John, can you please show the plan of payments generated by your function for a loan started on 29 Jan 2007?

Single loan, pay dates month by month.

jsteinbeck (11/21/2008)

---

Well it seems to be working... would you care to give me a date that wouldn't work and I can go from there...

No offense, I come here to try...

Do you use FLOAT data type for all variables?

Start from this:

SELECT Date, dbo.ListOfEvents(date)

FROM dbo.Calendar

Calendar is a table with all available dates.

I use a modification of table Tally for this (if you don't know what it is search for...

Not even close.

Not even looking into right direction.

Your task does not have solution with the data you've given.

Simple question.

Last payment date is 29 Feb 2008.

What...

VARCHAR(MAX) either.

But it's used in the table definition.

jsteinbeck (11/20/2008)

---

I have the the MaturityDate to work with and the PreviousPaymentDate...

As you see with the CASE Statement, I am giving the Frequency to use with DD, MM, YY...

Any Scenario...

I guess it's explained here:

john.steinbeck (11/20/2008)

---

I am confused... the dates come to me as is... the one with a Nov Date started it's journey from

2008-10-31 00:00:00.000, and it came...

DATEADD function does exactly what you ask it to do.

You ask to add 1 month to 30 Nov - it returns absolutely correct answer: 30 Dec.

If you need last day...

What kind of example you're asking for?

You don't need examples.

You need right formula.

What you want to get back?

Last day of next mont?

So, ask for it.

Not for a day 1 month...