This isn't going to be as fast as Drew's code, but it should avoid the problems, and be slightly faster than Ken's once you get some volume of data considerably...

urbanromio2 (11/30/2016)

---

its about metal melting ,

there will be metal scraps with different purtiy,

for example , metal1 weight of 5kg will be 70% purity,

metal2 weight of 3kg will be...

Jeff Moden (11/28/2016)

---

sgmunson (11/28/2016)

---

Jeff Moden (11/28/2016)

---

I hate double postings for this very reason. :crazy: Thanks for the heads up. I left my spare CRAY somewhere and forgot where...

Jeff Moden (11/28/2016)

---

I hate double postings for this very reason. :crazy: Thanks for the heads up. I left my spare CRAY somewhere and forgot where I put it...

urbanromio2 (11/28/2016)

---

Attributes X Y Z

Material a. ...

urbanromio2 (11/28/2016)

---

There are several materials with 3 attributes .

Requirement will be for attributes with specific value ranges,

That may not be available with a single material. So can combine...

wajahatabbas (11/25/2016)

---

Hello

We have an enterprise application on Visual Basic 6.0 that is currently running with SQL Server 2005.

The application is quite huge and there are almost 1000 forms +...

Jeff,

This poster has posted twice in this same forum area, and this was the one without any of the explanation on what is needed. The other post indicates...

urbanromio2 (11/28/2016)

---

The reason is,

I have a record with 3 columns of values.

I need Specific value that comes when combining some records , so that i can enter the value...

Come to think of it, this sort of resembles trying to compute all the possible combinations of "N things, R at a time", which is what you might do if...

The original poster has posted a second time in this same forum area, and posted only his code, with none of this level of detail. I read that...

urbanromio2 (11/26/2016)

---

Some one help me to convert the recursive method to iterative function.

USE [db]

GO

/****** Object: StoredProcedure [dbo].[proc_geneatecombkachha] Script Date: 11/27/2016 00:41:44 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER...

Eirikur Eiriksson (11/23/2016)

---

sgmunson (11/23/2016)

---

Just curious if there's any chance that the clock on the problem server is not within a minute or two of the SQL Server clock. ...

Just curious if there's any chance that the clock on the problem server is not within a minute or two of the SQL Server clock. If there's any...

snomadj (11/23/2016)

---

I need to give a client some options for creating a front end interface for a sql backend. What they currently have is a series of lame old access...