Crazy idea... redefine key in target database, make it 22 chars in lenght.

If by "query analyzer" you mean a gui interface that allows you to type in, save, retrieve, edit a query then submit it for execution and show back result set...

george.greiner (4/16/2010)

---

I really have the freedom to do what I want but I believe it is best to do it in a standard way that will function just as well...

sort in descending order by unique-key combination of columns and date

keep top 1 or each group defined by you unique-key combination of columns.

Ninja's_RGR'us (4/15/2010)

---

Here's 1 exemple. I needed to keep the date updated / added and by whom on that table. On top of that I needed a deleted flag...

Jitendra Luniya (9/5/2008)

---

I think SQL Server cube data is stored physically on disk. This is because the cube will hold pre-aggregated data across the specified diemnsions. If the data is...

Yes. Oracle...

Primary Keys are enforced by a unique index.

A purist data modeler would...

Look at Books Online a.k.a. BOL in the SQL Server box - that will be your primary source of documentation.

Yes. Syntax is sound.

Most probably you want to shows us the full statement as well as the full error, don't you? 🙂

This is either homework or one of the top five most weird business specs I've ever seen.

By the way, there is not such a thing as a cell in an...

Who said that?

Documentation Paul provided clearly reads "master" database 😉

Don't...

Mia G (4/14/2010)

---

... as soon as I hit post I got this "crazy" idea to check profiler. Of course, as soon as I did I found an event for (yes,...