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.

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 scripts

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.sql
sp_ImportSCPData.sql
sp_UpdateEffectiveRelationshipManager.sql


how 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?
Go to Top of Page

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.
Go to Top of Page

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 table
Statements of 01_Build_Schema.sql
Statements of sp_ImportSCPData.sql
Statements of sp_UpdateEffectiveRelationshipManager.sql

Again, it is just my guess as I don't know your boss.
Go to Top of Page

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 table
Statements of 01_Build_Schema.sql
Statements of sp_ImportSCPData.sql
Statements of sp_UpdateEffectiveRelationshipManager.sql

Again, 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

Cheers
MIK
Go to Top of Page
   

- Advertisement -