I can only say: THANKS A LOT!!

This helped me and I will set it up the same way,

Erik

I'm very happy you are giving me all these information. I think I should tell you what my intentions are and why I came up with this not so smart...

Hello Tim,

Actualy I was thinking of generating tables in production environment, but I guess I should reconsider. Thanks for the advice and I will leave this olution path.

Erik

Hi,

Just what I needed thanks!!

Erik

Of course I mean:

INSERT table1(*) VALUES(*) FROM table 2

Erik

Hello Karl,

Thanks for your reply. I don't get you completely. Is sp_executesq an existing stored procedure? I think not. How do I 'run' the command in @CmdStr?

Erik

Hi Gift, Thanks again, but also there was not what I was looking for. I finally found the solution in the following site:

http://blogs.msdn.com/jgalla/archive/2005/09/13/464881.aspx

This creates an ASSEMBLY that retrieves a...

Hello Marshall,

I already took alook at this, but it all seemed to work for local XML files. I want to do it for an XML file that is located on...

Sorry the second table should be:

create table data ( id1 INT, str VARCHAR)

insert x (id1,str ) values (1, 'word1')

insert x (id1,str ) values (2, 'word2')

insert x (id1,str ) values (3, 'word3')

insert x...

Yep, you are right.

Sorry, to botter you. I solved it now.

Erik

Dear Gift,

I found this walkthrough myself as well, however the thing I need is described but doesn't seem to work. It says that I should change autogrowth to "restricted growth...

Dear Gift,

Thank you for your reply. I took a look at the links, but I don't see really how to use the sorted list, to get my 'fuzzy grouping' operational....

Hello Ryan,

Thanks for your answer. I have real problems in deciding when to use T-SQL or when to use another programming language.

The problem I am solving is the following: