Steve,

Thanks for the reply. I figured this would be a bit confusing; the "inner" select statement needs to contain all 3000 items. Basically, the criteria needs to be

bcp...

I found a website today that describes variable usage, http://www.sqlis.com/81.aspx .

However, when I have three "columns" of data coming in, index 0, 1, 2, (for the Column1,...

WOOO HOOOO! It worked! Much better than "brute force"! Just goes to show that collaboration is much better than going it alone!

I can say, if not for this website,...

  Thanks for everyone's responses again! I think there might be a misunderstanding... In the initial query, I am converting any "CompanyNames" from NULL to "Not Assigned". 

  If the initial CompanyName...

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...