Forum Replies Created

Viewing 15 posts - 10,741 through 10,755 (of 13,876 total)

  • RE: Output to CSV or txt file from Query Window

    haichells (5/6/2012)


    Thanks. But this will not help 🙁 Output should be automatically pushed into CSV and not a manual process.

    This requirement sounds flaky to me.

    You want an automatic process, and...

  • RE: Multiple extracts using single DTS

    You should try posting this in the DTS forum.

    This one is for SSIS.

  • RE: Changing Data type from char to numeric

    If you lookup the function, you'll find that 1/true and 0/false are the only two results it provides per check. You tested the value and found it to be false...

  • RE: Script Task – Append Files

    kevin.mitchell (5/1/2012)


    Hi,

    I trying to carry out some basic file manipualtion within a Script Task.

    I have 2 existing files Header.Txt and Footer.txt and I would like to append them to a...

  • RE: t-sql query

    Eugene Elutin (5/1/2012)


    ...

    Using != instead of <> is not recommended, as != is non-ISO standard (though it still works).

    ...

    I prefer to use "!=" over "<>". Is any reference material where...

  • RE: Issue with duplicate data

    You can deduct whatever you want from whatever you like.

    This could come in very useful. I'd like to deduct all the French people from the city I live in.

    :w00t:...

  • RE: t-sql query

    justmohit (5/1/2012)


    Add this line in Where clause

    r1.isdirectory!=1

    Bye!

    Using != instead of <> is not recommended, as != is non-ISO standard (though it still works).

    As the IsSubdirectory column is a Bit column,...

  • RE: Msg 911, Level 16, State 1, Line 1 Database 'databasename' does not exist. Make sure that the name is entered correctly.

    tt-615680 (5/1/2012)


    Dear All,

    Would anyone be able to let me know how to resolve the following error message please?

    Msg 911, Level 16, State 1, Line 1

    Database 'databasename' does not exist....

  • RE: t-sql query

    Add

    WHERE IsDirectory <> Cast(1 as bit)

    to the end of your query.

  • RE: Delete duplication with where clause condition

    his has also happened because i could not memorises everyone names and switching back and forth just to check names is not easy.

    Actually, it should be very easy. Just have...

  • RE: Why would derived column component remove rows?

    A Rampaging Deduper - who said IT can't be exciting?

  • RE: LEN function

    Here is a sample: I guessed what Tara-1044200 was attempting to do.

    Indeed & a fair guess. But her post immediately after your suggestion seemed to indicate that things were still...

  • RE: LEN function

    Tara-1044200 (4/29/2012)


    actaully there isnt any table in real, i am just trying to use len(column)-12 which seems to be not working but it works for len(column)-8 so i was thinking...

  • RE: Query Multiple Tables (how to)

    kirkm 55368 (4/29/2012)


    Thanks for the response, Phil.

    I see now using the actual field and table names would have been better.

    I'm getting :-

    Syntax error (missing operator) in query expression "tblBritburn' Table'.

    And...

  • RE: Insert Problem

    .Netter (4/29/2012)


    Hi All,

    I have an online exam which inserts the user answers in to a table then works out how many correct answers they have got which is working fine,...

Viewing 15 posts - 10,741 through 10,755 (of 13,876 total)