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 |
|
k886015
Starting Member
3 Posts |
 Posted - 2009-07-21 : 12:02:32
|
| I have many many individual select statements that are being ran to validate format, mandatory, etc. These are static queries each time my table is truncated and reloaded that need to be validated. What I would like to do is create a temporary table with columns (test case, pass fail) then run the queries and check for valid data. I need to populate the test case and pass fail based on the results. how can I do this? |
|
|
Mangal Pardeshi
Posting Yak Master
110 Posts |
Posted - 2009-07-22 : 00:51:24
|
| Triggers can help you do this - http://msdn.microsoft.com/en-us/library/ms189799.aspx (triggers will only help in case when data is deleted using DELETE and not when by using TRUNCATE)Or may be you can create a SSIS package, all these activities can be handled very elegantly in SSIS.Mangal Pardeshihttp://mangalpardeshi.blogspot.com |
 |
|
|
|
|
|
Automate scripts