-- Chapter 3: The Midnight Query
BEGIN TRANSACTION Shadow_Chase;
-- Shadow approaches her car, noticing an anomaly in the shadows
DECLARE @VampireLocation VARCHAR(50);
SET @VampireLocation = (SELECT TOP 1 Location
FROM Vampire_Registry
WHERE Name = 'Jaq'
AND Status = 'Missing');
IF @VampireLocation IS NULL
BEGIN
PRINT 'Error: No vampire detected. Possible deception or mischief.';
INSERT INTO Shadow_Thoughts (Thought)
VALUES ('Why is he always late? Is this a trap?');
END
ELSE
BEGIN
PRINT 'Vampire located. Engaging pursuit protocol.';
INSERT INTO Shadow_Actions (Action)
VALUES ('Start engine, follow shadow coordinates.');
END;
-- Unexpected join with the local bar patrons table
SELECT p.Name, p.Beverage
FROM Local_Patrons p
JOIN Shadow_Path s ON p.Location = s.Current_Spot
WHERE s.Target = 'Jaq';
-- Shadow realizes something is off, triggering her internal debug mode
RAISERROR('Warning: Temporal anomaly detected. Vampire is not where coordinates indicate.', 16, 1);
COMMIT TRANSACTION Shadow_Chase;