I understand that you have hundreds of tables, and you want to "form relationships" between them. Could you describe in more detail what the objective is?

I'm thinking that this is...

-- Here is the setup:

declare @sample table (RecID int, RecType int, Hierarchy int, Msg char(1));

insert into @sample Values (1, 5555, 10, null );

insert into @sample Values (2, 5555, 20, null...

If you get them all to line up nose to rear, then you're lucky. It's been said that managing IT developers is like trying to herd cats.

-- create and insert a table variable containing missing numbers.

declare @missingnumbers table (n int not null primary key);

insert into @missingnumbers

select 1 union select 2 union select 4 union select 5...

Would simply adding this additional condition give you what you need?

.. and right(origin_tracer_no,2) <> 'No'

Management in the IT industry is different from other industries. If you look at the resume of IT managers, you'll see that most of them actually do not have a...

A clustered index on column(s) containing non-sequential data is one explanation for extremely poor performing inserts and updates. With a clustered table, SQL Server clusters the data pages (basically like,...

I've never liked the idea of creating foreign key constraints with the cascade UPDATE/DELETE option. Let's assume that a misguided developer is trying to insert/update data in the INV_STATUS dimension...

The technical puzzle proposed in this discussion is interesting, but it has obviously run it's course. I'm interested about why you would need to know the "last" value inserted into...

Here is a well illustrated primer on SQL joins by Pinal Dave, one of the best SQL Server bloggers.

http://blog.sqlauthority.com/2009/04/13/sql-server-introduction-to-joins-basic-of-joins/

The specific situation you present here, which is parsing...

Yes, you can index a partitioned view. There are some requirements, like all tables must be in the same database and there must be a unique clustered index, which you...

You are always going to have locks of one type or another. I guess the real problem you're wanting to describe is that you're encountering blocks on your DML statements....

Simply get the IDs into a table variable, and then the problem is solved.

I encounter this scenario a lot with stored procedures, typically developed for reporting purposes, which accept a...

The last value inserted into your table was 'Snoopy'. Prove me wrong.

Seriously, without a date/time column, or at least a sequential identifier, there is no deterministic way to know...