Looks a lot better this way!

Final remarks:

* Try to avoid using [brackets] where they are not needed. In your case, the brackets around [dbo], [Users], and [TR_Aud_Update_Datetime_Update_User] are not needed....

The problem is, as long as there is as much as a single...

Sure, if you post your current version of the script I'll help you make the changes.

GilaMonster (1/30/2016)

---

Is it me, or are there weird threads again today. "I want the challenge of trying to fix it without using the easy way" says one, and a second...

Though you have your answer, I'd like to add that in many cases it is not needed to nest CASE expression. For instance, this should work for you as well:

CASE...

I think you missed...

Kevin apologizes for sounding harsh ...

I am going to sound much harsher, and I am not even going to apologize for it.

ffarouqi (1/29/2016)

---

Come on people, forums are meant to ask...

If the column User_ID is constrained to be unique and not nullable, then the trigger should work. You should still test, of course.

There are some modifications I would make if...

How will you determine which value goes into which column?

What will you do when there are more values for a column?

Really, this appears to be a formatting request, and formatting...

Oops. Checked and double checked the dates multiple times and still overlooked the difference.

My bad.

Not sure why you would want to avoid row versioning.

Anyway, the other standard techniques for avoiding deadlocks are:

1. If you know or expect that a row you read might get...

SQL Server will execute the function to verify your check constraint *after* inserting the row.

Assuming that your row has sdate < edate, that row itsself will trigger the condition for...

Luis Cazares (1/29/2016)

---

Yet another option. However, I'm not sure which of the proposed versions would be the best option.

SELECT Id,

Amount,

CashFlowDate

FROM #Test

CROSS APPLY( VALUES(Principal, 'Principal'), (Interest, 'Interest')) x(Amount,AmtType)

WHERE...

I actually recommend that you *should* open SSMS and query the database correctly. Last time I looked, most queries fired from Access involved transporting all data over the network and...

Shabbaranks (1/29/2016)

---

Hi,

Thanks for your reply, Im not a complete newbie as I have an Access background and so I do understand joins and relationships. What I struggle with is working...