Posted by CK on 10/24/06 19:53

Hi All,

We have a budgeting table and a budgetAssistant table, I have 3 employee ID's,
I need to assign each of them as budget assistant. Do you know of a quick
update query I could write to accomplish this? The budget and
budgetAssistant tables both have a budgetID field. Any ideas?

I wanted to select those employees, then select all the budget then loop
through and add those 3 to each budget as a budgetAssistant.

Thanks,

~CK

• Next in forum: Re: SQL Server Sizing - Hardware requirements for SQL Server 2005
• Prev in forum: How to form URL for browser Endpoint access?
• Thread view: Help with an update query

[Reply to this message]