As Noel implied, to ensure the value selected does not change between the time it is read and the time it is acted on, you would need to be within...

Yes, seems to work fine for searching udf's!

Declare @first_part varchar(20),

            @len_first_part int

Set @len_first_part = Len(@first_part)

Select max(seq_num)

From (Select seq_num = Right(your_col, Len(your_col - @len_first_part)

      From Your_Table

      Where Left(your_col, @len_first_part) = @first_part

      And   Isnumeric(Right(your_col, Len(your_col - @len_first_part)) =...

You might want to take a look at this thread. http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=169&messageid=170943

declare @var varchar(20)

set @var = '1,234,567.00'

select Left(@var,len(@var) -3)

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

1,234,567

You might try breaking the job into smaller batches to see what happens.

Also, I don't see any kind of error checking so you have no way of knowing if any...

The default return from a stored procedure is 0.  So I have all my stored procedures explicitly return 1 to indicate success.  Anything else I consider to be an error...

The statement worked.  There were no rows that matched the conditions of the WHERE clause.

Can you SELECT a row with the same WHERE clause?

Use the function descibed here http://www.sqlservercentral.com/scripts/contributions/157.asp

to convert your comma separated string into a table.

Example:

Select * from table_a where id IN (Select * from fn_split(@list) )

Or search this site...

Frank,

Very informative article.

Thanks,

Ron

Remi,

The ink wasn't even dry on that post!

Thanks,

ron

What are the advantages of using NOT EXISTS over NOT IN?

-thanks, ron

Rick,

Yes, a little caution is advised.  In you first example

select convert(varchar(10), '2005-04-04 23:59:59.999', 20)

you are converting a string value to varchar(10).

In the second example

select...

KC,

Where (myDate BETWEEN '4/1/2005 00:00:00' AND '4/1/2005 23:59:59')

Your method will miss dates with times between 23:59:59.003 and 23:59:59.997.

You can try using the convert function (see BOL). Ex:

Convert(varchar(10), mydate, 101) to compare...

From BOL:

datetime and smalldatetime (T-SQL)

Date and time data types for representing date and time of day.

datetime

Date and time data from January 1, 1753,...