Viewing 15 posts - 9,406 through 9,420 (of 9,715 total)
What is the structure of tbl3215? What columns do you have set up for Full Text Indexing?
September 19, 2007 at 7:55 am
HA! Yes, I have declared an unused @sigh. I'll see if I can't fix that and use it... over and over and over.... @=)
I tried your suggestion:
Msg 8115, Level...
September 19, 2007 at 7:07 am
Oh, the drama! @sigh.
Well, I've figured out how to get around the Divide by Zero error, but I can only make it work for one column. I've also finally figured...
September 19, 2007 at 6:42 am
Hmmm. I'm going to have to play with it because I keep getting "Divide by Zero" errors with your code. Probably due to the ELSE 0 statement in the Cross...
September 19, 2007 at 5:47 am
JV,
Noeld posted this link for me in my "dynamic pivoting" thread. Take a look at it to see if maybe it'll help you.
http://www.simple-talk.com/community/blogs/andras/archive/2007/09/14/37265.aspx
September 19, 2007 at 4:56 am
Noeld,
This link was EXACTLY what I needed. Thanks! I am emailing cookies to you. @=)
...or kudos or something... @=)
September 19, 2007 at 4:55 am
Joe,
You need to have your variable defaulting done BEFORE you do your SELECT statement. Otherwise, it won't work.
ALTER PROCEDURE [dbo].[search]
(
@ittNumber nvarchar(max),
@ittdescription nvarchar(max),
@itttitle nvarchar(max),
@techsolution nvarchar(max),
@search nvarchar(max)
)
AS
SET NOCOUNT OFF;
if...
September 19, 2007 at 4:50 am
I don't deal much with proxy accounts myself, but SQL Server 2005 does offer the new "Execute AS" capability, where you can force the stored procedure to execute under the...
September 19, 2007 at 4:19 am
Actually, that's almost what we do in our shop. The main difference is that we refresh Dev / Test / QC right before we put in (or start) a release cycle. ...
September 19, 2007 at 3:58 am
Stuff isn't working for me. It's complaining that my subquery is returning more than 1 value.
I guess I am going to have to do this the hard way. I really...
September 18, 2007 at 12:00 pm
Except that still doesn't give me percentages. I can't find a function that does.
Any thoughts?
September 18, 2007 at 11:18 am
You have to default any variables that you might potentially not receive from outside the stored procedure. However, you can't actually use the DEFAULT keyword with variables that are passed...
September 18, 2007 at 11:11 am
Yes, you have the right idea, but your SP WHERE clause is wrong.
You can't use the WHERE clause to match the variables you are passing into the SP to each other. ...
September 18, 2007 at 6:56 am
JV,
Have you ever used SSIS before? What about DTS? If you've never used either, I recommend getting an SSIS book. If you've used DTS but not SSIS, you might be...
September 18, 2007 at 6:30 am
Viewing 15 posts - 9,406 through 9,420 (of 9,715 total)