Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
donjt81
Starting Member
11 Posts |
 Posted - 2012-03-19 : 10:17:11
|
| HI I have 2 tables a followsProduct:ID Name OrderableID101 Phone 1201 computer 2301 TV 3401 Lamp 1Orderability:ID Status1 Available2 Low inventory3 DiscontinuedAnother group needs to update the statuses of the items in my Product table. For ex. Phone today is in Available status, Tomorrow it might go to Low inventory. So the external group will update the orderability to Low inventory.I was thinking about providing a view to them but the view only updates one table. Whats the best way to handle this. The external group may add new orderability statuses as well.For ex. they might say phone is now going to be status - "Active"My view or stored Proc needs to detect that this is a new status. Add it to the status table and use the new ID for the product Phone. |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
donjt81
Starting Member
11 Posts |
Posted - 2012-03-19 : 11:00:45
|
| External Group = within the same company but in a different organization. Right now they are not updating any of my tables. I have created a user name and pwd for them and created a view so they can 'read' the data. But now they have to update data in my tables. |
 |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
donjt81
Starting Member
11 Posts |
Posted - 2012-03-19 : 12:28:46
|
| SELECT p.Name, o.Status as 'Orderability Status'FROM Product p INNER JOIN Orderability o ON Product.OrderableId = Orderability.ID |
|
|
|
|
|
|
Need to provide access to external group