Forum Replies Created

Viewing 15 posts - 2,881 through 2,895 (of 3,544 total)

  • RE: Uing BCP with multiple result sets 

    bcp "SELECT col1,col2 FROM databasename..tablename" 

    queryout file1.csv -S server -u username -P password -c -t "," 

    bcp "SELECT col1,col2 FROM databasename..tablename" queryout file2.csv -S server -u...

    Far away is close at hand in the images of elsewhere.
    Anon.

    December 16, 2003 at 5:26 am

    #486368

  • RE: 20 % records

    Does the table have a unique id? If so then

    select a.* 

    from tablea a 

    where a.[uniqueid] in 

    (select top 20 percent [uniqueid] 

    from tablea 

    where...

    Far away is close at hand in the images of elsewhere.
    Anon.

    December 15, 2003 at 9:47 am

    #486195

  • RE: Uing BCP with multiple result sets

    bcp each select into different file and then concatenate files.

    or

    If all the selects have same columns then use union.

    or

    Concatenate each column (converting to char/narchar if necessary) into single column with...

    Far away is close at hand in the images of elsewhere.
    Anon.

    December 15, 2003 at 9:13 am

    #486186

  • RE: Adding a value to a 'datetime' column caused overf

    Check your data (dbo.Progress_Notes.Date_) the lowest date allowed (SQL7) is '1753-01-01'. Subtracting from a date that produces a value less than this will cause the error.

    Far away is close at hand in the images of elsewhere.
    Anon.

    December 12, 2003 at 6:12 am

    #485923

  • RE: Missing integers from Excel

    quote:

    It said that the first 8 lines are used for determining whether the column will be imported as char or float....

    Far away is close at hand in the images of elsewhere.
    Anon.

    December 12, 2003 at 2:18 am

    #485892

  • RE: Missing integers from Excel

    Something like this was mentioned in another thread. It seems that if you use Excel import in DTS, Excel will not convert char and numeric in same column, if it...

    Far away is close at hand in the images of elsewhere.
    Anon.

    December 11, 2003 at 6:57 am

    #485698

  • RE: SQL Mail

    quote:

    but if you put a single quote before the numeric value, Excel will automatically treat it as text

    Far away is close at hand in the images of elsewhere.
    Anon.

    December 11, 2003 at 5:59 am

    #485687

  • RE: SQL-MAIL

    Either

    a) Install email client (Outlook 2000 or greater), create profile (under account running sql server) that uses a mailbox on exchange, set up sqlmail to use profile, use xp_sendmail to...

    Far away is close at hand in the images of elsewhere.
    Anon.

    December 10, 2003 at 6:16 am

    #485506

  • RE: Emailing via SMTP relay

    Sqlmail will only work with mapi profile and you need email client installed (Outlook 2000 or greater) although I believe SQL2000 SP3 allows the use of Outlook Express. Otherwise you...

    Far away is close at hand in the images of elsewhere.
    Anon.

    December 9, 2003 at 6:52 am

    #485309

  • RE: Stored procedure help needed.

    Agree with Frank.

    (Wow did I really say that )

    But if you do want to put the results in another table then

    INSERT...

    Far away is close at hand in the images of elsewhere.
    Anon.

    December 9, 2003 at 6:27 am

    #485303

  • RE: Alternative to NOT IN

    quote:

    The outer join should be faster than the Not Exists

    Hmmm, interesting. I thought...

    Far away is close at hand in the images of elsewhere.
    Anon.

    December 9, 2003 at 6:08 am

    #485297

  • RE: Happy anniversary

    quote:

    Am I wrong or are you much older than me

    Age is relative my...

    Far away is close at hand in the images of elsewhere.
    Anon.

    December 5, 2003 at 8:08 am

    #484833

  • RE: dubstraction in a sql query 

    SELECT s.id, s.item, 

    SUM(ISNULL(e.in,0)) as 'total_in', 

    SUM(ISNULL(e.out,0)) as 'total_out', 

    SUM(ISNULL(e.in,0)-ISNULL(e.out,0)) as 'total_stock' 

    FROM stock s 

    LEFT OUTER JOIN event e 

    ON s.id = e.item_id 

    GROUP BY...

    Far away is close at hand in the images of elsewhere.
    Anon.

    December 5, 2003 at 8:05 am

    #484828

  • RE: Happy anniversary

    Congrats and well done Frank, you sentimental sycophantic old fool.

    quote:

    Now, can a moderator please...

    Far away is close at hand in the images of elsewhere.
    Anon.

    December 5, 2003 at 7:57 am

    #484820

  • RE: Alternative to cursor

    quote:

    From OP's code, it doesn't appear that Cust is in the primary key, so perhaps that shouldn't be in the join.

    Far away is close at hand in the images of elsewhere.
    Anon.

    December 5, 2003 at 7:43 am

    #484807

    • Viewing 15 posts - 2,881 through 2,895 (of 3,544 total)