Good Day To All, with respect and thanks to all!

OK I think I have a work around with everyones input and a breif discussion with the users. I can get...

Yes this is a true statement but how do you increment the period when you schedule the report??

This particular report would be ran after the books are closed.

So if it was ran today it would be for period 201505. Most cases this report would run for the...

Good Day Alvin,

thanks for you input, but I don't understand how that is going to get me the end result that I'm looking for.

Please be patient with me like I...

Ok let me start this all over again to be clear.

First the query works perfectly fine and bring back the correct data set. It's when dealing with the parameter that...

GOOD DAY SqlSanctum,

Maybe I didn't explain myself correctly, or I'm just confused.

Both fields

@BeginPeriod INT,

@EndPeriod INT

are being used as parameter(s) in my where clause

WHERE TT11.PERIOD >= ''+@BeginPeriod+''

AND TT11.PERIOD <=...

The ladder I want to combine the rows into one record.

the code

SELECT

p.HPROP,

p.STYPE,

p.SVALUE,

NSFFee = CASE WHEN p.STYPE = 'nsffee' THEN p.hvalue END,

SecDepIntRate = CASE...

That is not going to work for me.

Thanks now I have to include this in a view.

Well now I'm getting 3 records.

I put this in my select statement and I get no errors

, x.FAC_ACTIVITY[FAC_ACTIVITY]

, x.NUMMAINTEMP[NUMMAINTEMP]

, LH.dtLeaseFrom...

Good Day Chris M and thanks for your help.

I'll be as detail as possible.

p.stype = different fee type (example NSFFEE,MTMFee,DDEPOSITINTEREST)

PHvalue = fee amount (example 1.00, 21.00,50.00)

P.Hprop = person property number...

Now I get this error.

Msg 8114, Level 16, State 5, Line 1

Error converting data type varchar to numeric.