I am glad that you are seeing the benefit of providing consumable ddl and sample data. Unfortunately your create table statements don't work and you have a mismatched number of...

I was kind of wondering if you were trying to do a "previous" row type of thing. Of course what is previous? You have no order by. If you can...

I don't quite get what you are trying to do with your updates. They are quite strange. I agree the behavior is a bit odd but so is the logic....

Excellent job posting ddl and sample data. It is totally unclear what you want as output. If you can explain, this is probably pretty simple.

reliableitservice (6/11/2012)

---

Thank you all for your responses and I thought my post was going to be kind of complicated after I had posted.

Here, I attached something that could make this...

yanivkahana10 (6/10/2012)

---

Hi,

I Have 2 table :

The first Contain's : Username , Password, firstname etc'...

I need to build an after update\insert Trigger that will contain 10 lastest username password.

I'm Thinking...

I am a bit confused. The title of your post sounds like you are working with Oracle. Then you talk about what sounds like sql server. Then you say MySQL...

Our net nanny says that is a potentially damaging site.

Stefan Krzywicki (6/8/2012)

---

Ugh, just found out we're switching to security that requires you to change your password every 90 days. Nice that we're switching to that now that security experts...

Are seriously trying to explain to Jeff Moden how deletes work in SQL Server?

Jeff I am surprised you didn't comment on...

With dynamic sql.

If you want some real help post some ddl, sample data and desired output.

Look at what you have posted and ask yourself if you think you provided anywhere near enough information. We are volunteers...

Well as I said previously you should consider moving your data to a stored procedure and the calling...

Well the explanation is a bit sketchy but let's use the data you posted in your post. I used your function to create a temp table.

create table #HoursMin

(

ID int identity,

HM...

Can you post some ddl for this table so we know what datatypes you are working with?