I can't give you a definitive answer on either question, but I would recommend that you set up a test environment to check it out. Sounds like a pain but...

Fair enough.

You could probably use SQL Profiler on the query to try to find out what is going on. Run it once without the isnull, then again with the isnull to...

From what I can gather, you are saying that if @CtgyLvl04I is null, don't use it (because your option is to compare C.CtgyLvl04I to itself)

You could try using the following...

There are two ways that I can think of.

How is your VB skills? You could use Excels built-in VA programming languange to connect to your database and loop through the...

I don't fancy your chances. You might be better off spending time to get the queries to run more efficiently.

I noticed noone had a ready answer for you, so might I suggest that you use sp_helptext to look at each sp in it's own environment and see what you...

And one more thing - without really knowing all the details, do you really want to have a LIKE clause on you membership ID? One would hope that they know...

Your like clause is all wrong for a start.

When using like you need to use some sort of wilcard in the string to ensure it looks for more than just...

Perhaps by moving the integer data into a separate table you will have the opportunity to turn the query performance from good to exceptional - given the right structure and...

I can't help but feel you've got earplugs on, or just selective hearing.

Either way you are just not listening. Having developers actively querying the production server is a no-no....

Nice - bitwise operators. Elegant, fast and doesn't hide the calculation away.

I'm not totally familiar with the PIVOT function but I believe that you still have to know what data you're dealing with (which rows you want to turn to columns),...

My expectation would be that you do this when creating the individual database rather than the SQL Server installation.

When you create the database, you will need to create multiple filegroups,...

Here is some code that will do it for you - though I have used slow cursors so if it's a one off task then speed will not be an...

SELECT SPECIFIC_NAME 

FROM INFORMATION_SCHEMA.ROUTINES

WHERE ROUTINE_TYPE = 'FUNCTION'

ORDER BY SPECIFIC_NAME

Its the same view, just a different parameter to determine which objects you want to look at.

In SQL 2000 you can find it...