Subqueries, CTEs, or inline TVFs. Views need to be a single statement. Also remember views aren't encapsulated result sets unless you turn them into indexed views. Any...

Dehqon D. (11/11/2010)

---

Thank you very much bro, it's working pretty well, just little problem is my supervisor asked me not to use temp table, as there gonna be huge DB,...

The reason is there is no rownumber as oracle would describe it, and even using a standard identity column wouldn't help in the case of multiple doclinks.

This is what I...

It'll probably blow up, depending on your machine. ...

Not the cleanest in optimization because of the multiple correlated subqueries, but this will get you on your way I believe. I used a second cte to trim down...

Unfortunately Digs, the running totals bit is not a simple...

New post in case of a cross post.

To answer your question more specifically as to what happened with the 6 rows, is this:

select FamilyName, ChildName, CarName

from @FamilyMember f

join @Kids k...

Ed Srdoc (11/10/2010)

---

My apologies.

I may have been put off by your initial response that ended in, 'We're not here to do your homework'. Maybe that wasn't directed at me....

WayneS (11/10/2010)

---

Actually, once the OP explained him/her self, I can see where they copped that attitude - the "We're not here to do your homework"...

Must be the week...

http://www.sqlservercentral.com/Forums/Topic1019000-392-1.aspx

kiranjanjanam (11/10/2010)

---

Thanks guys for your replies...

After seeing the posts, I think its the log backups taken out of log shipping that is breaking the log shipping.

i will communicate with the...

A) Code compiled just fine...

Modified slightly because I avoid restricted names like the plague, and you left an extra UNION ALL in there. 🙂

Mind you, you're going to probably have to extrapolate from this...

The short version is you've got your relationships all twisted up. You're not chaining ChildID into the cars table, you're chaining familyID, which is causing you to link 2*3...

Sorry, doublepost.