>> When using intervals, you should NEVER use NULL values in the intervals, because it makes it much more complicated to do the calculations. I've replaced your NULL values with...

There are some standards for naming data elements in RDBMS.. Look at the Metadata Committee, and ISO 11179 standards. The basic principle, however, is that you should name something for...

I don't want a hierarchical REFERENCES clause (I am not even sure what that would mean) . But by putting the nodes in one table that reference and the nodes...

>> here is my data. I am trying to get the dates in single row like below. Any help appreciated. <<

The help you need is to actually learn how to...

I've always felt that it was worth it to pay for a second audit tool that is external to the database. Auditing in the same database mixes both data and...

>>> have two tables, both the tables have 4 common columns,

First Column: linking_id

Other four columns(Name, Department, City). <<

Please explain how you can have a first column, since tables have no...

>> I need some help with my query. Want to change numbers to 0 if the row is a duplicate record [sic: rows are not records] based on the uniqueness...

I'm not quite sure why you need a hierarchy, I'm going to take a guess. One of the many advantages of a nested set model is that you should separate...

>> Now it is you that is putting words in my mouth. ?? That's not what I said. <<

No I think you misread, this principle is from Brent Ozar. I...

>> I'll add that it's a good great book (although I've not read the latest one). <<

Unfortunately, there's only been one edition. Oh well, it still sells and I get...

I've written an entire book on various methods for modeling treason hierarchies and SQL. Get a copy and see which technique is most appropriate for your particular situation.

>> I have a table with 2 fields [sic] DocumentID and ArrivedDate. <<

You might want to actually read the standards for SQL. A field is a subset of a column,...

One of my favorite horror stories goes back to the days of green bar paper and mainframes. The Army base printed out a phone directory on green bar paper every...

Many years ago, Fabian Pascal wrote a book entitled "SQL and Relational Basics", whose title explains its intent and contents. It was published in 1990, and very much shows its...

>>Joe, if the indexing is setup correctly, wrapping the ENDDATE in a COALESCE() can cause a range scan (at best) instead of a SEEK because it makes that part of...