To be honest I don't know what is exponential moving results. Can you explain that pls.

/* If you have some kind of identity it will be easy to manipulate */

/* If you want average in between dates it would be lot easier */

SET...

/* Just for the heck of doing it using a cursor. */

/* Data */

SET NOCOUNT ON

DECLARE @Document TABLE

(

DocumentID INT,

DoumentDetails  VARCHAR(25)

)

INSERT @Document VALUES (1, 'Details 1 A')

INSERT @Document VALUES (1, 'Details 1...

You will have to use format files for loading more or less fields into a table through Bulk Insert.

Read BOL on format files for bcp.

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=192560#bm192593

For different file names you...

'Vasc's Logic in VB (VIsual Studio 6.0) 

'Save the following code (Exclude these red lines) as frmMatchValues.frm.

'Then Open the file with VS 6.0. Don't forget add MicrosoftActivex data...

I will post VB code tomorrow morning. It will be the same like C# with little change.

If applicable you can add another column in the table sort order.

SELECT* from Table ORDER BY SortOrder

I will post VB code tomorrow morning. It will be the same like C# with little change. 

Sushila - You can delete your post. Use Edit then you will have delete option

SET NOCOUNT ON

DECLARE @Listing TABLE

(

RegionID INT NOT NULL,

CityID  INT NULL,

SuburbID INT NULL

)

INSERT INTO @Listing VALUES (1, 1, 1)

INSERT INTO @Listing VALUES (2, 2, NULL)

INSERT INTO @Listing VALUES (3, 1, 1)

INSERT INTO @Listing VALUES...

Thanks for this code. This works good. We can even enhance by passing height and width to stored procedure.

But when we work with bar codes there are specific needs like...

Here is the C# version of Vasc's logic. Just load the data int Datatable dt before calling this function. Sort Order = "Value DESC"

  private string FindValues(int ColPos, double Value)

  {

   string TempResult...

Even after the solution I did not get the logic. I had to re-create this function in C# and debug step by step to get to know how it works.

If...

/* Final draft of the entire solution */

/* Solution to find a set of values that matches one value. Find first possible Match*/

/* Will work for 32 rows...

I checked several combinations Vasc. It works great. I have been thinking I am intelligent. Now I would say I am nowhere close to intelligent. I couldn't have done this...