And it may suffer from the same problem my original answer suffers, it may not work for a multi-level BOM.

And that would be correct.

Not sure how scalable this will be, but I did think of something as I was getting ready to leave for work:

create table #SortTest (

SortOrder int,

...

Thank you. I won't be able to spend much time on this at the moment, but hopefully someone else will look at the problem, or I will be able...

nick-604971 (3/25/2010)

---

Lynn,

There is one other requirement that I had totally forgot to include in the original question.

The order of the parent items should be by SortID as this will always...

AtlasAdmin (3/24/2010)

---

Hi,

I would like to set up database mirroring on a 3-server environment. The idea would be to have 2 DB servers configured as the database principle and 1 DB...

Looking for something like this?

create table #TestTable (

MarkPer char(2),

StartDate datetime,

EndDate datetime

);

insert into #TestTable

select 'M1','07/24/2009','10/02/2009' union all

select 'M2','10/20/2009','12/18/2009' union...

Looking at it again, that will only work for a simple one level attach. If you start getting into a nested hierarchy like a multi-level BOM, it won't work.

Les Cardwell (3/24/2010)

---

Jack Corbett (3/24/2010)

---

Les Cardwell (3/24/2010)

If you are doing a platform agnostic cert then Celko would work, but for a SQL Server specific cert, then he might not be...

nick-604971 (3/24/2010)

---

Hi,

I have a table of ordered products. This table contains a column ('AttachTo') that can reference the unique ID ('ItemID') of itself. This is used to define a relationship...

Represents 1753-01-01, the earliest allowed date for a datetime value iirc.

It is one aspect of security. If you only grant users access to the views and stored procedures, they don't require access to the underlying tables. It is...

Should only need execute rights on the stored procedure. There may be exceptions to that, but usuallly only if the tables in question on in another database.

Barry, glad to see you back. Hope you are feeling better, and not just because your on meds.

John Rowan (3/23/2010)

---

It's in Keystone, SD. The nearest 'big' town is Rapid City, SD, which is about 1/2 hour away. I was born just outside of Rapid City,...