Forum Replies Created

Viewing 15 posts - 3,376 through 3,390 (of 15,381 total)

  • RE: DAte Function

    Ed Wagner (1/23/2015)

    sharonsql2013 (1/23/2015)

    I have a column in the table with datatype DATE

    Gives data in the format

    YYYY_MM_DD

    How can I go back to past 12 months in my where clause

    So ,...

    January 23, 2015 at 12:00 pm

    #1772785

  • RE: ID or Id

    RonKyle (1/23/2015)

    Sequence - this is no different logically than an int or identity, the difference is in how it is generated.

    It may not be different logically, but if it's important...

    January 23, 2015 at 11:52 am

    #1772782

  • RE: ID or Id

    Eric M Russell (1/23/2015)

    Now on to data types.

    Currency: should it be decimal, numeric, money, int?

    Definitely not int. That is unacceptable because you either have to divide by 100.0 all the...

    January 23, 2015 at 10:41 am

    #1772748

  • RE: Remove Duplicates in opposite columns

    keith.west-982594 (1/22/2015)

    This solution worked perfectly. Thanks for your help. I definitely need to study the CROSS APPLY feature more.

    Take a look at the two articles in my signature...

    January 22, 2015 at 9:27 am

    #1772286

  • RE: sql injection

    Listen to what Gail says. Blacklisting words is never going to work. A user can pass in hex strings too which will be converted back into text. Your blacklist will...

    January 22, 2015 at 7:32 am

    #1772217

  • RE: How to sum and group data

    tino.lopez (1/21/2015)

    I understand. I have attached the data. I simply(obviously not simple for me) want to display all the data attached grouped by CUSTACCT and by FLTHRSYEAR.

    Can you convert these...

    January 21, 2015 at 1:58 pm

    #1771976

  • RE: How to sum and group data

    tino.lopez (1/21/2015)

    I guess what I am not understanding is why is it that I have three types of data, one for Flight hrs, one for Exchange fees and one for...

    January 21, 2015 at 1:30 pm

    #1771962

  • RE: query or other solution to find active databases in sql instance

    jim.metcalf1974 (1/21/2015)

    After some research I wanted to use the audit feature on one particular server and it says.

    auditing is not a feature on this server. 2008 r2...

    January 21, 2015 at 10:13 am

    #1771916

  • RE: Are the posted questions getting worse?

    Sioban Krzywicki (1/21/2015)

    Hi everyone,

    I have a bit of an announcement and a question.

    I'm Transgender. I've come out as a woman in nearly every aspect of my life now and am...

    January 21, 2015 at 9:23 am

    #1771886

  • RE: ID or Id

    below86 (1/21/2015)

    Sean Lange (1/20/2015)

    Eric M Russell (1/20/2015)

    I've used product_id. I like typing code in all lowercase, both keywords and identifiers, which is ok so long as underscores are also used...

    January 21, 2015 at 9:18 am

    #1771885

  • RE: ID or Id

    Eric M Russell (1/21/2015)

    However, I would take issue with ID by itself, on every table. Anytime I see that, I have low expectations for how the rest of the database...

    January 21, 2015 at 9:15 am

    #1771883

  • RE: Are the posted questions getting worse?

    dwain.c (1/20/2015)

    Sean Lange (1/20/2015)

    Ed Wagner (1/20/2015)

    Brandie Tarvin (1/20/2015)

    Sean Lange (1/20/2015)

    We are finally starting to move our ERP to a new system (well new to us but still rather antiquated). In...

    January 20, 2015 at 4:46 pm

    #1771648

  • RE: Help Needed in Avoiding RBAR

    KGJ-Dev (1/20/2015)

    Sorry Gentleman, am little confused.

    I am not updating the UserId. i am just updating the Amount and always the amount will not be same because this process will update...

    January 20, 2015 at 3:01 pm

    #1771636

  • RE: How to sum and group data

    tino.lopez (1/20/2015)

    The FLIGHTHRSSUM, LATEFEESUM and EXCHFEESUM are already summed. I simply need to group them by CUSTACCT(Customer) and have the records display according to their YEAR and PERIOD(Month).

    ORDER BY CustAcct,...

    January 20, 2015 at 2:52 pm

    #1771632

  • RE: Help Needed in Avoiding RBAR

    KGJ-Dev (1/20/2015)

    Thanks sean, in that case i am updating the amount. can both the syntax below results same?

    OUTPUT INSERTED.UserId

    OUTPUT Deleted.UserId

    If that column is not being updated or...

    January 20, 2015 at 2:50 pm

    #1771629

Viewing 15 posts - 3,376 through 3,390 (of 15,381 total)