Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Need simple SQL for grooms cake! Please HELP!

Author  Topic 

groomsman
Starting Member

1 Post

Posted - 2013-03-16 : 10:38:06
I am trying to get a grooms cake made for a friends wedding and I need a SQL statement for the top of it... Something geeky romantic that will include the bride and grooms names, the wedding date, the words love and cherish, and so on. I don't write code and this is a surprise. I want it to be correct so that if anyone is there who understands sql statements they don't tell the groom "dude... your code sucks!"

Anyone willing to help?

"Its not a bug its... a feature"

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2013-03-16 : 14:17:13
Wow, that is geeky

SELECT John.loves, Mary.Cherish, '2/14/2013' as Wedding
FROM John
JOIN Mary
On John.Honor = Mary.Care
WHERE John.Loves = Mary.Loves
And forever = 'TRUE'

or

SELECT John, loves, cherishes, forever FROM him
UNION
SELECT Mary, loves, worships, always FROM her


Gotta have either JOIN or UNION or both in there.
Go to Top of Page
   

- Advertisement -