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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-03-23 : 08:55:39
|
| Prashant writes "I am beginer in DTS.so i want some help for DTS.I have to develope DTS Package for same Table record Updation.but problem is that for this task i have to check the condition from six different tables . I want help for this task.I am confused with HOW TO STORE THE RESULT OF FIRST CONDITION(QUERY) TO CHECK WITH NEXT CONDITION...& so on...to get final result.Plz help me outthx inAdvance" |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-03-23 : 09:16:21
|
| It sounds like it would be much simpler to do this with a stored procedure. You could gather the results of each query inside the stored procedure and compare the recordsets of the temp tables or table variables. If you want to run it in DTS, just put that stored procedure in DTS.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
 |
|
|
|
|
|
DTS Information