Viewing 5 posts - 1 through 5 (of 5 total)
thanks alot guys i really learned quite a bit and appreciate the help. drew.allen i was headed in that direction via chris' info
March 23, 2017 at 12:52 pm
#1934636
okay that went over my head:Use ROW_NUMBER() to number the rows in table b in a CTE, then join to table a - either on table a id, or...
March 23, 2017 at 12:31 pm
#1934621
I'm trying to sequentially get the row of id's from TableB.id into TableA.tableid from row 1 to row 4512
TableB id 123 456
end results to...
March 23, 2017 at 12:12 pm
#1934610
i tried this:
UPDATE TableASET tablebid = t1.idFROM TableB t1where t1.id IN (SELECT NULL AS id FROM TableA WHERE tableid IS NOT nullUNION
March 23, 2017 at 11:38 am
#1934594
i don't have a way to join the two tables as TableA.tablebid is null.select tablebid,null as id from TableAunion select null,id from TableB
results were like:
March 23, 2017 at 11:14 am
#1934581