Sean Lange

😀 thank you for correcting me (#Temp) I appreciate it.

Luis Cazares

I did go through the link and funtion (DelimitedSplit8k). learned for more things. Thank you

Thank you Praveena this did the job. 🙂

Only it gave an exception if there was a "&" character in the cell, however they were only 5 records like this which...

This did work.. 🙂 🙂

This was new learning experience..

Thank you..

You are right.. I have made the changes there is a key column on which it depends on..

hierarchy first from text from table 1 then from table 2 (this does...

.

Try this Kendra, will check back tomorrow (loging off 🙂 ) have a good day..

SELECT DISTINCT "INP1"."INP1_CATEGORY",

"INC1"."INC1_CASE_NO_1", "INC1"."INC1_CASE_NO_2", "INC1"."INC1_OCC_DATE_1", "INC1"."INC1_OCC_DATE_2", "INC1"."INC1_DOW_1", "INC1"."INC1_STATION_A", "INC1"."INC1_STATION_B", "INC1"."INC1_AT_BETWEEN", "INC1"."INC1_LINE_COLOR", "INC1"."INC1_DIRECTION", "INC1"."INC1_LOC_ST_NO", "INC1"."INC1_LOC_ST_NAM", "INC1"."INC1_LOC_X_ST",...

🙂

Is the "INP1_CATEGORY" column different or any column different

while these table are repeating..

INC_CASE_NO_1

INC_CASE_NO_2

INC_OCC_DATE_1

INC_OCC_DATE_2

INC1_DOW_1

INC1_STATION_A

I did edit the query in the above reply.. Copy past it and try again..

Please try it again :doze:

hey not clear as to what result are you wanting to see.. 😉

Hi Kendra.gentry try this and let me know if you got the result your looking for(avoid duplicates)

SELECT "INP1"."INP1_CATEGORY", "INC1"."INC1_CASE_NO_1", "INC1"."INC1_CASE_NO_2", "INC1"."INC1_OCC_DATE_1", "INC1"."INC1_OCC_DATE_2", "INC1"."INC1_DOW_1", "INC1"."INC1_STATION_A", "INC1"."INC1_STATION_B", "INC1"."INC1_AT_BETWEEN", "INC1"."INC1_LINE_COLOR", "INC1"."INC1_DIRECTION", "INC1"."INC1_LOC_ST_NO",...

Hi the color has nothing to do with it not working.. See the link below these are general color in sql

http://msdn.microsoft.com/en-us/library/ms173443.aspx

give me some time let me look...

Sure will do.. thank you

When there is not charindex it returned a blank eg. BCGEN.JPG what did is use a case statement..

So from what you guys have given me.. I have added an...