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 |
|
jay_kay8
Starting Member
1 Post |
 Posted - 2002-02-07 : 06:43:08
|
| I have created a Help Desk application in ASP and I am having problems.I have 2 views created by Packages that fire once a day. I want to query these views, this I can do fine. But the results from ONE of the queries to one of the views I need to ADD to some results in an exisitng table.I need to know the DATEDIFF in hours between 0900 and 1700 IF the job is ticket is still open. When I have this value for ALL open tickets I need to ADD it to the Existing value in the existing table.I'm running round in circles here, can I do all this in one Query without dashing between views and tables? |
|
|
Lou
Yak Posting Veteran
59 Posts |
Posted - 2002-02-07 : 15:58:06
|
| Yes, you can do everything you described using JOINS. If they are on different servers/database, you can use four part naming myserver.databaseName.owner.tablename... When you say ADD, do you mean insert new rows into your existing table? When you say 2 views created by packages, you lost me. Aren't views built on the fly every time they are called? Anyway, hope that helps.Edited by - Lou on 02/07/2002 16:00:11 |
 |
|
|
|
|
|
Datetime Calculations involving UPDATE