Viewing 15 posts - 76 through 90 (of 152 total)
Gary Istvan Varga (11/30/2009)
Dan Guzman - Not the MVP (11/30/2009)
Gary Istvan Varga (11/30/2009)
Dan Guzman - Not the MVP (11/30/2009)
November 30, 2009 at 9:58 am
Gary Istvan Varga (11/30/2009)
Dan Guzman - Not the MVP (11/30/2009)
November 30, 2009 at 9:43 am
Based on all the comments here, I got completely lucky.
I assumed it was a trick question, and figured Midnight was one of those mystery values between today and yesterday, and...
November 30, 2009 at 9:38 am
@steve-2, for those of us who live West of Denver, Way0utWest is a bit of a misnomer. Why the middle of the country is still considered 'The West'...
November 30, 2009 at 9:28 am
Thanks Gift Peddie, I'll keep an eye on it.
We're only inserting a few thousand records at a time, and int is good to over 2 billion, so I think we...
November 25, 2009 at 3:10 pm
Thanks Steve,
I'm starting to lean towards a reported bug in SQL Data Compare 8.0.1 that sets the RESEED value of a non-sync'd table to the SEED value of the 'Source'...
November 25, 2009 at 1:52 pm
My fault, sorry. Adding th eID into the output showed me that there were indeed 2 xml documents for that CIK.
I'll play with the nodes.
Thanks,
Dan
November 25, 2009 at 11:48 am
Gift Peddie (11/25/2009)
Dan Guzman - Not the MVP (11/25/2009)
November 25, 2009 at 11:39 am
wouldn't a rollback also have removed the records inserted? The current coulmn value should have gone down as well, I would think.
November 25, 2009 at 11:18 am
Here is the table structure, but all the information you needed was in the XML I added to the end of the previous post.
CREATE TABLE [dbo].[tblInsiderXMLData](
[ID] [int] IDENTITY(1,1) NOT NULL,
[CIK]...
November 25, 2009 at 11:16 am
Thanks, that helped.
Why do I get 4 records instead of 2 when I run this:
SELECT c2.value('issuerCik[1]', 'varchar(30)') AS issuerCik,
c2.value('issuerName[1]', 'varchar(30)') AS issuerName,
...
November 25, 2009 at 10:14 am
SecurityTitle was not F1 in my Excel sheet I used to build that example, sorry.
You are also correct that the DerivitiveTables have no relation to NonDerivativetables.
I absolutely want separate tables,...
November 24, 2009 at 5:38 pm
Desired output from the above XML:
issuerCikissuerNameissuerTradingSymbolsecurityTitletransactionDatetransactionSharestransactionPricePerSharesharesOwnedFollowingTransactionfootnote IDfootnotes
1000045NICHOLAS FINANCIAL INCNICKCommon Stock10/21/2009750001.58330F1
1000045NICHOLAS FINANCIAL INCNICKCommon Stock10/22/2009361341.58331200168F2, F3
1000045NICHOLAS FINANCIAL INCNICKF1The option vested in three equal annual installments beginning November 8, 2000.</footnote>
1000046NICHOLAS FINANCIAL INCNICKF2The option...
November 24, 2009 at 3:41 pm
Here is some shortened XML, I'll work on the example output next.
<ownershipDocument>
<schemaVersion>X0303</schemaVersion>
<documentType>4</documentType>
<periodOfReport>2009-10-21</periodOfReport>
<notSubjectToSection16>0</notSubjectToSection16>
<issuer>
<issuerCik>0001000045</issuerCik>
<issuerName>NICHOLAS FINANCIAL INC</issuerName>
<issuerTradingSymbol>NICK</issuerTradingSymbol>
</issuer>
<nonDerivativeTable>
<nonDerivativeTransaction>
<securityTitle>
<value>Common Stock</value>
</securityTitle>
<transactionDate>
<value>2009-10-21</value>
</transactionDate>
<transactionAmounts>
<transactionShares>
<value>75000</value>
</transactionShares>
<transactionPricePerShare>
<value>1.5833</value>
</transactionPricePerShare>
</transactionAmounts>
<footnoteId id="F1" />
</nonDerivativeTransaction>
<nonDerivativeTransaction>
<securityTitle>
<value>Common Stock</value>
</securityTitle>
<transactionDate>
<value>2009-10-22</value>
</transactionDate>
<transactionAmounts>
<transactionShares>
<value>36134</value>
</transactionShares>
<transactionPricePerShare>
<value>1.5833</value>
</transactionPricePerShare>
</transactionAmounts>
<footnoteId id="F2,F3" />
</nonDerivativeTransaction>
<nonDerivativeHolding>
<securityTitle>
<value>Common Stock</value>
</securityTitle>
<postTransactionAmounts>
<sharesOwnedFollowingTransaction>
<value>0</value>
</sharesOwnedFollowingTransaction>
</postTransactionAmounts>
</nonDerivativeHolding>
<nonDerivativeHolding>
<securityTitle>
<value>Common Stock</value>
</securityTitle>
<postTransactionAmounts>
<sharesOwnedFollowingTransaction>
<value>1200168</value>
</sharesOwnedFollowingTransaction>
</postTransactionAmounts>
</nonDerivativeHolding>
</nonDerivativeTable>
<footnotes>
<footnote id="F1">The option vested in three equal annual
installments beginning...
November 23, 2009 at 12:28 pm
Viewing 15 posts - 76 through 90 (of 152 total)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy