byecoliz (2/15/2013)

---

Hello,I am calculating the first 20 Fibonacci numbers using a function,but getting wrong answer.The condition is to write a function not a procedure. here is my try,help me.

create function...

gopikishan.maheshwarlal (2/15/2013)

---

Hi all,

i need help in deleting duplicate records from a table a. but the table which i'm going to delete has 2 child tables, table b and table...

Well it seems that while I writing my response you edited the original trigger and posted almost exactly the same thing I was suggesting. 😀

Does this much simpler version still...

boeledi (2/15/2013)

---

Hi,

Very weird case I am facing at the moment.

I have a trigger that works well until the moment it needs to commit the changes.

Some explanation:

I need to...

Ken it looks like you tried something to help here. Unfortunately you have a couple of scalar functions in your code and you didn't post the definition of them. BTW,...

ddl = data definition language. That means the create table statements. The article I referenced explains how to put all this...

Nice job posting ddl and sample data. I am not quite sure what the business rules are but this is maybe something to get you started. It doesn't quite match...

There are several things I would change here.

First you are using the old style of join. You should change that to an inner join.

Secondly, and probably the biggest, you...

Given the service agreement that...

ScottPletcher (2/14/2013)

---

Sean Lange (2/14/2013)

---

ScottPletcher (2/14/2013)

---

Nope, you're not quite there yet, one other changed to make.

You should always specify the owner (schema name) on objects in a trigger. There are...

dcyoung (2/14/2013)

---

That helps with part of my problem. I have a third party application hosted in house. We have read only to the DB period. I need to pull data...

ScottPletcher (2/14/2013)

---

Nope, you're not quite there yet, one other changed to make.

You should always specify the owner (schema name) on objects in a trigger. There are very few always/never...

Cool. Thanks for letting us know.

I think about the only thing you would be able to do here is to find the average size of a row in the table and then multiply that by...

I am still missing something here. Your cte is just a select statement. Are you doing the calculation in the cte or outside of it? Remember I don't know your...