Your description of the problem alone is not clear enough. Since the question is essentially how to develop the DDL for the table and SQL query, let us know how...

For the past several years I've stuck this convention: I name my tables after singular nouns, and if the primary key is a system assigned integer (ex: identity), then that...

obarahmeh (10/19/2008)

---

Dear all,

If this number " 4690573010" is the result of a sql statement: what should I do to retrieve this number in the following format:

469.057.301.0

I mean: add a...

A couple of years ago, I had the files located under my wife's My Documents folder encrypted using Windows Encrypted File System (EFS). Then one day it somehow got corrupted...

There are some DBAs who do nothing but provision servers and disk storage, schedule backups, etc. You may see that in a large organization like Google where there are hundreds...

Craig Farrell (7/14/2011)

---

Eric M Russell (7/14/2011)

---

If a primary key occurs in another table, then I most always create a foreign key relationship, and if there is a simple business rule...

If a primary key occurs in another table, then I most always create a foreign key relationship, and if there is a simple business rule that can be applied to...

Sometimes I use DRI but most of the time I do not.

When DRI is used, it makes truncating tables difficult. You need to do them in a very specific...

I don't think that knowing from memory the syntax for infrequently used T-SQL statements and admin commands is relevent. However, I do expect a candidate to complete the following test...

Freddie-304292 (7/13/2011)

---

I get really annoyed by interviewers who expect you to know every bit of syntax off the top of your head and don't accept answers like the above. ...

I think that employers, clients, and managers appreciate when an IT professional openly admits what they don't know while still demonstrating what they actually do know. When I've done job...

A data warehouse is a database that consolidates data across the entire enterprise or organization. The database should be nonvolatile, meaning that data which is updated or deleted in the...

GSquared (7/12/2011)

---

First, datareader and datawriter are dangerous rights to have to grant. Given that you sometimes have to do so, to accommodate poorly designed applications, you have to recognize...

IceDread (7/11/2011)

---

Eric M Russell (7/11/2011)

---

IceDread (7/11/2011)

---

GSquared (7/11/2011)

---

IceDread (7/11/2011)

---

Changing from sa to a new user should always be done.

However, having said that, it does not offer much if the new users...

IceDread (7/11/2011)

---

GSquared (7/11/2011)

---

IceDread (7/11/2011)

---

Changing from sa to a new user should always be done.

However, having said that, it does not offer much if the new users rights is not properly...