well, i dont make rule, i am the slave of my master. So master wants me to make something like a table pick first 10 records from unknown number...

and how i can create sister table with the specific sort order which will show like 2nd table, i am new to sql any help will be much appreciated.

Thanks

well requirment suppose to show like 2nd table, order by processdataID

DECLARE @TestData VARCHAR(12),

@ControlString CHAR(36)

SELECT @TestData = '03EA12J78',

...

Here is my table--

CREATE TABLE [dbo].[Tally] (

[TestData] [varchar] (12) ,

[ControlString] [varchar] (50) ,

[Nek] [varchar] (50)

) ON [PRIMARY]

declare @TestData varchar(12);

set @TestData = '03EA12J77';

select

(10 -...

Server: Msg 207, Level 16, State 3, Line 6

Invalid column name 'N'.

Server: Msg 207, Level 16, State 1, Line 6

Invalid column name 'N'.

Server: Msg 207, Level 16, State 1, Line...

Server: Msg 8116, Level 16, State 1, Line 3

Argument data type nvarchar is invalid for argument 2 of substring function.

Server: Msg 8116, Level 16, State 1, Line 3

Argument data type...

HOW ABT INSTEAD FINDING EVEN AND ODD IF I WANT SPLIT THE TABLE AND SHOW LIKE THIS

1 6

2 7

3 ...

thanks for you reply how about if i dont want to limit it 1 to 10...... if i want all records in table to show like this... how should i...

1 3202306000 (already in db)

...