slunt01 (5/9/2013)

---

Ok so i am diving back into SQL now and I am stuck. I am using views to manipulate my data and get it to where i want it....

You're welcome. Let me know if you need some help converting to a delete trigger. You would use the deleted virtual table instead of the base table.

You must have something else referencing that variable. It is not in the...

You don't have to call it that in your real code but yes. That one removes all orphans. If you ran that when a row was...

What you might be able to do is put that CTE in a delete trigger.

KS-321165 (5/9/2013)

---

Yes, but I have to go to my DBA to make these kind of changes and it is not easy with our DBA. With CTE, I can do it...

KS-321165 (5/9/2013)

---

Thanks Sean. It is just what is required.

One more request:

I am new to CTE.

Do you have a CTE that will delete all the children when the parent is deleted...

kishor.patgir (5/9/2013)

---

Hello Friends

I want this type output.Here I want in first column how many members are join today(registration),and in second column sum of member before today,and third column the sum...

prb88 (5/9/2013)

---

Hi All. Below is an example table of what i need to query out of:

Patient Name|| Patient No.|| Age|| Cancer||Consultant|| Operation||Admiision Date|| Date of Operation ||

Joe Bloggs ...

kritika (5/9/2013)

---

the above solution is correct if you want to go with and maintain data integrity with normal forms.

but there are scenerios where in due to some constarints you are...

Can you please more clearly what you are trying to do here? From what you posted I can't come close to a guess at what you want here.

Hi and welcome to the forums. You might take a look at this link with lots of date routines.

http://www.sqlservercentral.com/blogs/lynnpettis/2009/03/25/some-common-date-routines/%5B/url%5D

If that is not enough help we are going to need...

Here is an example using a recursive CTE to get the list of IDs to delete. Please note that to your original data I removed 631. That left the sample...

Something like this should work.

Notice how I posted ddl and sample data in a consumable format? That is something you should do in the future. It makes it easy for...

azdeji (5/8/2013)

---

The Event_Role column contains both the parent and the child hierarchies which are -

Parent (level 1)

Participant_ID

Supporter_id

Event_code

Event_role

Child (level 2)

Do not register

No Reg

Yes Reg

Child Level3

Did Not Attend

Yes Attend

This possible because the...