SQL category update code

Robert - first you'll need to know what categoryID has been assigned to your brandy department - run the following query

select * from category

then jot down the ID of the "brandy" category... lets say the ID is 3

your update query will be

UPDATE ITEM SET CATEGORYID = 3 WHERE DEPARTMENT LIKE '%BRANDY%';

the % sign allows for any word before and after the word brandy in the description field...

BACKUP FIRST...!

"Robert" wrote:

As this is already described by Mr. Convoluted that you must verify whether you have the department created as brandy or not if not first create the department then you and update the departmentID in item table.

Unfortunatelly the query send by Convoluted won't work there is minor change in this and here is this:

Update item Set DepartmentID = Department.ID From Department Where Department.Name like '%Brandy%'

As the query given to you does not have the department table also the department is being checked but category is being updated. so above query is correct one which help you.

"Robert" wrote: