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

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

Florida.  Where are you?

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

Noeld,

This link was EXACTLY what I needed.  Thanks!  I am emailing cookies to you. @=)

...or kudos or something... @=)

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

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

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

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

Except that still doesn't give me percentages.  I can't find a function that does.

Any thoughts?

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

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

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

You know, it occurs to me that you might be heading in the wrong direction.  Especially as some of your row results turn out to be column headers, but the...

First, do you have FULL Text Indexing set up on your SQL Server?

The CONTAINS keyword only works with that.  Same as FREETEXT, CONTAINSTABLE and FREETEXTTABLE.

Secondly, you have to code your...