Forum Replies Created

Viewing 15 posts - 451 through 465 (of 541 total)

  • RE: SET IDENTITY_INSERT

    I will give that a try the next time I need to migrate.

    Thanks,

    Phil.

    -------------------------------------------------------------------------------------
    A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."

    Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '

    Tommy Cooper

    May 14, 2008 at 8:04 am

    #815220

  • RE: Identity Column Inserts Issue.

    Hi are you looking to copy from Database 1 (has the data) to Datbase 2 (which is blank) but wish to retain the Parent/Child relationships?

    If so then from Database 1...

    -------------------------------------------------------------------------------------
    A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."

    Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '

    Tommy Cooper

    May 14, 2008 at 4:46 am

    #815032

  • RE: Migrate Records from Database A to Database B

    Thanks Jack, I will give it a whirl.

    Phil.

    -------------------------------------------------------------------------------------
    A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."

    Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '

    Tommy Cooper

    May 1, 2008 at 3:24 pm

    #809839

  • RE: Migrate Records from Database A to Database B

    Hi once again Jack. Yes the SQL Identity Key is the PK in Parent Table & the FK in the Child Table.

    So....Database1

    Parent Table

    AccountType (PK)

    1234

    1235

    Child Table

    TCode (PK)...........Description..........AccountType(FK)

    1........................Bibble.................1234

    2........................Bobble................1235

    So run...

    -------------------------------------------------------------------------------------
    A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."

    Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '

    Tommy Cooper

    May 1, 2008 at 12:21 pm

    #809760

  • RE: Add Column to Table (Not Part of Dataset)

    Had a play and all working.

    Many Thanks,

    Phil.

    -------------------------------------------------------------------------------------
    A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."

    Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '

    Tommy Cooper

    May 1, 2008 at 4:38 am

    #809474

  • RE: Add Column to Table (Not Part of Dataset)

    Thanks for the tips. I shall have a play today.

    Regards,

    Phil.

    -------------------------------------------------------------------------------------
    A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."

    Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '

    Tommy Cooper

    April 30, 2008 at 11:51 pm

    #809454

  • RE: Return Unique Part Number Values to Web Form

    Thanks Jack. I will look into the UI side of things. I will run though your code and see how it all works. The user request is not priority, at...

    -------------------------------------------------------------------------------------
    A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."

    Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '

    Tommy Cooper

    April 30, 2008 at 11:49 pm

    #809453

  • RE: Return Unique Part Number Values to Web Form

    Thanks Steve. It's the narrative I want to return...............one Part / Many Narratives (well that's the plan 🙂 )

    Thanks,

    Phil.

    -------------------------------------------------------------------------------------
    A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."

    Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '

    Tommy Cooper

    April 30, 2008 at 9:23 am

    #809147

  • RE: Add Column to Table (Not Part of Dataset)

    Hi. Yes. It's required (so I am told) to allow users to tick the line item that has been picked (as opposed putting a red line through the line item!).

    Thanks,

    Phil.

    PS:...

    -------------------------------------------------------------------------------------
    A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."

    Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '

    Tommy Cooper

    April 30, 2008 at 9:21 am

    #809145

  • RE: Format Currency in Table Header

    Hi John. Another newbie like me!! It appears that this requirement has gone away so problem solved!! 🙂

    Thanks,

    Phil.

    -------------------------------------------------------------------------------------
    A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."

    Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '

    Tommy Cooper

    April 29, 2008 at 5:51 am

    #808250

  • RE: Substitute NULL value on converted date field?

    Thanks for your input John.

    Phil.

    -------------------------------------------------------------------------------------
    A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."

    Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '

    Tommy Cooper

    April 20, 2008 at 6:13 am

    #804696

  • RE: ProductId Search

    Mahesh thanks for your time, I managed to resolve (well it looks OK). My query looks as follows:

    SELECT DISTINCT ProductId,ProductDescription,ISNULL(CONVERT(VARCHAR,SUM(QuantityOutstanding)),'0')AS Quantity,StandardPrice

    FROM Products

    LEFT JOIN dbo.Inventory ON dbo.Inventory.Product= dbo.Products.Product

    GROUP BY Products.ProductId,...

    -------------------------------------------------------------------------------------
    A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."

    Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '

    Tommy Cooper

    April 18, 2008 at 3:15 am

    #804166

  • RE: ASP Web Front End??

    Gentlemen many thanks for your time and comments. Dan very detailed. How would I convert to traditional ASP? I have noted a long delay as you pointed when I enter...

    -------------------------------------------------------------------------------------
    A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."

    Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '

    Tommy Cooper

    April 18, 2008 at 1:19 am

    #804125

  • RE: ASP Web Front End??

    Steve Jones - Editor (4/16/2008)

    What do you mean "SQL Account" and where did you replace "NEtwork Service"?

    Hi Steve.

    SQL Account

    <add name="MyConnectionString" connectionString="Data...

    -------------------------------------------------------------------------------------
    A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."

    Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '

    Tommy Cooper

    April 17, 2008 at 2:34 pm

    #804006

  • RE: Substitute NULL value on converted date field?

    Peso awesome, many thanks to you and to all those that gave their time in assisting me with this problem.

    Many Thanks,

    Phil.

    -------------------------------------------------------------------------------------
    A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."

    Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '

    Tommy Cooper

    April 17, 2008 at 3:51 am

    #803552

Viewing 15 posts - 451 through 465 (of 541 total)