Since we have many datetime fields in our database, and quite often only the date part is needed, we have a UDF that "strips off" the time from a datetime...

SQLBill,

this works for you?? I tried it several times (with various changes), and I always get an error... which is about what I expected, because I already tried something very...

Perfect! Thanks a lot, Jonathan, and I second SQLBill that this should go into FAQ or some other place, more permanent than a forum thread.

If this software you are running uses nested transactions incorrectly, then I'm afraid the problem is in the software itself, not in SQL server - and if you would switch...

sql777,

since you wish to retrieve entirely different data from each of the tables (say, square meters for land, speed for cars and number of tenants for a house) - and...

I suppose it also depends on what do you wish to select "out of tblProperty", and what do you want to do with selected data... if the question stands simply...

Hmm.. and what if one user writes age > 50 and another one age>50 (without spaces around operator)? It is still the same condition, but unless you set up the...

Hi tkc,

what about using logical operators instead of CASE to achieve the result?

SELECT ... /* various fields */

FROM PatientInfo

WHERE ... /* various parameters */

AND (UserID IN (SELECT DISTINCT UserID FROM...

LOL, I even didn't know that it is possible to answer the question later than the day when it is published.

Why should it be harsh, David? If you can't answer...

Antares,

You're right, I missed this point... It really is interesting, because simple switching of the two values makes the query run OK (I have SQL2000, too):

select

case

when 1=1...

Antares,

thanks, that brings some light into the problem, but anyway - LTRIM is in the ELSE part, so while you have WHEN 1=1, everything in ELSE should be skipped... or...

Nice example of a bug, I'd say... I have no explanation for it, but I tested a bit and found out that if you

- replace replicate(' ',10) with '(10 spaces)',...

Jeremy,

I understood at once what you mean, but unfortunately I was out and didn't get to read your replies until now.

Put SET TRANSACTION ISOLATION LEVEL READ COMMITTED where you want...

Hmmm... that's rather complicated and I'm not sure I understand everything about the processes correctly. Just an idea - status of the row gets updated after the procedure summarizing the...

Hi bfarr23,

I'd say that the problem lies in definition -one shouldn't ask a program to store non-decimal values in a field of data type decimal. As far as I know,...