SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Need simple SQL for grooms cake! Please HELP!
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

groomsman
Starting Member

USA
1 Posts

Posted - 03/16/2013 :  10:38:06  Show Profile  Reply with Quote
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

USA
5071 Posts

Posted - 03/16/2013 :  14:17:13  Show Profile  Visit russell's Homepage  Reply with Quote
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.

Edited by - russell on 03/16/2013 14:17:52
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000