To avaid loading one file until you clear or process the data in staging table you can use following statement. This will not be possible if you use bcp from...

Thanks Michael. Let me wait for Vasc's solution fine tuning before making this to C#.

Use a staging table while loading.

If you are using bcp from command prompt it would be difficult to make sure when one process is running just not to start...

Thank You all. Especially Vasc.  I had to leave early for Dr's Appt.

Vasc with this change

SELECT @MinValue=SUM(Value) FROM MyTable WHERE Col<=@Pos

SELECT @MinValue=SUM(Value) FROM MyTable WHERE Col<

Thank You Vasc 263 is fixed with that.

Any value that needs to compute with max value returns blank.

Yes Remi I got it with

SELECT SUM(value) FROM [MyTable] WHERE COL < 20

Question to Vasc

Can we ignore this tw steps as I make sure The table queried will not have...

Sorry Vsac I am really embarrassed since still I did not get your logic and just testing your code. So I am bothering you again to fine tune.

For 88 and...

Thanks Vsac. It works cool for most cases now. I think it needs little fine tuning as

For 1206 it gives two hundreds(We have one in the table).

ADD :...

Thanks Noel. I would do it by any means either in SQL or Front END through whatever I Can. Still I am totally lost with the logic to do that....

Thanks Vasc. It will take a while for me to get this logic.

But When I tried this

DECLARE @myAmount NUMERIC(12,2)  SET @myAmount = 500 -- SET THIS VALUE AS VALUE TO...

No need to write the format files for entire 50 fileds. You have to mention poition of the column and column names you have to load. Just play around with...

Micael if you can post te VB code that would be great. I need the first matched value not all of them. I can do that at client side.

If...

You would want to use Format Files -f"FormatFileName"

Use Host file field order and Server column order, Name to specify the order and data.

Vasc I did that Algoritham First (See the code) It Fails if the values are apart in scatered 3 places. It works for consecutive #s great

IF (SELECT SUM(Value) FROM @Values)...

If you meant the values yes Same values can repeat.

Out of 20 we can remove all the values that exceeds the Input value so that would reduce 20 to some...