"Woe to you who are well-fed now, for you shall be hungry. Woe to you who laugh now, for you shall mourn and weep.
Woe to you when all men speak well of you, for in the same way their fathers used to treat the false prophets."
Wednesday, December 20, 2006
Thursday, December 07, 2006
Disappointment
Lately I have become overwhelmingly disappointed in friends and coworkers.
COME ON PEOPLE! Step up! Do I need to hold your hand or what? THINK! DO!
- They don't do things they say they are going to do.
- They are lazy and do as little as possible.
- They bail on their responsibilities as well as others and leave them to suffer the consequences.
- They waste their own time with worthless efforts which in turn affect those around them.
- They don't make their other more critical obligations known in order for those around them to adjust and accommodate.
- They do not ensure their own responsibilities are carried out in full.
- They don't answer their phones nor do they return calls.
- They make excuse after excuse after excuse after excuse, to the point of expectation.
- They continue to bring themselves to a point where people can no longer depend on them and then they have to work themselves back into trusting relationships.
- They only think of themselves.
- They don't realize the consequences of their not doing something on others nor do they care.
- They change the subject and escape to humor.
- They seek approval in the masses at the loss and insult of others.
- They chalk it up to "o well."
- They just don't get the pattern that they are establishing with those around them.
COME ON PEOPLE! Step up! Do I need to hold your hand or what? THINK! DO!
Monday, July 10, 2006
What I do for a living...(example one)
Sometimes I write stuff like this...
-- Retrieve the EwaResponse_DMTrigger(s) that currently exist for P&G and store it in a temp table for later comparison --
CREATE TABLE #ExistingEwaResponse_DMTriggers (
EwaResponseID INT,
DMTriggerID INT,
UserID INT
)
INSERT INTO #ExistingEwaResponse_DMTriggers
SELECT
EwaResponse_DMTrigger.EwaResponseID,
EwaResponse_DMTrigger.DMTriggerID,
EwaResponse.UserID
FROM
EwaResponse_DMTrigger WITH (NOLOCK)
INNER JOIN
EwaResponse WITH (NOLOCK)
ON EwaResponse.EwaResponseID = EwaResponse_DMTrigger.EwaResponseID
WHERE
EwaResponse_DMTrigger.EwaResponseID IN (
SELECT
EwaResponse.EwaResponseID
FROM
EwaResponse WITH (NOLOCK)
INNER JOIN
Users WITH (NOLOCK)
ON Users.UserID = EwaResponse.UserID
INNER JOIN
Site WITH (NOLOCK)
ON Site.SiteID = Users.SiteID
WHERE
Site.CompanyID = 474)
ORDER BY
EwaResponse_DMTrigger.EwaResponseID DESC
---------------------------------
-- Execute spGetDMForm for all P&G EwaResponse(s) --
DECLARE
@EwaResponseID INT,
@UserID INT
DECLARE
LOOPYcursor CURSOR FOR
SELECT
EwaResponse.EwaResponseID,
EwaResponse.UserID
FROM
EwaResponse WITH (NOLOCK)
INNER JOIN
Users WITH (NOLOCK)
ON Users.UserID = EwaResponse.UserID
INNER JOIN
Site WITH (NOLOCK)
ON Site.SiteID = Users.SiteID
WHERE
Site.CompanyID = 474
ORDER BY
EwaResponse.EwaResponseID DESC
OPEN LOOPYcursor
FETCH NEXT FROM LOOPYcursor INTO
@EwaResponseID,
@UserID
WHILE @@Fetch_Status = 0
BEGIN
EXECUTE [dbo].[spGetDMForm] @EwaResponseID, @UserID, null
FETCH NEXT FROM LOOPYcursor INTO
@EwaResponseID,
@UserID
END
CLOSE LOOPYcursor
DEALLOCATE LOOPYcursor
---------------------------------
-- Retrieve the EwaResponse_DMTrigger(s) that are new for P&G --
SELECT
CurrentEwaResponse_DMTrigger.EwaResponseID,
CurrentEwaResponse_DMTrigger.DMTriggerID,
CurrentEwaResponse_DMTrigger.UserID
FROM
(
SELECT
EwaResponse_DMTrigger.EwaResponseID,
EwaResponse_DMTrigger.DMTriggerID,
EwaResponse.UserID
FROM
EwaResponse_DMTrigger WITH (NOLOCK)
INNER JOIN
EwaResponse WITH (NOLOCK)
ON EwaResponse.EwaResponseID = EwaResponse_DMTrigger.EwaResponseID
) AS CurrentEwaResponse_DMTrigger
WHERE
CurrentEwaResponse_DMTrigger.EwaResponseID IN
(
SELECT
EwaResponse.EwaResponseID
FROM
EwaResponse WITH (NOLOCK)
INNER JOIN
Users WITH (NOLOCK)
ON Users.UserID = EwaResponse.UserID
INNER JOIN
Site WITH (NOLOCK)
ON Site.SiteID = Users.SiteID
WHERE
Site.CompanyID = 474
)
AND NOT EXISTS
(
SELECT
EwaResponseID,
DMTriggerID,
UserID
FROM
#ExistingEwaResponse_DMTriggers
WHERE
#ExistingEwaResponse_DMTriggers.EwaResponseID =
CurrentEwaResponse_DMTrigger.EwaResponseID
AND #ExistingEwaResponse_DMTriggers.DMTriggerID =
CurrentEwaResponse_DMTrigger.DMTriggerID
AND #ExistingEwaResponse_DMTriggers.UserID =
CurrentEwaResponse_DMTrigger.UserID
)
ORDER BY
CurrentEwaResponse_DMTrigger.EwaResponseID DESC
---------------------------------
-- Drop the temp table created --
DROP TABLE #ExistingEwaResponse_DMTriggers
---------------------------------
-- Retrieve the EwaResponse_DMTrigger(s) that currently exist for P&G and store it in a temp table for later comparison --
CREATE TABLE #ExistingEwaResponse_DMTriggers (
EwaResponseID INT,
DMTriggerID INT,
UserID INT
)
INSERT INTO #ExistingEwaResponse_DMTriggers
SELECT
EwaResponse_DMTrigger.EwaResponseID,
EwaResponse_DMTrigger.DMTriggerID,
EwaResponse.UserID
FROM
EwaResponse_DMTrigger WITH (NOLOCK)
INNER JOIN
EwaResponse WITH (NOLOCK)
ON EwaResponse.EwaResponseID = EwaResponse_DMTrigger.EwaResponseID
WHERE
EwaResponse_DMTrigger.EwaResponseID IN (
SELECT
EwaResponse.EwaResponseID
FROM
EwaResponse WITH (NOLOCK)
INNER JOIN
Users WITH (NOLOCK)
ON Users.UserID = EwaResponse.UserID
INNER JOIN
Site WITH (NOLOCK)
ON Site.SiteID = Users.SiteID
WHERE
Site.CompanyID = 474)
ORDER BY
EwaResponse_DMTrigger.EwaResponseID DESC
---------------------------------
-- Execute spGetDMForm for all P&G EwaResponse(s) --
DECLARE
@EwaResponseID INT,
@UserID INT
DECLARE
LOOPYcursor CURSOR FOR
SELECT
EwaResponse.EwaResponseID,
EwaResponse.UserID
FROM
EwaResponse WITH (NOLOCK)
INNER JOIN
Users WITH (NOLOCK)
ON Users.UserID = EwaResponse.UserID
INNER JOIN
Site WITH (NOLOCK)
ON Site.SiteID = Users.SiteID
WHERE
Site.CompanyID = 474
ORDER BY
EwaResponse.EwaResponseID DESC
OPEN LOOPYcursor
FETCH NEXT FROM LOOPYcursor INTO
@EwaResponseID,
@UserID
WHILE @@Fetch_Status = 0
BEGIN
EXECUTE [dbo].[spGetDMForm] @EwaResponseID, @UserID, null
FETCH NEXT FROM LOOPYcursor INTO
@EwaResponseID,
@UserID
END
CLOSE LOOPYcursor
DEALLOCATE LOOPYcursor
---------------------------------
-- Retrieve the EwaResponse_DMTrigger(s) that are new for P&G --
SELECT
CurrentEwaResponse_DMTrigger.EwaResponseID,
CurrentEwaResponse_DMTrigger.DMTriggerID,
CurrentEwaResponse_DMTrigger.UserID
FROM
(
SELECT
EwaResponse_DMTrigger.EwaResponseID,
EwaResponse_DMTrigger.DMTriggerID,
EwaResponse.UserID
FROM
EwaResponse_DMTrigger WITH (NOLOCK)
INNER JOIN
EwaResponse WITH (NOLOCK)
ON EwaResponse.EwaResponseID = EwaResponse_DMTrigger.EwaResponseID
) AS CurrentEwaResponse_DMTrigger
WHERE
CurrentEwaResponse_DMTrigger.EwaResponseID IN
(
SELECT
EwaResponse.EwaResponseID
FROM
EwaResponse WITH (NOLOCK)
INNER JOIN
Users WITH (NOLOCK)
ON Users.UserID = EwaResponse.UserID
INNER JOIN
Site WITH (NOLOCK)
ON Site.SiteID = Users.SiteID
WHERE
Site.CompanyID = 474
)
AND NOT EXISTS
(
SELECT
EwaResponseID,
DMTriggerID,
UserID
FROM
#ExistingEwaResponse_DMTriggers
WHERE
#ExistingEwaResponse_DMTriggers.EwaResponseID =
CurrentEwaResponse_DMTrigger.EwaResponseID
AND #ExistingEwaResponse_DMTriggers.DMTriggerID =
CurrentEwaResponse_DMTrigger.DMTriggerID
AND #ExistingEwaResponse_DMTriggers.UserID =
CurrentEwaResponse_DMTrigger.UserID
)
ORDER BY
CurrentEwaResponse_DMTrigger.EwaResponseID DESC
---------------------------------
-- Drop the temp table created --
DROP TABLE #ExistingEwaResponse_DMTriggers
---------------------------------
Thursday, June 22, 2006
Monday, June 05, 2006
A Painful Day
Today it physically pains me to be at work and listening to the conversations that are going on.
Subscribe to:
Posts (Atom)
