Please help me

goingdown11

I build a view
SELECT TOP 100 PERCENT *
FROM dbo.trade
WHERE (1 = 1) AND (id IN
          (SELECT MAX (id) AS id
         FROM trade
         GROUP BY comid))
ORDER BY memberType DESC

But because of this thing, the ID numbers themselves don't come in order, and some are like 10 after 15.
So I want to build another orderly ID for the view.
NEWID () AS AA
No, that's not a number

cv4bf5d65fd

IDENTITY (int, 1,1)

fanfan1980

--try

SELECT TOP 100 PERCENT ID = identity (int, 1, 1), * into #T
FROM dbo.trade
WHERE (1 = 1) AND (id IN
          (SELECT MAX (id) AS id
         FROM trade
         GROUP BY comid))
ORDER BY memberType DESC

select * from #T

goingdown11

The query designer does not support the IDENTITY SQL construct.

cv4bf5d65fd

goingdown11


   The query designer does not support the IDENTITY SQL construct.
  

-------------------------------------------------- ------------
Impossible, just use the IDENTITY (int, 1,1) function to insert into a new table

goingdown11

Hey, I'm so stupid, I made a mistake, this is written in the view, it turns out to be inserted into a new table, I understand

goingdown11

What about such a huge amount of data?

goingdown11

This seems to be limited in practical use. Do I create a table every time I check it?

albertwl

You can add a drop table #T

goingdown11

Well, I considered this, but now there are several problems
First, since I want to sort, then, if you check the first page, it will be easy to transfer 20 data to the record set
Then if I check every two pages, I will pass forty records to a new table.
Then look for the last 20 data
But the third page is about to pass sixty articles
There are 80 items on the fourth page, and the speed is greatly affected
Second, then the table name is a problem. As a member, I can generate a table based on his user name, but if a non-member checks, what about the concurrency problem?
Third, the issue of permissions, this is also a big issue, will it have an impact, if there is someone, think of a way to insert 10,000 tables in my library, what should I do?

Solve it