Frank,

try google - when was the last time any movie was a reflection on reality ... 🙂

some body had posted earlier that you could probably find the meaning of life...

must be the beer in your coffee mug - 🙂

shhhh ,

you're giving it away

different take on the subject-

1) Good album on headphones (SOAD anyone??)

2) Mug of columbian or a cold beer(if allowed) 🙂 🙂

3) A dog -eared copy of Guru's Guide

4) Boss on...

might be overkill - but i have a standard UF for these pesky CSV strings

CREATE FUNCTION UF_ParseIntoTable (@lv_PassedString varchar(8000))

RETURNS @Results TABLE

(

ItemIdint

)

AS

BEGIN

DECLARE @li_StringPos smallInt,

@lv_ConvStringvarchar(10)

SET @lv_PassedString =...

whe you say collation option - do you mean this

SELECT T1.*

FROM TableA T1

INNER JOIN OtherDb..TableA T2 ON T1.TxFld LIKE T2.TxFld COLLATE SQL_Latin1_General_CP1_CI_AS

true - the only SQL only options i can think of are restrictive and would not be true solutions

Hans - can you show us what kind of nested select you...

select convert(time_challan,114) from tableA

you've missed the first parameter of convert

should be

select convert(varchar,time_challan,114) from tableA

SELECT Today=convert(varchar, GETDATE(),114)

returns

Today

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

13:52:08:233

seems...

Sorry - yes understand what you mean now - READPAST would probably issue a lock itself..

can't think of anything that will do what you are asking for

coverston

you want the select to honor locks - but you want to read the locked data?? - that seems like a bit of contradiction to me .. In case...

actually - i have come across the same problem many times myself - and have always opted for this solution . it would be interesting to see if this can...

do you have a check in the update trigger to exit if status is updated - like this

IF UPDATE(status)

RETURN

that should stop any recursion

we have a similar situation...

a UDF would be the best way to go

CREATE FUNCTION dbo.UF_ReturnOrders (@Cust_num int)

RETURNS varchar(255)

AS

BEGIN

DECLARE @RetStr varchar(255)

SELECT @RetStr = ISNULL(@RetStr + ' ' + CONVERT(varchar(20),Order_numbers),CONVERT(varchar(20),Order_numbers))

FROM Orders

WHERE (Cust_num = @Cust_num)

RETURN @RetStr

END

SELECT *,dbo.UF_ReturnOrders(cust_number)...

if you have a unique key in the results then yes

USE PUBS

SELECT ( SELECT COUNT(*) FROM Titles T2 WHERE T1.Title_id <= T2.Title_id) As RowNo , *

FROM Titles T1

ORDER BY...