Correct... in a properly designed database, the assemblies and sub-assemblies would not only be separated, but they would be "normalized" as well.  Separate table would also be present to identify...

That's why I'm saying you've gotta normalize it... you can submit the answers to the questions all at the same time, just not all in one row.  Your current design...

I guess I should explain the other reasons why this is gonna "suck" and why I don't think this resembles a relational database... you're using RBAR (pronounced "ree-bar" and is...

Heh... we had something similar that a 3rd party built into their part of our database... 640 average deadlocks per day with spikes to 4,000

Even though SQL Server 2000 doesn't have a pivot function, it's pretty darned easy to make one.  So, don't let the lack of a pivot function make you do something...

Heh... it wouldn't be just me that gets annoyed... some folks get downright rude about cross posting.

Anyway, glad to help and thanks for the feedback.

Thanks for the example of what this type of sort might be used by... brought back some memories of how the Navy designates assemblies and sub-assemblies (A4A1A13CR5).  Also, might need...

CROSS POST... see the following

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=338&messageid=376138&post=true

First, it really ticks folks off when you double post like you did... this is one place where you do need to put all your eggs in one basket... keeps...

A bit late with a response... but you do understand that temp tables are automatically dropped when the session that created it ends?

Just to add to the above... In SQL Server 7.0...

If neither Item 4 or 8 are set, that's the equivelent to FULL recovery.

IF Item 4 is set and Item 8...

Ah... got it... sorry, Remi... thought you lost your mind for a minute   I should have known better.

Bill,

Slight "lull" in the action here so I thought I'd check... was your question answered or did you have something else in mind?  And, I didn't get the chance to...

Heh... thanks for the feedback, David.

Substitute your date column or date variable for GETDATE() in the following...

 SELECT DATEADD(yy,DATEDIFF(yy,0,GETDATE()),0)