Yes, you can definitely add time to your string in that format.

Looks to me like your additional filters:

F.DIAG=T.ICDCOD and

T.[Per Se Disabling]='YES'

are having an impact on the results.

In a case like that I would typically look for a different field that would be sequential to be used as the CLUSTERED INDEX, such as a CreateDate field, and...

My understading is that these are the same.

From what I understand, and please correct me if I am wrong, UPDATE FROM is not ANSI standard

So with the MERGE statement introduced in SQL 2008, it is preferred to...

m.dunster (4/14/2009)

I've worked out how to use Join with Select Statements, but I need to use it with an Update statement.

I've tried:

update jobs

set comm = 0

join customer on jobs.cus_id=customer.cus_id...

A practical use for using a GUID for a primary key value is when your application needs to generate a primary key value without querying the database, such as for...

in that case, a couple of options could be:

1. If NULL references are not allowed, meaning you must have 1:M corresponding records in otherhugetable for every record in hugetable,...

Hi Cliff,

I would like to say that it would be ideal to avoid a loop if at all possible, but without knowing the complexities of your email requirements, I will...

I'm not sure if it would help much in this scenario, but you could eliminate some of the bottleneck on the subquery by populating a temp table:

SELECT recid

INTO #tmpDeleteRecId

FROM...

Does your data contain (or will it potentially contain) hyphenated names? This could pose a problem.

Could you post the original update command you were issuing which was causing the error?

Why not create your own udf that contains the LTRIM(RTRIM(value))

functionality and name it something like TrimString()?

Seems to have been an oversight. Answer is clearly No...

T-SQL is a wonderfully logical language.