Random Nerdiness...

Feb 23, 2007 21:28

SELECT TOP 3 Food.* INTO Stomach FROM (Refrigerator INNER JOIN Pantry ON Refrigerator.Shelf = Pantry.Shelf) WHERE ((Food.Taste >= " & DLookup("[TasteValue]", "[Tastes]", "[Taste] = 'Good'") & " AND (DateDiff(dd, Food.Date_Purchased, GetDate()) <= 7))

Leave a comment

Comments 8

thechiaroscuro February 24 2007, 06:45:57 UTC
Your nerdiness isn't as random as you might think. Just sayin', is all.

;o)

Reply


panzerkaetzchen February 24 2007, 07:15:02 UTC
A most appropriate usage of SQL statements. I approve.
*high five*

Reply

mentalswitch February 24 2007, 18:55:17 UTC
delete from friends where user_id in (select user_id from livejournal_posts where livejournal_post_inspiration_conversation_id in (select conversation_id from discussion inner join people where discussion.user_id = people.user_id and people.user_id = 'dan' and conversation.credit_to_user_id != 'dan')

Reply

panzerkaetzchen February 25 2007, 02:13:38 UTC
:)

Reply

statikimperium February 25 2007, 06:43:55 UTC
Option Explicit
Public Function Apology() As Object
Dim strSQL As String, Accepted As Boolean
strSQL = "UPDATE Public_Record.Statements SET Apology = True WHERE ((Conversations.PersonID = " & DLookup("[Person_ID]", "[Friends]", "[Name] = 'Dan'") & ") AND (Conversations.Inspiration <> 'Me') AND (Conversations.Date = #02/23/2007#) AND (Conversations.Topic = 'SQL'))"
Do Until Accepted = True
DoCmd.RunSQL strSQL
Loop
Resume Friendship
End Function

Reply


killermeteor February 27 2007, 18:19:31 UTC
I'm glad you have time for that and none to help a friend move.

A friend who has helped you move, I might add.

I hope that you're ashamed of yourself young man.

; )

Reply


nemfx July 30 2007, 00:58:52 UTC
Hello, I have a question for you.

Forgive me if I phrase this awkwardly, but it's my first time having to ask this..

I'm gradually drawing a huge poster of all SORP agents, so I was wondering what you'd want to be armed with and what you'd want to be wearing.

I'm trying to ask all of the SORP agents this, so if you know any that don't bother doing things online often, can you help spread the word?

Thanks in advance :)

Reply


Leave a comment

Up