Using a column that might vary its name from one run to the other is...

Maybe you could use dynamic sql for better results as shown in this article: http://sqlinthewild.co.za/index.php/2009/03/19/catch-all-queries/

Or you could simply go like this:

WHERE parameter1 = @parameter1

AND (parameter2 = @parameter2 OR ISNULL(@parameter2,'')...

That seems to be because the NULL checkbox isn't selected. You could allow blanks to prevent this problem.

haiao2000 (7/8/2015)

---

Thanks for following up. I came cross an instance that we have to update and delete 20+ millions of records from the table. and that has been extremely slow,...

I'd use a suggestion very similar to Leo's code. I'm not sure if that's the update format that can cause unexpected performance problems with no logical reason.

UPDATE o

SET obsolete =...

Actually, you don't need it. Just create it on the fly as part of the query.

WITH CTE AS(

SELECT p.Prefix

...

I use the IFCode tags which are visible to the left of the message text box. For SQL code, I use the [ code="sql"][/code] with no space. You can also...

I'm not sure which of the 2 HAVING clauses you need so I'm including both so you can test.

I also changed the pivot approach to a cross tabs which is...

If you're using something else for the front-end, such as SSRS or any other reporting tool, you should format the label on that tool. It's a lot easier to maintain...

After you understand how a tally table works, you can play with other variants such as views or functions which might include zero reads.

CREATE FUNCTION dbo.NumbersRange

( ...

It depends.

The best way would be to have your DOB column in your table as a date data type. This will validate that the data is correct and generate an...

Which is...

sqlguy-736318 (7/7/2015)

---

I want to migrate the full table definitions, table data and dependent objects. This needs to be done through a sql script as opposed to SSIS. Can...

Are you looking for something like this?

EXEC sp_depends 'Schema.Object'

The best reason that I've encountered is consistency. We can't treat NULL values the same way as other values when comparing them. What would you expect when you use SomeValue...