February 4, 2009 at 9:42 pm
i have lot of records in excel with 20columns approximately
in the table there is an identity column and 20 columns as it is in excel
i try to do import/export wizard to import the data to sql server. it works by enabling idenity insert
i insert in the sorted order for the a field (Child name) but when i do a group by
like
select childname from table group by child name ...the data is retrieved in different order and not the way it was inserted.
February 4, 2009 at 10:39 pm
You have made a statement, not asked a question. What do you want?
Also, you speak of DTS, yet you are posting in the SSIS forum. They are not the same thing.
The default ordering of data in a SQL Server table is close to meaningless. Use SELECT ... ORDER BY to force the ordering to be as you would like.
Phil
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply