Forum: MS SQL  Feb 21st, 2008 |
| Replies: 2 Views: 2,937 No need for all the separate hits/queries.
SELECT EmpID, EmpName, DATEPART(m, DateOfBirth) As bmon, DATEPART(d, DateOfBirth) As bday FROM PersonalDetails WHERE DATEPART(d, DateOfBirth) BETWEEN... |
| Forum: MS SQL Feb 21st, 2008 |
| Replies: 2 Views: 619 Question, why is your subcategory in your category table? Currently it is like this:
Category
/ \
Photos Subcategory
Why don't you make it like this:
Category... |
