Complex Insert block in the Script


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Complex Insert block in the Script
# 1  
Old 12-17-2008
Complex Insert block in the Script

I have script in that there are thousands of create statement...

I want to add these lines, above every Create Stament
================================================
IF OBJECT_ID('dbo.account_account_relations') IS NOT NULL
BEGIN
DROP TABLE dbo.account_account_relations
IF OBJECT_ID('dbo.account_account_relations) IS NOT NULL
PRINT '<<< FAILED DROPPING TABLE dbo.account_account_relations>>>'
ELSE
PRINT '<<< DROPPED TABLE dbo.account_account_relations>>>'
END
go
==================================================
CREATE TABLE dbo.account_account_relations(
relation_type_cd VARCHAR(20) NOT NULL,
first_account_key VARCHAR(50) NOT NULL,
second_account_key VARCHAR(50) NOT NULL,
row_update_date DATETIME NOT NULL
)


MyProblem Is:-

1) how to add those extra lines above each CREATE Stmnt.
2) inserted lines should pick up the object from CREATE TABLE shown in RED.

Please help with the code....or logic will also do....

If anything is unclear please let me know....

Kunal
# 2  
Old 12-17-2008
???????
# 3  
Old 12-17-2008
Please don't bump up posts - it's against the rules.
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Help with Complex Bash Script

I have an FTP server with thousands of Invoices. All Invoices are in a folder called /volume1/MBSInvoices/ Monthly invoices are added to that folder every month. Here is a sample filename of the Invoices: invoice_1_20170101_10010052_10020052_10030052_JOHNDOE.pdf the Account ID is the... (6 Replies)
Discussion started by: badr777
6 Replies

2. Shell Programming and Scripting

Insert id from same block

Hello all, Please help modify my file. I want to pick up the ID value when the 3rd column is either gene or protein_coding_gene and place the ID in the gene_id attribute corresponding rows which has the the keyword exon in the third column. Input file 10 ensembl gene 195359 ... (6 Replies)
Discussion started by: gina.lizar
6 Replies

3. Shell Programming and Scripting

Complex transpose awk script

Hello to all in forum, Maybe an awk expert could help me with this complex task for me. I have the input shown below and I would like to get the output as follow: - I would like the output separated by commas. - The header is fixed and will be the same always. - For the lines containing... (22 Replies)
Discussion started by: Ophiuchus
22 Replies

4. Shell Programming and Scripting

awk script (complex)

picked this up from another thread. echo 1st_file.csv; nawk -F, 'NR==FNR{a++;next} a{b++} END{for(i in b){if(b-1&&a!=b){print i";\t\t"b}else{print "NEW:"i";\t\t"b} } }' OFS=, 1st_file.csv *.csv | sort -r i need to use the above but with a slight modification.. 1.compare against 3 month... (25 Replies)
Discussion started by: slashbash
25 Replies

5. Shell Programming and Scripting

Complex Script

hey... i had a big problem with my professor i have 3 simple archives in.txt -> had all timestamps of users logon (100lines) ex. 111111 222222 333333 out.txt -> had all timestamps of users logof (100lines) ex. 111113 222225 333332 commands.txt... (9 Replies)
Discussion started by: beandj
9 Replies

6. Shell Programming and Scripting

Insert Block of Text into a File After a Ranged Search

Hello, I've been racking my brain trying to find a good way to accomplish a task. I need to insert a block of text into a file in the format of FirewallRuleSet proxy-users { FirewallRule allow to 0.0.0.0/0 } I need to insert this block of text (which could have sed special... (2 Replies)
Discussion started by: 0xception
2 Replies

7. Shell Programming and Scripting

Complex coloring in script

My script prints lines in which the entire line may be colored, and portions may also be colored. e.g. Consider this to be one line: $red some text in red $yellow abcd $end_yellow red text 1234 $blue some text $end_blue more red text $end_red So using sed, I may based on condition 1,... (5 Replies)
Discussion started by: sentinel
5 Replies

8. Shell Programming and Scripting

block of name value pair to db insert statements

Hi, I need to convert the following file into DB insert statements. $ cat input.txt START name=john id=123 date=12/1/09 END START name=sam id=4234 status=resigned date=12/1/08 END (2 Replies)
Discussion started by: vlinet
2 Replies

9. Shell Programming and Scripting

complex find in script

How to I put my find command string into a script. It is currently to long to be entered manually at command line. for FNAME in `find /unixsxxx/interface/x.x/xxxxxx -type f \( -name '*.KSH' -o -name '*.sh' -o -name '*.sql' -o -name '*.ksh' \) -exec grep -il xxx.xxx.xxx.xxx {} \;`; do C=`grep -c... (5 Replies)
Discussion started by: TimHortons
5 Replies

10. Shell Programming and Scripting

Need complex script, anyone up for a challenge?

Default shell is /usr/bin/zsh Script will be running #!/bin/bash Need to pull information from database while using other scripts already made (not by me). Ok, so i need a script pulling certain information about a customer's router interfaces. I am using a ROUTER-DNS-NAME as variable $1 I... (3 Replies)
Discussion started by: ///NNM
3 Replies
Login or Register to Ask a Question