I tried the way from SSChasing Mays but got an error once I changed table name from "orders" to my table's name.

Where is "near '-'" from script?

(352866 row(s) affected)

Msg 102,...

Here is error message.

Msg 15281, Level 16, State 1, Line 1

SQL Server blocked access to STATEMENT 'OpenRowset/OpenDatasource' of component 'Ad Hoc Distributed Queries' because this component is turned off as...

So, I think that I need to create a table to store the item user selected and then use inner join to complete job in application.

In fact, this question is coming from a vb.net project.

All items in list is coming from one array list which user selects from a Gridview select column.

Once user clicks select...

Did you post new code?

Got an error said

Windowed functions can only appear in the SELECT or ORDER BY clauses

After comment out

--UPDATE #Order

-- SET FileOrder = ROW_NUMBER() OVER (ORDER...

Sorry, I realize that should create a temp table first.

After that, another error.

It seems to me IT will not allow me using sys.xp_cmdshell

SQL Server blocked access to procedure 'sys.xp_cmdshell' of...

When I try script below but got an error said: Invalid object name '#order'

select * from #order

D is in local drive.

Your answer help me.

Thank you.

This admin account (sa)

No, max(ORDERID) did not work

The Count of ORDERID will be determined by run time.

In fact, table ORDER should name it as ORDERHISTORY.

Any adding, modifying orders will save to ORDERHISTORY using the same ORDERID.

What function...

I used code below, it works but I am not sure it is good.

select distinct ORDERID from (select top 100 percent ORDERID,ORDERDate from ORDER where ORDERID = '123456' order by...

In asp.net project, I need to declare variables using all these IDs. Like,

dim _0000001, _0000002...

It works. Thanks