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.
| Author |
Topic |
|
rigidBoy1992
Starting Member
11 Posts |
 Posted - 2014-11-19 : 12:02:04
|
| ID in Person table is fk to Member tableperson==>ParentMemeber==> Childso ID is commonSlim Shady |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
rigidBoy1992
Starting Member
11 Posts |
Posted - 2014-11-19 : 12:18:43
|
| Hi Taraq==> What are the full names (first name, a space, and last name) of Members that joined the club in 2012? Show them in chronological order by the date they joined. This what I had so far==>SELECT COALESCE(FirstName + ' ','') + COALESCE(LastName,'') AS FullName FROM Person SELECT DateJoined FROM Member WHERE datepart(YYYY, DateJoined)='2012' ORDER BY DateJoinedSlim Shady |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Response