Forum Replies Created

Viewing 15 posts - 1,561 through 1,575 (of 2,647 total)

  • RE: Using BULK INSERT with a non delimited flat file

    If there are certain "fixed" things (number of lines in each set that you would consider a "row") you can have someone write something to parse out this file. My...

    Jared
    CE - Microsoft

    February 23, 2012 at 5:55 am

    #1450788

  • RE: Using BULK INSERT with a non delimited flat file

    sjimmo (2/22/2012)

    In your FMT file, you need to set up for each field the field type, length. I believe (it's been awhile) that you can tell it which position the...

    Jared
    CE - Microsoft

    February 22, 2012 at 6:34 pm

    #1450630

  • RE: How do I return only entries with multiple categories in a junction table?

    Can you group it by the person and do a distinct count of degree with the same criteria you have in that query. Then add HAVING COUNT(DISTINCT degree) >...

    Jared
    CE - Microsoft

    February 22, 2012 at 3:21 pm

    #1450583

  • RE: Current Date issue in where clause

    Jeremy... (2/22/2012)

    Lynn Pettis (2/22/2012)

    Wildcat (2/22/2012)

    Hakuna Matata (2/22/2012)

    Try this :

    WHERE CONVERT(DATE,FM.Openeddate)=CONVERT(DATE,GETDATE())

    I don't recommend to use this

    I agree with wildcat as it would cause a table scan. The convert function has...

    Jared
    CE - Microsoft

    February 22, 2012 at 2:52 pm

    #1450575

  • RE: Current Date issue in where clause

    Lynn Pettis (2/22/2012)

    Wildcat (2/22/2012)

    Hakuna Matata (2/22/2012)

    Try this :

    WHERE CONVERT(DATE,FM.Openeddate)=CONVERT(DATE,GETDATE())

    I don't recommend to use this

    I agree with wildcat as it would cause a table scan. The convert function has to...

    Jared
    CE - Microsoft

    February 22, 2012 at 2:51 pm

    #1450574

  • RE: Using BULK INSERT with a non delimited flat file

    dnolan5323 (2/22/2012)

    Thanks for the replies. Is there no way to use BCP and Bulk Insert to perform this task?

    Not until you create a file that fits a row/column format.

    Jared
    CE - Microsoft

    February 22, 2012 at 2:31 pm

    #1450567

  • RE: Using BULK INSERT with a non delimited flat file

    I'm not sure that you can do this without some more manipulation beforehand or "possibly" in SSIS. BULK INSERT is meant to insert large amounts of data that are...

    Jared
    CE - Microsoft

    February 22, 2012 at 2:25 pm

    #1450563

  • RE: PIVOT maybe?

    SQLKnowItAll (2/22/2012)

    TT-131210 (2/22/2012)

    I am getting error when I run this.

    Mmm hmm... What version of SQL Server are you running?

    HINT: Run this SELECT @@version

    I believe ColdCoffee's suggestion is exactly what you...

    Jared
    CE - Microsoft

    February 22, 2012 at 1:15 pm

    #1450532

  • RE: PIVOT maybe?

    TT-131210 (2/22/2012)

    I am getting error when I run this.

    Mmm hmm... What version of SQL Server are you running?

    HINT: Run this SELECT @@version

    I believe ColdCoffee's suggestion is exactly what you need.

    Jared
    CE - Microsoft

    February 22, 2012 at 12:40 pm

    #1450520

  • RE: SQL Server Job Notifications

    I give up! What group is in the FROM line? 🙂

    Jared
    CE - Microsoft

    February 22, 2012 at 12:36 pm

    #1450517

  • RE: Current Date issue in where clause

    Jeremy... (2/22/2012)

    Thanks Lynn. Is there a good place to find information on this topic? I've seen the below done 500 different ways and usually have trouble deciphering what...

    Jared
    CE - Microsoft

    February 22, 2012 at 12:14 pm

    #1450511

  • RE: Update Statement

    andersg98 (2/22/2012)

    I am not sure what you mean by "add to" but this should update the field to the value you specified

    UPDATE PROGRESS_NOTE

    SET PROGRESS_NOTE.SUPERVISOR_MONIKER =...

    Jared
    CE - Microsoft

    February 22, 2012 at 11:43 am

    #1450492

  • RE: update statement

    I'm confused... What happened here?

    Jared
    CE - Microsoft

    February 22, 2012 at 9:47 am

    #1450414

  • RE: Distribution cleanup job failing - transactional replication

    At least you found the source of the problem and were able to rectify it! Happy Fat Tuesday!

    Jared
    CE - Microsoft

    February 21, 2012 at 2:42 pm

    #1449994

  • RE: Distribution cleanup job failing - transactional replication

    MyDoggieJessie (2/21/2012)

    Success! 😎

    To tell you the truth I am blown away that there wasn't more information on this on BOL or MS forums...almost makes me feel special that I AM...

    Jared
    CE - Microsoft

    February 21, 2012 at 2:12 pm

    #1449962

Viewing 15 posts - 1,561 through 1,575 (of 2,647 total)