Viewing 15 posts - 9,406 through 9,420 (of 9,720 total)
Actually, it's a char(2) and the value will never be less (unless it's NULL and I've got that check taken care of).
But the warning is well heeded. There are days...
September 19, 2007 at 11:02 am
WHOOHOO!
I had to sacrifice my % sign because the table I was updating had integers in the columns instead of characters, but I finally made my percentages Pivot table dynamic. ...
September 19, 2007 at 9:53 am
Unfortunately, I can't see your pictures. My browser is just showing two little white boxes with red X's in them.
Can you paste in text?
September 19, 2007 at 8:13 am
Darnit...
I was hoping that wasn't the answer. I ran into that problem this morning with a T-SQL send mail proc that doesn't use DBMail. So I was hoping switching my...
September 19, 2007 at 8:05 am
DUH! You're absolutely correct. The extra GROUP BY was causing my DBZ error...
Now, to see if I can make this puppy dynamic...
September 19, 2007 at 8:03 am
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
Viewing 15 posts - 9,406 through 9,420 (of 9,720 total)