Cool, thanks everyone.

Yep they are pretty small..and it's okay to take them all off line.

So it would be better to dettach the MDF/LDF's then it would be to create BAK files?

Is there...

Yes he did and I'm grateful.

My verbage was entirly incorrect. I apologize, rough weekend.

Using his method the proc is reeeeally slow, is ther another way to write the same thing...

Doesn't bring back the expected results...

is there another way to write this?

Many Thanks !!!!

Cool the minus 1 worked...but now my problem is that I already have this expression to format the date:

=Format(CDate(Fields!Next_Payment_Due_Date.Value),"yyyyMMdd")

How can I use both of these together? Is it possible?

=DateAdd(DateInterval.Month, -1,...

This works, but it adds a month, I was looking to subtract a month.

Thanks everyone, very informative and helpful.

Good karma to you all!

Thanks guys, I ended up using this on every DB - (in case someone else needs it)

SELECT routine_name, routine_type FROM INFORMATION_SCHEMA.ROUTINES WHERE ROUTINE_DEFINITION LIKE '%cam%'

go

SELECT routine_name, routine_type FROM INFORMATION_SCHEMA.ROUTINES WHERE...

Thanks!

Guess it's different because I'm using BIDS 2008

I'm using the BI..

Looks like that screen shot is from report manager?

oh okay my mistake sorry

excuse my ignornace, so I shouldn't use a declare statement?

what should I use for the @date parameter?

I'm confused now.

I don't wat a start date between and an end date.

I just want the user to pick one date from the calender and have it use that value...

Thanks Guys