ziedkallel | SQLServerCentral

ziedkallel

Forum Replies Created

Viewing 6 posts - 1 through 6 (of 6 total)

RE: Updating 2 rows in table B based on 1 row from table A

Simple and neat! Thank you very much, Drew. It's much simpler than I thought it would be. Z

August 12, 2010 at 8:16 pm

#1206376
RE: Updating 2 rows in table B based on 1 row from table A

Kenneth Fisher-475792 (8/12/2010)
ziedkallel (8/11/2010)
Just a follow up question. What if the ConceptID column is empty in some rows in the descriptions table, how to do the join? I'm realizing that...

August 12, 2010 at 3:42 pm

#1206347
RE: Updating 2 rows in table B based on 1 row from table A

UPDATE d_description SET RequestId = con.RequestId, FormId = Con.FormId,
DescriptionId = CASE WHEN IdDescription =
...

August 11, 2010 at 9:52 am

#1205478
RE: Updating 2 rows in table B based on 1 row from table A

Very smart. Thanks a brunch!

August 10, 2010 at 8:29 pm

#1205110
RE: Updating 2 rows in table B based on 1 row from table A

(
SELECT
d.*,
ROW_NUMBER() OVER(PARTITION BY d.conceptid ORDER BY iddescription) ROW
FROM #D_DESCRIPTION d
)
Thanks for your reply. As mentioned, I'm using SQL Server 2000. I believe the function Row_number was introduced with subsequent SQL...

August 10, 2010 at 4:18 pm

#1205077
RE: Updating a table starting with the first empty column in a specific row

CELKO (8/5/2010)
This makes no sense. A table has no ordering by definition. There is no concept of "first", "next", "up" or "down" in RDBMS. That is what you have...

August 5, 2010 at 4:09 pm

#1203161

Viewing 6 posts - 1 through 6 (of 6 total)