Perfect.

I have to admit I am stupid.

Thanks a million.

Mark why is it the sub-set within that page you want to sort?

Try any websites (ex. Shopping) when you sort it will sort the entire record and then page...

Thank You.

SK (1/3/2009)

---

Can the user run the statement without going through the linked server? That will help rule out any issues with the linked server permissions.

If not, I would...

Thanks SK I can change the access rights temperarily to check. Any chnage on user rights would apply to all the objects. We don't want that.

But I own only the...

THank you for the replies.

Linked server properties shows it is using lnkUsr with password. I gave

GRANT ALL ON permanaentTable to LnkUsr.

It did not work.

I made the lnkUsr as sysadmin...

bitbucket

I am sorry if I did not express well.

Each row key is a set of data. We get the same data almost every day. But there will be changes...

Thanks bitbucket

The results needed is exactly like SELECT * FROM @MyVersions WHERE RowKey IN (1, 4, 6, 7, 10, 13, 17, 20, 23)

But we have to find (1, 4, 6,...

I would suggest to usp_ (user stored procedure) is you must use a prefix.

This is what BOL says

System Stored Procedures

Many of your administrative activities in Microsoft® SQL Server™ 2000 are...

No answers from any one. I did some how managed it. Please find faults or errors in this.

DECLARE @CustomerComplaints TABLE

(

MachineID VARCHAR(32),

Model VARCHAR(64),

Complaints INT,

DataDate DATETIME

)

INSERT @CustomerComplaints

SELECT 'NotUpgraded', 'Model 2', 15, '2007-04-23'...

You beat me on that Gilamonster when I was typing the sample code.

BTW.

will throw error if...

I wouln't say this is efficient. But this is a way to do it.

Such situation I always sort in the front end. If you are using ado.net it is...

Is it dates 01 to 07 are Week1 and 08 to 14 are Week2 like that. If yes then

/* To produce sample data */

SELECTIDENTITY(int, 1,1) AS ID_Num,

myDate = CONVERT(DATETIME, '01/30/2007'),

WeekInMonth...

can this help

MSDN DATEPART function

Another way

DECLARE @myTable TABLE

(

Student CHAR(5),

[sequence] VARCHAR(3),

GPA NUMERIC(5, 2)

)

INSERT @myTable

SELECT 'ST1', '001', 45 UNION

SELECT 'ST2', '001', 99UNION

SELECT 'ST2', '002', 23UNION

SELECT 'ST3', '002', 39

SELECTCOALESCE(A.Student, B.Student) Student,

COALESCE(A.GPA, B.GPA)...

I am assuming several things here can you use MAX

DECLARE @myTable TABLE

(

Student CHAR(5),

[sequence] VARCHAR(3),

GPA NUMERIC(5, 2)

)

INSERT @myTable

SELECT 'ST1', '001', 45 UNION

SELECT 'ST2', '001', 99UNION

SELECT 'ST2',...