Lynn,

Thank you for responding!

Your solution appears to work. I added a couple of sample values to further test it out.

declare @test-2 table(TestData varchar(32));

insert into @test-2

values...

Thank you everyone for taking the time to respond.

Our issue seems to be related to a clustered index on the field. We're moving away from the cursor/loop solution towards...

Tried all three of the proposed solutions. Each returned the same number of records and completed in less than a second, so I guess I could go with any...

I'll give this a try. Thanks Mark!

Tom,

Your solution appears to work perfectly!

Thank you everyone.

Absolutely.

CREATE TABLE

#MachineParts

(

MachinePartPk INT PRIMARY KEY,

MachineFk INT,

InstallDate DATE,

PartType INT,

Price MONEY

)

INSERT INTO #MachineParts VALUES (1, 1, '01/15/2014', 300, 9.75)

INSERT INTO #MachineParts VALUES (2, 1, '03/01/2014', 300, 10.50)

INSERT INTO #MachineParts VALUES...

Luis,

Your query appears to have worked. Thank you very much!

An additional question: What if I wanted everything the same, but instead of looking at a boolean field like...

Thank you Luis! I'll give this a try tomorrow!

sqlslacker and LutzM,

Thank you both! I will give these a try.

Thank you for your suggestions, everyone! I will give these a try.

My apologies. Hopefully this helps:

--===== If the test table already exists, drop it

IF OBJECT_ID('TempDB..#invoices','U') IS NOT NULL

...

Thank you both for responding. I tried the solution from Luis first (it was the simpler of the two) and found that it works like a charm. Guess...

Thank you for your help everyone. I think I found the issue.

There some some numerical values that were greater than ten digits. I was trying to cast them...

Chris,

I ran your query and it added the decimals where it should for the data you created.

But for whatever reason, I'm getting an arithmetic overflow error now when...

Thanks for responding, Adam and Luis.

Unfortunately, after trying both of these methods, I still receive an error, "Error converting data type varchar to numeric". My update statement looks something...