You haven't said anything about What happens if both ranges are overlapped or similar  nor what is the pk of the table so under too many assumptions I am going...

I strongly suggest you to leave that to the Presentation (Report or Client app) side. But just for the fun of it here is an example on how to do...

 tymberwyld, You are correct and the rest are also correct just you are both talking about different things. Table-value functions are executed...

There are A LOT of things left out here:

1. If your stored procedures are supposed to carry out the audit trail capabilities you will be MIXING Audit Logic with Business like...

If you plan to follow the above Idea do it

THIS WAY:

CREATE PROCEDURE MasterXRef

AS

CREATE TABLE XRef123 (recordID int NULL,.. etc)

CREATE TABLE XRef456 (recordID int NULL,.. etc)

INSERT INTO XRef123 EXEC sp_XRef123

INSERT INTO XRef456 EXEC...

personally I prefer lower case  too

Well if you are doing all that, then just save a link to the xml file and let the client side do the XPath if needed 

Anyways glad you make it work...

I am sorry to be a bad news delivery boy but this is how it goes:

1. Text Columns are one of the most Inflexible features in SQL Server

2. It is impossible...

You may say what you want but IMHO EVERYTHING gets a hit when an autogrow happens. Maybe not on a toy 1mb database but on realworld 100GB+ you will for...

I don't understand very well what you are trying to accomplish but this is shot in the dark

CREATE TRIGGER [HelpdeskNewUser] ON dbo.Helpdesk

AFTER INSERT

AS

if @@ROWCOUNT = 0

return

set nocount on

INSERT...

I am going to code what you asked for just for the fun of it but I STRONGLY recommend you to redesing your tables to a 3NF

Note that there can not...

Actually is doing exactly what you told it to. One month means that if you change the month on the same date and that date exists then it should return...

I don't know what you meant by "distributing" but may i suggest you PRINT the diagram to PDF with adobe pdf writer? If all you want is to document the...

you mentioned that you are using stored procedures. There are a couple of things you can do.

1.Add an extra parameter to them for enabling/disabling logging. create a logging table and...

I personally have tried with 4 concatenation of nvarchar(4000) and it WORKS