Wow, Why make it hard when it can be easy. I was close, but so far away.

Thank you so much!

That's where I'm unsuccessful. I've tried group by and made a cursor, but I always get the same results.

I tried making a cursor, but it gave the same results, so I obviously did something wrong here.

What's new in this question is that I have included all the possible...

I've almost got it now, but I have one more problem. I need to get the results for each saletype on one row for each saletype_id. I now get 5...

Sorry, I don't understand. The name and Tooltip column can be up to 239 characters long, actually up to 4048 characters using extended tables.

Can you explain how you got to...

hmmm. maybe we have >20 lists but maybe I can use the same temp #table as in my post. I still need help with the string manipulation to extract...

There is a limit but there will be a different number of languages in different lists. So I will need to search for a value ex US: and return the...

In my specific problem was that the value I'm looking for has 8 characters where the first 2 are alfabetical letters and the 8th character is a 1.

Thank you that was perfect. I was looking for something really difficult, your solution was simpler and elegant

Yes That work great. A friend suggested to replace DATALENGTH with LEN, and that worked as well.

use tempdb IF OBJECT_ID('tempdb..[Dokument$]','U')IS NOT NULL DROP TABLE [Dokument$]

CREATE TABLE [dbo].[Dokument$]([IDKEY] [nvarchar](255) NULL,[OFFERT]...

There is a big difference between nvarchar and varchar i now understand. Using varchar, it works pervectly. Thanks agan all who have helped me on this question:

This is the script...

Why doesn't this work? The CROSS APPLY suggestion is closest to what I need (I don't want the trailing \ in the path.) Testing your exempel works fine but when...

I have now read the info at http://www.sqlservercentral.com/articles/Best+Practices/61537/

And saw by your exampel how to post code. I will use these tips for future posts. Thanks for the advice!

Absolutly amazing! Thank you all so much

Both your suggestions worked! Than You!!

Could you help me with the next issue: I would like the full path in one column AS Path and the document name in another...