Tweeting AdventureWorks?

Earlier this week, the gravitational pull of Twitter got the better of me. Jimmy May emailed me that Paul Nielsen was trying to sort out the gender of the fictitious IT Manager of AdventureWorks (Jean Trenary) for the next edition of the SQL Server Bible and was tweeting on the subject. One thing led to another. (Doesn’t it always?)

I vaguely recall signing up for Twitter as “reedme” but twitter doesn’t seem interested in sending me a forgotten password for that user name... so I reverted to an older, darker user name for tweeting: DarthReed. Just so you know. More useless information is now available on the web with even greater frequency.

Anyway, here are the queries for anybody else who cares. First for the old school AdventureWorks OLTP database (with thanks to Gail in UE for writing the first one):

USE AdventureWorks
GO
SELECT c.FirstName , c.LastName, e.Title, e.Gender
FROM HumanResources.Employee as e
JOIN Person.Contact AS c ON e.ContactID = c.ContactID
WHERE LastName = 'Trenary'
GO

And then my “port” for the AdventureWorks2008 OLTP database (will like be the same for AdventureWorksKilimanjaro):

USE AdventureWorks2008
GO
SELECT c.FirstName , c.LastName, e.JobTitle, e.Gender
FROM HumanResources.Employee as e
JOIN Person.Person AS c ON e.BusinessEntityID = c.BusinessEntityID
WHERE LastName = 'Trenary'
GO

If my adventures in Twitter last beyond the end of my “trial month”, I’ll have to break down and figure out how to feed them into the sidebar of the blog.