Forum Replies Created

Viewing 15 posts - 496 through 510 (of 3,232 total)

  • RE: Bulk Insert to Linked Server Error

    Most likely because BULK INSERT in the transact SQL method to invoke a BCP bulk copy so it is intended to run against the local instance. The bcp tool...

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    April 30, 2010 at 10:59 am

    #1160606

  • RE: Bulk Insert to Linked Server Error

    Here's the syntax definition from 2005. It does not support the 4 part naming convention. This came from BOL you could check on line for the 2008 version...

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    April 30, 2010 at 10:06 am

    #1160559

  • RE: Today's Random Word!

    Whiskey Steaks at the Drover! (Anniversary Celebration)

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    April 30, 2010 at 9:57 am

    #1160549

  • RE: Where are you?

    Mmm....on their website[/url] they call it the 'The Ultra Chocolatta Bar '.

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    April 29, 2010 at 10:43 am

    #1159893

  • RE: Where are you?

    Well worth it, in my opinion.

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    April 29, 2010 at 9:33 am

    #1159815

  • RE: Where are you?

    bklein2 (4/29/2010)

    Kansas City, MO - Great BBQ and good Blues music.

    Peppercorn Duck Club......my favorite restaurant on the planet.

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    April 29, 2010 at 9:13 am

    #1159790

  • RE: Today's Random Word!

    hunger

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    April 29, 2010 at 9:11 am

    #1159788

  • RE: Today's Random Word!

    CirquedeSQLeil (4/28/2010)

    tosscrosby (4/28/2010)

    Acid-trip.....oh wait, wrong forum.

    Rehab

    quiters

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    April 28, 2010 at 12:55 pm

    #1159230

  • RE: creating a view for one big table

    In SQL Server 2005/2008, you can have SQL Server manage your partitions. You don't need to create individual tables and join them with a view. As far as...

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    April 27, 2010 at 11:50 am

    #1158406

  • RE: Today's Random Word!

    spiral

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    April 27, 2010 at 10:56 am

    #1158375

  • RE: SISS row by row

    clucasi (4/26/2010)

    Cheers for the replies.

    The inserts,updates and deletes will only effect one row ie. it could update the row then delete the row and then insert the row all acording...

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    April 26, 2010 at 1:24 pm

    #1157837

  • RE: Today's Random Word!

    CirquedeSQLeil (4/23/2010)

    John Rowan (4/23/2010)

    Avatar Blue Ray.

    Will be watching it tonight.

    Well, what did you think? I saw it in the theater in 3D so I thought that would be disappointed...

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    April 26, 2010 at 11:24 am

    #1157757

  • RE: Need help with a query

    UPDATE Tutti.dbo.TBL_EMP

    SETsalary =

    CASE

    WHEN Sarlary BETWEN 20000 AND 40000 THEN Salary + 5000

    WHEN Sarlary BETWEN 40000 AND 55000 THEN Salary + 7000

    WHEN Sarlary BETWEN 55000 AND...

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    April 23, 2010 at 1:49 pm

    #1157121

  • RE: Today's Random Word!

    ChrisM@home (4/23/2010)

    John Rowan (4/23/2010)

    Chris Morris-439714 (4/23/2010)

    Sunny here in England, very pleasant 18C or so.

    Shooting all weekend, there's a competition in Chepstow on sunday for the first time in several...

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    April 23, 2010 at 12:41 pm

    #1157087

  • RE: Today's Random Word!

    Chris Morris-439714 (4/23/2010)

    Sunny here in England, very pleasant 18C or so.

    Shooting all weekend, there's a competition in Chepstow on sunday for the first time in several centuries - shooting...

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    April 23, 2010 at 12:25 pm

    #1157073

Viewing 15 posts - 496 through 510 (of 3,232 total)