Never mind. I did it in application.

Thank you. It works.

It works.

Thanks

Real table is including 300 columns with different column name and data type but datatable has 300 columns with name as column1, column2 ... column300. (imported from a csv fle)

Is...

Thank you help but I think that this code is working on App not in SQL store procedure.

My app alreay created datatable and passed it to SQL store procedure.

I need...

It works great!

Thank you. You save my life.

Thank you. You are right.

Once I move csv file to C of server it works fine.

But, all data with " ". (csv file has text qualifier " ")

How to fix...

Thank yo for help.

If I put script like below, does it include all records?

SELECT

*

FROM @test-2 T

WHERE T.TEST_STRING in ('red', 'green') or T.TEST_STRING = ''

OR...

Thank you for help.

From "20-(MAX([sequence number])%20)" I got an idea.

Finally, I use while loop to complete it.

I use

select max(sequence)

to find out max sequence number

This a part of one sp in which there are about 20 select statements.

Of all select statement, they need @headerid and @Providerid value.

If using

SELECT HEADERID, PROVIDERID INTO #HEADER

FROM...

The reason is:

I have user's Excel file including data in each fields (from this views) and were sorted by alphabet.

To find out matched fields between Excel file and views, I...

Thank you for your point.

Once I change text box form single line to multiple lines mode, it works great without one code.

I am working with ASP.NET

For example, user may input text like below.

Welcome to Order application

Your registration is completed

Using code to store above text into SQL column is

'Welcome to Order application' + char(13) + char(10)...