Maybe this can get you started.  I'm sure someone else can come up with a more elegant solution.

IF EXISTS (SELECT name

    FROM   sysobjects

    WHERE  name = N'tblCategory'

    AND...

Can't say that I know for sure which is the most efficient but if I were to explicity convert to datetime in this type of situation, I would not bother to convert...

While we're at it why not get rid of the convert statement it seems to work fine for me without it.

update Inventory

set DateColumn =  DateStringColumn

where isdate(DateStringColumn) = 1

For an excellent article on how to work with sql server dates read this article by Frank Kalis:

http://www.sql-server-performance.com/fk_datetime.asp

Select a.AgendaId, a.AgendaItem, 

         c1.FullName as ProposedBy,

         c2.FullName as SecondedBy

From tblAgenda a

Join tblContacts c1

  On c1.ContactId = a.ProposedBy

Join tblContacts c2

  On c2.ContactId = a.SecondedBy

Here's the example from Books Online but even this doesn't work when I test it!?

This example uses CHAR(13) to print name, address, and city information on separate lines, when the...

Here's a good article on case sensitive comparisons

http://www.databasejournal.com/features/mssql/article.php/3487696

select refno from SABPP.SABPP_CRMCLT

Where refno not LIKE 'A%' ....

I don't think this will work when col_1 is null and @DateSubmitted is null.  In such a case you will be left with the expression

Where Null = NUll  and...

If you are still having a problem please post the exact statement you are trying to run, a sample of the output and why you think it is not correct.

Select Min(InvoiceDate)

From your_table

Where product_id = '123'

-------------------------------------

Select top 1 InvoiceDate

From your_table

Where product_id = '123'

Order by InvoiceDate

Sliu,

Remi is correct. If you are still using such an approach to dates then do yourself a big favor and read the article mentioned above by Frank Kalis.

SELECT *

FROM MyTable

WHERE SubDate BETWEEN '01/03/2005 00:00:00' AND '31/03/2005 23:59:59'

Even this statement will miss rows with a date  of 31/03/2005 23:59:59 containing milliseconds > 000.

For a excellent understanding of how...

I think this will work fine for you.

Where ...(@DateSubmitted Is NUll OR col_1 = @DateSubmitted)

SELECT Distinct m.clrec_sysid, m.cons_entity_id, m.event_date

FROM tblclinical_reord_master m

WHERE m.clrec_sysid =

 (SELECT Top 1 m2.clrec_sysid

  FROM tblclinical_record_master m2

  JOIN tblcase c on m2.case_sysid = c.case_sysid

  WHERE m2.cons_entity_id = m.cons_entity_id

  AND c.case_end_date Is Null

  ORDER BY m2.event_date...