You know, the people that help out here are all un-paid volunteers, so please HELP US HELP YOU. Providing the DDL scripts (CREATE TABLE, CREATE INDEX, etc.) for the tables...

Check out the articles in my signature on Cross Tabs and Pivot Tables (Parts 1 and 2). This should give you all the information you need.

In that case, you ought to read Grant Fritchey's books. He has another one coming out soon, with updates.

If you look at the actual execution plan, you'll see that the second method is more efficient. However, the execution plan also doesn't show any activity for the OBJECT_ID() call.

If...

What constitutes logging "In" or "Out"? The Direction column? If so, which value maps to which?

or do you just want to change the current IsCorrect column to be either 1...

You're welcome.

I was just looking at this again, and I think that the first part should...

Or do you want it as:

Result = CASE WHEN Excellent = 1 THEN 'Excellent'

WHEN Good =...

miss.delinda (5/23/2011)

---

My mistake. My table as following,

declare @tMenuCollection table(idx int,parentID int,menuNme varchar(50),navigateUrl varchar(50));

insert into @tMenuCollection values(1,0,'Bayar Zakat','void(0)');

insert into @tMenuCollection values(2,0,'Amil','void(0)');

insert into @tMenuCollection values(3,0,'Kira Zakat & Simpan','void(0)');

insert into @tMenuCollection values(4,3,'Tambah','void(0)');

insert into...

bitbucket-25253 (5/23/2011)

---

bitbucket-25253 (5/23/2011)

---

WayneS (5/23/2011)

---

bitbucket-25253 (5/23/2011)

---

A plea for assistance, from the denizens of the thread.

QOD - easy enough to display the page to create and submit etc., etc.

When the...

The things that I see:

1. The update statement for Test1 is only firing with Rem >= Req. It needs to always fire, and to be smart enough to know when...

How does this work out? Check out this BOL link for how it this recursive common-table-expression works.

;

WITH cte AS

(

SELECT t1.idx,

t1.parentID,

...

bitbucket-25253 (5/23/2011)

---

A plea for assistance, from the denizens of the thread.

QOD - easy enough to display the page to create and submit etc., etc.

When the submittal page displays...

And http://www.sqlservercentral.com/Forums/Topic1112958-145-1.aspx

And http://www.sqlservercentral.com/Forums/Topic1112958-145-1.aspx

MM - Lots! of good questions. I'm sorry that I don't have an answer for you, just what I barely remember from a while back.