aloshya | SQLServerCentral

aloshya

Forum Replies Created

Viewing 6 posts - 31 through 36 (of 36 total)

RE: Updating 60 column of null value ?

anthony.green - Friday, August 25, 2017 2:41 AM
aloshya - Friday, August 25, 2017 2:04 AM

August 25, 2017 at 4:17 am

#1956768
RE: how to use row number to insert into the same table ?

Phil Parkin - Thursday, August 24, 2017 11:51 AM
Secondly, Phil is wrong that you need a join. What you should be...

August 25, 2017 at 1:51 am

#1956759
RE: how to use row number to insert into the same table ?

Phil Parkin - Thursday, August 24, 2017 5:57 AM
The UPDATE statement is this bit:
WITH Ordered
AS
(
SELECT
t.Id
, rn = ROW_NUMBER() OVER (ORDER...

August 24, 2017 at 6:45 am

#1956604
RE: how to use row number to insert into the same table ?

Phil Parkin - Thursday, August 24, 2017 5:57 AM
The UPDATE statement is this bit:
WITH Ordered
AS
(
SELECT
t.Id
, rn = ROW_NUMBER() OVER (ORDER...

August 24, 2017 at 6:29 am

#1956596
RE: how to use row number to insert into the same table ?

Phil Parkin - Thursday, August 24, 2017 5:43 AM
You need to join back to your subquery on the table's PK or unique...

August 24, 2017 at 5:51 am

#1956581
RE: how to use row number to insert into the same table ?

Phil Parkin - Thursday, August 24, 2017 5:23 AM
zorbatouche - Thursday, August 24, 2017 5:18 AM

August 24, 2017 at 5:32 am

#1956577

Viewing 6 posts - 31 through 36 (of 36 total)