Sorry Lynn, time wasn't...

I figured out a way around it.

I am sorry I need to be more clear.

I know that we have data in the description that is not numeric.

The view is suppose to act as a (sub table)...

If the problem is my brain, it isn't fixed.

Please fix my brain.

CREATE TABLE [dbo].[tblLevelToLevelRel](

[GenLevelToLevelRelID] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[UpperLevelCloneID] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[LowerLevelCloneID] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[AllocPercent] [float] NOT NULL,

[Active] [bit] NULL,

[ChangedDate] [datetime] NULL,

[ChangedBy] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[ChangedType] [char](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[ChangedMachineName]...

first query 43k

second 153k

the genleveltolevelrel id is a primary key on the tblleveltolevelrel table.

TempDelete has 43k records.

distinct genleveltolevelrelid records

http://www.asql.biz/Articoli/SQLX08/Art1_4.aspx

Thanks for the reply. I really appreciate the help. After further research here is what I went with:

I made the following into a function, and boy does it work good.

DECLARE...

This seems to work with a temp table:

create table #tempR

(

productid int,

rate decimal(16,2)

)

insert into #tempR (ProductID,rate)

SELECT ProductTempRR.ProductID, SUM(ProductTempRR.PolkTotal * ProductReplacementSchedule.Replacement / 100) AS rate

FROM ...

Jeff, ummm what do you...

foursaints, I appreciate the note. I have never had any problems with inserting data, or query, but my understanding of updates (multiple rows at a time) with different data, is...

It seems to me, most of the algorithms are built, and if you build a new one it usually ends up somewhere on the net.

http://en.wikipedia.org/wiki/Algorithm

I want the best of all worlds.

I want ssis to be able to run dataphore scripts.

I want to be able to do what I want in a script.

That's really all...