This is the problem. There is no...

Help us understand your requirements:

If you picked:

cost_center_code: 1

Payment_code: 4

Inv_no: 2

What do you expect to see in the following columns?

prev_cost_center_code:

prev_Payment_code:

prev_Inv_no:

next_cost_center_code:

next_Payment_code:

next_Inv_no:

The problem is likely when you are using the import wizard for sql server... It defaults the column output width to 50 characters... You have to click on...

Here is one way to do it.

--sample table and data

create table custtest (customerID varchar(50), customername varchar(100), acctID integer)

INsert into custtest

select 'Cust1', 'Peter', 123

union

select 'Cust1', 'Peter', 345

union

select 'Cust1', 'Peter', 567

--pivot query

select...

You could also look at Visual Studio Lightswitch if you need a quick solution to present a form over your data table.

If you have any development background Lightswitch is easy...

One way I've done this which may help you is to create a control table in SQL Server.

Something like this:

CREATE TABLE [dbo].[ExcelSource](

[WorkbookName] [varchar](255) NULL,

[FilePath] [varchar](255) NULL,

[SheetName] [varchar](255) NULL,

[CellRangeToQuery] [varchar](25) null,

[Active]...

update #temp

set flag = 'Y'

from #temp

join (select lnno ,max(amount) amount from #temp group by lnno) temp2 on

#temp.lnno = temp2.lnno

and #temp.amount = temp2.amount

1) Say A1, A2, A3, A4, A5, A6 are given Order as 1,2,3,4,5,6

2) Now, Change the existing Order of A3-3, A4-4, A5-5, A6-6 to a New order A3-1, A4-2, A5-3,...

I recommend taking a step back and trying to analyze your solution a little more in depth.

From what I can tell, based on your DB name, ConstarOLAP_PROPHIX_FactDb, you are creating...