Confuse it not, data with presentation ! Different they are!

A true jedi will not let the presentation of the data confuse him with the value stored.

Stored data, no format...

Relationships are a true tool of the Jedi.

Not to be taken lightly! Created once, they must be. Not altered or maintained day to day. Set in stone!...

hmmmm. Complicated replies, indeed.

The answer, as always, depends: This data, how it is stored? Properly or not?

More information, you must provide.

Ah, an INSERT you seek.

A SELECT it is, only with a clear destination ! No difference otherwise!

The same syntax applies:

INSERT INTO DestTable

SELECT ID, (SELECT .. FROM SomeOtherTable WHERE ..)...

Avoid reserved words, you should.

If avoidable it is not, then seek the power of the proper delimiter. Result desired, square brackets will provide:

select [order] from yourtable

A true jedi will...

Dynamic SQL, there is no need.

A user-defined function, trivial to write, returns results desired.

Seek and you shall find the answer:

http://www.sqlteam.com/item.asp?ItemID=11499

SQL injection, a serious possibility. Avoid it you...