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 |
dtrivedi
Posting Yak Master
153 Posts |
Posted - 2011-02-15 : 11:27:41
|
my boss has asked me to do something and as usual he didn't give me great clarification. Can someone help me desipher what he means?As for SCP, based on the following three scripts that JBS sent, you should be able to combine them all into one. You’ll also need to include a drop of all the tables being created in the build_schema.01_Build_Schema.sqlsp_ImportSCPData.sqlsp_UpdateEffectiveRelationshipManager.sqlhow do i combine them? |
|
MIK_2008
Master Smack Fu Yak Hacker
1054 Posts |
Posted - 2011-02-15 : 14:46:39
|
well if you are not clear enough what don't you ask again for clarification from your boss? |
 |
|
dtrivedi
Posting Yak Master
153 Posts |
Posted - 2011-02-15 : 15:12:07
|
he isn't that great with giving clarification. he gets upset and mooddy. not a people person. |
 |
|
pk_bohra
Master Smack Fu Yak Hacker
1182 Posts |
Posted - 2011-02-15 : 23:28:13
|
My guess:The "01_Build_Schema.sql" file doesnot have drop table statements. He expects you to write them for all the tables that are created in 01_Build_Schema.sql file.So you may have to put all in a single file Drop statements of tableStatements of 01_Build_Schema.sqlStatements of sp_ImportSCPData.sqlStatements of sp_UpdateEffectiveRelationshipManager.sqlAgain, it is just my guess as I don't know your boss. |
 |
|
MIK_2008
Master Smack Fu Yak Hacker
1054 Posts |
Posted - 2011-02-16 : 01:26:26
|
quote: Originally posted by pk_bohra My guess:The "01_Build_Schema.sql" file doesnot have drop table statements. He expects you to write them for all the tables that are created in 01_Build_Schema.sql file.So you may have to put all in a single file Drop statements of tableStatements of 01_Build_Schema.sqlStatements of sp_ImportSCPData.sqlStatements of sp_UpdateEffectiveRelationshipManager.sqlAgain, it is just my guess as I don't know your boss.
My guess would be to create a script, incorporating all three individual scripts in order to perform the task/process in similar fashion as they are doing it individually. Once you create this script .. use "Drop table" statement(s) at the end of this single script so that all tables that are created due to the Build_Schema.sql script are dropped CheersMIK |
 |
|
|
|
|