Computed columns would do.

Or a view - recreated when a formula in the table changed.

Miss a single payment and you gonna have an interest applied to the whole outstanding amount, including the previously accrued interest.

You don't pay interest on interest within a single statement...

There is such a thing as "repayment period", or "statement period", which a part of the game here, and which no one still mentioned.

You mentioned "edit/update spatial data."

And then you said "no locks".

Sorry, it cannot be true.

It simply not possible.

UPDATEs always incure locks. Always.

Even if you have (NOLOCK) hint in the statement...

Check your field terminators.

Field 2 in the example above has a terminator "/r" - is it how it is in the actual file?

"/r" would be expected for the last column,...

Looking back on all the projects you've delivered (yes, talking only about successfully delivered ones), how good was your initial estimation of the effort, knowledge, skills required for its completion?

And...

Lynn,

Just having a hierarchy of fk's might not be sufficient.

For example, in case of self-referencing table you have to iterate, as many times as many levels of dependency hierarchy...

Did you try it for pairs like
"UCLA" <--> "University of California Los Angeles" ?
What kind of score does it return?

And which pair is a better match:

Redesign is highly recommended.

You have 4 different entities mixed in 1 table:
Message Info, Message Content, Activity, Activity  Status (which should be actiually Activiuty Log)."
Table Queue...

MAX([WorkCommentId]) must be not in SELECT part, but rather in FROM section, as a derived table.

Subqueries within SELECT are executed for each returned row.

INSERT INTO [schmeap].[WorkComment_test] ([WorkCommentId1],[WorkId],[Comments],[IsExternalViewable],[IsAlert],[CreatedBy],[CreatedDate],[UpdatedBy],[UpdatedDate],[IsDeleted],[RegistrationId])

SELECT ROW_NUMBER() OVER...

Him - yes.

What about his laptop?

You know how "Prometheus" would be in Latin, right?

I wonder if anyone can explain me the difference between DBA and SQL developer.

I clear terms, please.

I mean - is a DBA expected to do the job all manually? Being...