Select f.ID
FROM tblFeedback f 
Inner Join tblPerformance p 
Inner Join tblUsers u On u.userID = p.employeeID1
On p.performanceID = f.performanceID
Where f.ID = $feedbackID

8ender fucked around with this message at 05:54 on Dec 2, 2010

CREATE TABLE People 
(
	name VARCHAR( 4 ) NOT NULL,
	PRIMARY KEY (name)
);
GO

CREATE TABLE Friends 
(
	person1 VARCHAR( 4 ) NOT NULL,
	person2 VARCHAR( 4 ) NOT NULL,
	uniquecompound AS CASE
				WHEN person1 < person2
				  THEN person1 + person2
				ELSE person2 + person1
			  END UNIQUE,
	PRIMARY KEY ( person1, person2 ),
	FOREIGN KEY ( person1 ) REFERENCES People( name ) ON DELETE CASCADE,
	FOREIGN KEY ( person2 ) REFERENCES People( name ),
	CHECK ( person1 != person2 )
);
GO

CREATE TRIGGER trg_OnDeleteCascade_PeopleFriends_person2
	ON	People INSTEAD OF DELETE
AS
BEGIN

	DELETE	f
	FROM	Friends f
	INNER JOIN DELETED d
		ON	f.person2 = d.name;
		
	DELETE	t 
	FROM	DELETED d
	INNER JOIN People t
		ON	t.name = d.name;
END;
GO

SET NOCOUNT ON;

INSERT INTO People
	SELECT  'Bill'
UNION	SELECT	'Mary'
UNION	SELECT	'Adam'
UNION	SELECT	'Jeff'
UNION	SELECT	'Mark';

INSERT INTO Friends
	SELECT	'Mary', 'Bill'
UNION	SELECT  'Jeff', 'Adam';
GO

SELECT	*
FROM	Friends;
GO

INSERT INTO Friends
	SELECT	'Bill', 'Mary';
GO

DELETE FROM People
WHERE	name = 'Mary';
	
SELECT	*
FROM	Friends;
GO

DELETE FROM People
WHERE	NAME = 'Adam';

SELECT	*
FROM	Friends;
GO

DROP TABLE Friends;
DROP TABLE People;
GO

SET NOCOUNT OFF;

CREATE TABLE T1
(
	x	INTEGER	NOT NULL
);
GO

CREATE TABLE T2
(
	x	INTEGER NOT NULL,
	y	INTEGER NOT NULL
);
GO

CREATE TABLE T3
(
	y	INTEGER NOT NULL
);
GO

SET SHOWPLAN_ALL ON;
GO

SELECT	*
FROM	T1
INNER JOIN T2
		INNER JOIN T3
			ON	T2.y = T3.y
	ON	T1.x = T2.x;
GO

SELECT	*
FROM	T1
INNER JOIN T2
	ON	T1.x = T2.x
INNER JOIN T3
	ON	T2.y = T3.y;
GO

SET SHOWPLAN_ALL OFF;
GO

DROP TABLE T1;
DROP TABLE T2;
DROP TABLE T3;
GO

Avarkx fucked around with this message at 20:07 on Dec 3, 2010

magic_toaster fucked around with this message at 05:06 on Dec 15, 2010

SQL> CREATE TABLE events
  2  (eventid    NUMBER PRIMARY KEY
  3  ,employeeid NUMBER
  4  ,eventdate DATE
  5  ,statusid   NUMBER
  6  );

Table created.

SQL>
SQL> INSERT INTO events VALUES (2, 2, to_date('01/12/10','dd/mm/rr'), 9);

1 row created.

SQL> INSERT INTO events VALUES (3, 2, to_date('02/12/10','dd/mm/rr'), 1);

1 row created.

SQL> INSERT INTO events VALUES (4, 3, to_date('03/12/10','dd/mm/rr'), 9);

1 row created.

SQL> INSERT INTO events VALUES (5, 3, to_date('04/12/10','dd/mm/rr'), 1);

1 row created.

SQL> INSERT INTO events VALUES (6, 3, to_date('05/12/10','dd/mm/rr'), 1);

1 row created.

SQL> INSERT INTO events VALUES (7, 2, to_date('06/12/10','dd/mm/rr'), 1);

1 row created.

SQL>
SQL> SELECT eventid
  2        ,employeeid
  3        ,statusid
  4        ,lag(statusid) OVER (PARTITION BY employeeid ORDER BY eventdate) AS prev_statusid
  5  FROM   events;

   EVENTID EMPLOYEEID   STATUSID PREV_STATUSID
---------- ---------- ---------- -------------
         2          2          9
         3          2          1             9
         7          2          1             1
         4          3          9
         5          3          1             9
         6          3          1             1

6 rows selected.

SQL>
SQL> SELECT    employeeid
  2           ,count(*)
  3  FROM     (SELECT eventid
  4                  ,employeeid
  5                  ,statusid
  6                  ,lag(statusid) OVER (PARTITION BY employeeid ORDER BY eventdate) AS prev_statusid
  7            FROM   events
  8           )
  9  WHERE     statusid = 1
 10  AND       prev_statusid = 9
 11  GROUP BY  employeeid;

EMPLOYEEID   COUNT(*)
---------- ----------
         2          1
         3          1

Goat Bastard fucked around with this message at 06:28 on Dec 16, 2010

with RankedEvents as (
select EventId
      ,EmployeeId
      ,Date
      ,LocationId
      ,StatusId
      ,row_number() over (partition by EmployeeId order by Date, EventId) EventRank
  from EventTable
)
select RE.EmployeeId
      ,count(*)
  from RankedEvents RE
       inner join RankedEvents S9 on RE.EmployeeId = S9.EmployeeId
                  and RE.EventRank = S9.EventRank + 1
 where S9.StatusId = 9
group by RE.EmployeeId

Jethro fucked around with this message at 17:39 on Dec 15, 2010