Could not figure out a way to use the CASE statement in the where clause (thanks for all those who contributed), so I decided a little coding was in order...

I found the problem... not enough quote(s) around the statement. The statement I was trying to use was:

SET  @SelectStmt = 'AND AccountNo LIKE ''%'+@SelectStmt+''''

I was so concerned about...

No... it is a single datetime column... I just need to find the earliest date (min(MyDates)) and latest date (max(MyDates)) to see how much data is in the table. The...

Actually, you are right... I could have just done a SELECT to set the variable:

  Declare @DateVar varchar(10)

  Declare @NewDate varchar(20)

  Declare @Statement nvarchar(2000)

  Set @DateVar = convert(varchar(11),(getdate()-5), 20)

 ...

Ray... THANK YOU, THANK YOU, THANK YOU!

That appears to have solved the problem. I was not aware that you could put nonaggregate expressions in a group by, but I did...

Yes... did a full backup Sunday night (scheduled). I have a script that checks the last backup date (4 days ago from today, backed up 5/6/07). The problem is with...

Camilo, Thanks for your response.

I was hoping the "sp_addextendedproperty" was going to be a formatting method for me to just somehow query the view's contents and present it in...

Thanks for the reply Brian!

Version 9.0.3033 (SQL Server 2005 w/SP2): The SP2 version is '"PRE" March, 2007.

I will look to see if I can find the discussion... I...