Forum Replies Created

Viewing 15 posts - 76 through 90 (of 152 total)

  • RE: The DBA Boat

    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, for those of us who live West of Denver, Way0utWest is...

  • RE: The DBA Boat

    Gary Istvan Varga (11/30/2009)


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


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

  • RE: Datetime precision

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

  • RE: The DBA Boat

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

  • RE: Why did my IDENTITY seed change?

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

  • RE: Why did my IDENTITY seed change?

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

  • RE: XML into a table

    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

  • RE: Why did my IDENTITY seed change?

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

  • RE: Why did my IDENTITY seed change?

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

  • RE: XML into a table

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

  • RE: XML into a table

    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,

    ...

  • RE: XML into a table

    Imu92, what is @xml?

  • RE: XML into a table

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

  • RE: XML into a table

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

  • RE: XML into a table

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

Viewing 15 posts - 76 through 90 (of 152 total)