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)

---

@steve-2, for those of us who live West of Denver, Way0utWest is...

Gary Istvan Varga (11/30/2009)

---

Dan Guzman - Not the MVP (11/30/2009)

---

@steve-2, for those of us who live West of Denver, Way0utWest is a bit of a misnomer. Why the middle of...

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...

@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' I'll never...

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...

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'...

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

Gift Peddie (11/25/2009)

---

Dan Guzman - Not the MVP (11/25/2009)

---

wouldn't a rollback also have removed the records inserted? The current coulmn value should have gone down as well, I would...

wouldn't a rollback also have removed the records inserted? The current coulmn value should have gone down as well, I would think.

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]...

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,

...

Imu92, what is @xml?

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

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...

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...