SQL INSERT

cotton31 · 11 Feb 2011 at 10:05

I've got an SQL (edit: SQL Server 2005) table populated by on of our applications, but one of the fields (task status) isn't populating during this process.

I can extract this field manually and I want to insert this in to the table.

The value of the field obviously depends on the task, so I can't just do an insert where as there are thousands of rows I need to update.

How could I do this without having to run a query for each task?

cotton31 · 11 Feb 2011 at 10:14

Cheers Spunkey,

Yes I did mean UPDATE - I was trying to avoid having to repeat that as I've got thousands of tasks I need to update.

Any ideas?

cotton31 · 11 Feb 2011 at 11:07

How would I do this? I was thinking of inserting the missing data into a temp table, containing the taskID and taskStatus.

Then I could do some sort of UPDATE/JOIN query to insert the correct values????

cotton31 · 11 Feb 2011 at 11:30

Cheers mate, I'll give that a go.

That's what I wanted to do but didn't realise you could do joins within updates.

cotton31 · 11 Feb 2011 at 11:37

No it's only the status which is missing (the field is there, just not populated).

I can extract this data manually from the app into a CSV, so I could have task ID and task status in this. Then I can join the id in the CSV to the id in the original table.