how i can split up the database in record level like following ---

id name now ===> want so show my data like this
1 a
2 b 1 a
3 c 8 h
4 d 2 b
5 e 7 g
6 f 3 c
7 g 6 f
8 h 4 d
                           5 e

Ok... here's the answer... but you have to tell me why you needed to do this...



--Jeff Moden

hi jeff,
thanx for your prompt reply. but when i was trying code its showing data other then the requirment--its code data showing like this --

1 a
8 h upto now ok but next it should be 2 but output is
7 g
2 b this line should be at the place of 7
3 c
6 f
5 e
4 d

Applogies... left off part of the Order By when I did the cut and paste...

--===== Setup the test data
 CREATE TABLE #MyHead
        (
        ID INT,
        Name VARCHAR(10)
        )

 INSERT INTO #MyHead
        (ID,Name)
 SELECT 1,'a' UNION ALL
 SELECT 2,'b' UNION ALL
 SELECT 3,'c' UNION ALL
 SELECT 4,'d' UNION ALL
 SELECT 5,'e' UNION ALL
 SELECT 6,'f' UNION ALL
 SELECT 7,'g' UNION ALL
 SELECT 8,'h'

--===== Demo the solution
DECLARE @MaxPoint INT
DECLARE @HalfPoint INT

 SELECT @MaxPoint = MAX(ID)+1,
        @HalfPoint = MAX(ID)/2
   FROM #MyHead

 SELECT d.ID,d.Name
   FROM
        (
         SELECT t1.ID AS ThisPoint, t1.*
           FROM #MyHead t1
          WHERE t1.ID <= @HalfPoint
          UNION ALL
         SELECT @MaxPoint-t2.ID AS ThisPoint, t2.*
           FROM #MyHead t2
          WHERE t2.ID > @HalfPoint
        ) d
 ORDER BY d.ThisPoint,d.ID



--Jeff Moden

thank you so much jeff. its a great help.
Another problem --

how can i import DBF to SQL. no way seems like i can make it, for sure it is beginner like me. not for you jeff

thanks jeff

DTS in SQL Server has several dBase import filters. Go to Enterprise Manager and select [Tools][Data Transformation Services] and then follow your nose.

--Jeff Moden