Viewing 12 posts - 106 through 117 (of 117 total)
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...
December 20, 2007 at 3:17 pm
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,...
December 13, 2007 at 8:51 am
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,...
July 27, 2007 at 7:40 am
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...
July 26, 2007 at 6:57 am
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...
July 25, 2007 at 2:59 pm
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...
May 21, 2007 at 6:28 am
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...
May 18, 2007 at 12:31 pm
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)
...
May 16, 2007 at 12:15 pm
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...
May 10, 2007 at 11:42 am
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...
May 10, 2007 at 6:19 am
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...
April 27, 2007 at 7:58 am
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...
March 19, 2007 at 7:09 am
Viewing 12 posts - 106 through 117 (of 117 total)