Inserting records 2

[FengShui1998]

Hello,

I'm trying to create a database where I need to display the records in order of appearance. For example, I'll have records 1-10 to display. The user will also need to insert a record between certain numbers, therefore the records will have to be reordered. Any help would be appreciated! Thanks.

Fengshui1998

 

[shyamMelwani]

hi there,

i think malcom has given us a great and efficient solution to reorder records.

i will just list it out once again for your reference.

declare @variable int
set @variable = 5
update project_fund_allocation
SET @variable = year = @variable + 1

The @variable will be the seed value from where you will have to re order and an aditional 'Where' condition should select the 'year' column conditionally. ie all records > than the newly inserted record seed.

 

[MalcolmW]

I stuck this solution up the FAQ of the SQL Server forum, as it is a SQL Server specific solution. Your votes for it are welcome - I want to get the free dinner for two for highest rated FAQ!
cheers,
Malcolm