jchatton1 | SQLServerCentral

jchatton1

Forum Replies Created

Viewing 4 posts - 1 through 5 (of 5 total)

RE: Updating 1 record in Table A with multiple records in Table B

sgmunson - Monday, September 11, 2017 10:21 AM
jchatton1 - Saturday, September 9, 2017 7:39 AM

September 13, 2017 at 12:32 pm

#1959313
RE: Updating 1 record in Table A with multiple records in Table B

m.richardson.home - Saturday, September 9, 2017 2:49 AM
This should do the trick:-
UPDATE m
SET
Field1 = COALESCE(Field1,(SELECT TOP 1 Field1 FROM...

September 9, 2017 at 7:39 am

#1958844
RE: Updating 1 record in Table A with multiple records in Table B

pietlinden - Friday, September 8, 2017 11:16 PM
Welcome to SSC. It helps everyone if you post CREATE TABLE and INSERT scripts so...

September 9, 2017 at 7:35 am

#1958843
RE: Updating 1 record in Table A with multiple records in Table B

Here is an example of what I am trying to do.
My beginning master table:
RowID CustID RecordID Field1 Field2 Field3
-------------------------------------------------------
12655 ...

September 8, 2017 at 10:40 pm

#1958833

Viewing 4 posts - 1 through 5 (of 5 total)