Forum Replies Created

Viewing 15 posts - 1,276 through 1,290 (of 8,731 total)

  • RE: Are the posted questions getting worse?

    ChrisM@Work - Tuesday, May 16, 2017 9:15 AM

    Brandie Tarvin - Tuesday, May 16, 2017 7:04 AM

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    May 16, 2017 at 10:35 am

    #1942731

  • RE: Sql Header and Then record output I need customer header line and then the record line can I do this with just SQL???

    Usually, you want to repeat header information as part of the key for each row. That way, the front end will consume the data and present it in the correct...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    May 16, 2017 at 9:02 am

    #1942712

  • RE: Not sure how to get all data on one line

    Wild guess:
    Use aggregate functions.

    SELECT DISTINCT     RTRIM(MAS.ID)    AS "EMPLOYEE ID"
              --,RTRIM(MAS.SSN)   AS "SSN"
              ,RTRIM(MAS.BDT)   AS "DATE OF BIRTH"
              ,MAX(CASE WHEN PXD.PYX_NO = 2111 THEN...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    May 16, 2017 at 7:06 am

    #1942691

  • RE: How to create data with numeric ranges

    The best option is to use a tally table. Then you can work around that to keep only a certain range and use a certain interval.
    Here's an example, but...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    May 16, 2017 at 7:00 am

    #1942689

  • RE: Round Natural Numbers to the nearest Power of 10

    Your function has a problem when it's used against negative numbers. I wrote an article some time ago about this options which simulate CEILING and FLOOR. You can read it...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    May 16, 2017 at 6:27 am

    #1942686

  • RE: Syntax error

    komal145 - Monday, May 15, 2017 9:15 AM

    hi ..Can anyone tell me what is the error here. I tried closing the table...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    May 15, 2017 at 9:25 am

    #1942587

  • RE: SSIS Flat File Mapping - DATETIME Conversion Error

    ShuaibV - Friday, May 12, 2017 6:14 PM

    Hi
    I have a flat file (pipe Delimited) which contains Datetime field (Format: 2017-04-04T21:46:17.931+00).  I have...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    May 15, 2017 at 9:03 am

    #1942580

  • RE: convert string YYYYMM into date SSIS

    Jeff Moden - Monday, May 15, 2017 7:51 AM

    joanna.seldon - Monday, May 15, 2017 7:36 AM

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    May 15, 2017 at 8:12 am

    #1942561

  • RE: Are the posted questions getting worse?

    jasona.work - Monday, May 15, 2017 6:08 AM

    Hmm, I'm thinking we need an article on the performance differences of the four...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    May 15, 2017 at 6:56 am

    #1942530

  • RE: Order By Limitations and Restrictions

    Igor Micev - Saturday, May 13, 2017 11:23 AM

    Actually the limitation of the columns in ORDER BY is 8060, in the...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    May 15, 2017 at 6:18 am

    #1942520

  • RE: Are the posted questions getting worse?

    jonathan.crawford - Friday, May 12, 2017 12:34 PM

    ...and now I'm wondering if I can't buy a Leap controller and a wand and...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    May 12, 2017 at 12:48 pm

    #1942389

  • RE: Are the posted questions getting worse?

    jonathan.crawford - Friday, May 12, 2017 12:30 PM

    My code from today included the following comments:

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    May 12, 2017 at 12:35 pm

    #1942387

  • RE: Are the posted questions getting worse?

    Funny that you started talking about comments when a friend posted the following quote:

    “Good code is its own best documentation. As you’re about to add a comment, ask...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    May 12, 2017 at 12:11 pm

    #1942380

  • RE: Select / calculate multple rows then update single row

    sc-w - Thursday, May 11, 2017 11:35 AM

    Hi,

    Looking for help with a bit of a...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    May 11, 2017 at 12:48 pm

    #1942216

  • RE: Are the posted questions getting worse?

    John Mitchell-245523 - Thursday, May 11, 2017 4:36 AM

    Did anybody else who doesn't live in "Washington D.C., the fifty (50) United States...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    May 11, 2017 at 5:47 am

    #1942139

Viewing 15 posts - 1,276 through 1,290 (of 8,731 total)