If you do run into a performance issue using the structure:

WHERE (column = @parm OR @parm IS NULL)

You can either move directly to Dynamic SQL, or you can try using...

andrewd.smith (2/11/2009)

---

If OP wants to select records where the date range in the table row overlaps the date range defined in the input parameters, then Vladan is right, and rtomkins'...

What you have left to do is not going to be easy. Especially since you have no reliable method of determining that the first element in the space delimited...

As written - your trigger is only valid when you can guarantee (for all time) that there will only ever be a single row updated at a time.

If you try...

Sorry - that is a typo, it should be COALESCE.

Because you are not referencing the table CFD in the from clause. You need something like:

UPDATE a

SET {columns}

FROM CFD AS a

...

Lookup GROUP BY and COUNT in Books Online.

When you say blank, do you mean an empty string? If so, try:

select ID, cltattn, cltemail from clients where cltattn is not NULL and cltemail is not NULL

SELECT ID

...

Well, with that small of an index - it will always show some level of fragmentation. It really doesn't mean much anyways if you think about it. With...

Here is another method that is a bit simpler:

select convert(char(10), getdate(), 101)

+ ' ' + convert(char(5), getdate(), 108);

You can also get this information using SMO and the properties DataSpaceUsage and IndexSpaceUsage.

Not sure if you can use that, since you can't use fileproperty().

How many pages in that index? Small tables will always show some level of fragmentation. If this is a larger table (1000 pages or more) and it still...

Also, you might be running into different execution plans between SSMS and ADO. That would depend upon the connection parameters being setup in ADO. One thing I have...

SELECT * FROM TableA

EXCEPT SELECT * FROM TableB;

The result will be rows from TableA that do not have a corresponding row in TableB (exact match on all columns). If...

Jeff Moden wrote an article on this site that addresses the issue of Running Totals. However, he apparently has pulled the article to correct some issues he found with...