-----------------------------------------------------------
New Message on BDOTNET
-----------------------------------------------------------
From: BalajiKrishnan
Message 4 in Discussion
Check my SP.... ALTER Procedure MOL_SP_Excel_Test @Mode Varchar(10),
@TabID Varchar(50),
@year float(10),
@Month float(10),
@DomListCos float=NULL,
@ForListCos float(10),
@TotalListCos float(10),
@DomStocks float(10),
@ForStocks float(10),
@TotalStocks float(10),
@SharesOut float(10),
@DomMktCapLocal float(10),
@TotalMktCapLocal float(10),
@MktCapConc float(10),
@Trades float(10),
@DomNumShares float(10),
@TotalNumShares float(10),
@DomValSharesLocal float(10),
@TotalValSharesLocal float(10),
@TradValConc float(10),
@PriceEarnings float(10),
@PriceBookValue float(10),
@DivYield float(10)
As DECLARE @strSQL1 varchar(1000)
declare @strVal varchar(500) If @Mode = 'Ins'
Begin
set @strVal= CAST(@year as varchar)+ ',' + CAST(@Month as varchar) + ',' +
CAST(@DomListCos as varchar) + ',' + CAST(@ForListCos as varchar) + ',' +
CAST(@TotalListCos as varchar) + ',' + CAST(@DomStocks as varchar) + ',' +
CAST(@ForStocks as varchar) + ',' + CAST(@TotalStocks as varchar) + ',' +
CAST(@SharesOut as varchar) + ',' + CAST(@DomMktCapLocal as varchar) + ',' +
CAST(@TotalMktCapLocal as varchar) + ',' + CAST(@MktCapConc as varchar) + ',' +
CAST(@Trades as varchar) + ',' + CAST(@DomNumShares as varchar) + ',' +
CAST(@TotalNumShares as varchar) + ',' + CAST(@DomValSharesLocal as varchar) + ',' +
CAST(@TotalValSharesLocal as varchar) + ',' + CAST(@TradValConc as varchar) + ',' +
CAST(@PriceEarnings as varchar) + ',' + CAST(@PriceBookValue as varchar) + ',' +
CAST(@DivYield as varchar)
Set @strSQL1 ='insert Into '+ @TabID + ' values (' [EMAIL PROTECTED] + ')'
End
If @Mode = 'Upd'
Begin
set @strSQL1 = 'Update ' + @TabID + ' Set Year = ' + CAST(@year as varchar)+ ',' +
' Month = ' + CAST(@Month as varchar) + ',' + ' DomListCos = ' + CAST(@DomListCos
as varchar)+ ',' + ' ForListCos = ' + CAST(@ForListCos as varchar)+ ',' + '
TotalListCos = ' + CAST(@TotalListCos as varchar)+ ',' + ' DomStocks = ' +
CAST(@DomStocks as varchar)+ ',' + ' ForStocks = ' + CAST(@ForStocks as varchar)+
',' + ' TotalStocks = ' + CAST(@TotalStocks as varchar)+ ',' + ' SharesOut = ' +
CAST(@SharesOut as varchar)+ ',' + ' DomMktCapLocal = ' + CAST(@DomMktCapLocal as
varchar)+ ',' + ' TotalMktCapLocal = ' + CAST(@TotalMktCapLocal as varchar)+ ',' + '
MktCapConc = ' + CAST(@MktCapConc as varchar)+ ',' + ' Trades = ' + CAST(@Trades
as varchar)+ ',' + ' DomNumShares = ' + CAST(@DomNumShares as varchar)+ ',' + '
TotalNumShares = ' + CAST(@TotalNumShares as varchar)+ ',' + ' DomValSharesLocal = '
+ CAST(@DomValSharesLocal as varchar)+ ',' + ' TotalValSharesLocal = ' +
CAST(@TotalValSharesLocal as varchar) + ',' + ' TradValConc = ' + CAST(@TradValConc
as varchar) + ',' + ' PriceEarnings = ' + CAST(@PriceEarnings as varchar) + ',' + '
PriceBookValue = ' + CAST(@PriceBookValue as varchar) + ',' + ' DivYield = ' +
CAST(@DivYield as varchar) + ' Where Year =' + CAST(@Year as varchar) + ' and ' + '
Month = ' + CAST(@Month as varchar) End exec(@strSQL1) GO
-----------------------------------------------------------
To stop getting this e-mail, or change how often it arrives, go to your E-mail
Settings.
http://groups.msn.com/BDotNet/_emailsettings.msnw
Need help? If you've forgotten your password, please go to Passport Member Services.
http://groups.msn.com/_passportredir.msnw?ppmprop=help
For other questions or feedback, go to our Contact Us page.
http://groups.msn.com/contact
If you do not want to receive future e-mail from this MSN group, or if you received
this message by mistake, please click the "Remove" link below. On the pre-addressed
e-mail message that opens, simply click "Send". Your e-mail address will be deleted
from this group's mailing list.
mailto:[EMAIL PROTECTED]
