Forum Replies Created

Viewing 15 posts - 6,256 through 6,270 (of 8,731 total)

  • RE: Are the posted questions getting worse?

    Please do not disturb.

    Watching the World Cup and cheering for Mexico!:-D

    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

    June 13, 2014 at 10:07 am

    #1721550

  • RE: Splitting a single column into multiple rows

    J Livingston SQL (6/13/2014)

    http://www.sqlservercentral.com/articles/Tally+Table/72993/

    see code in resources at bottom of article

    Just correcting the IFCode to make it easier.

    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

    June 13, 2014 at 9:45 am

    #1721532

  • RE: Validation of a Parent - Child relationship

    Why do you have a Parent and Child in different tables? Should I assume that it's not a hierarchy but a header-detail?

    Could you include the deleted column on your PK...

    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

    June 13, 2014 at 9:44 am

    #1721531

  • RE: Can't Access the articles.

    Had the same problem and couldn't log in for a while. Seems to be working now.

    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

    June 13, 2014 at 9:39 am

    #1721525

  • RE: Export in txt from sql (in a pivot way)

    Order in a table is not guaranteed. Actually, it does not exists in a logical sense.

    You could force it with an identity column and being sure the inserts follow...

    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

    June 13, 2014 at 8:30 am

    #1721500

  • RE: Is there a way to do this without dynamic sql?

    The inserts don't match the table definitions.

    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

    June 12, 2014 at 6:08 pm

    #1721290

  • RE: Is there a way to do this without dynamic sql?

    TOP clause accepts variables and expressions.

    Example:

    SELECT TOP(DATEPART( HH, GETDATE()))

    *

    FROM master.sys.all_columns

    I'm not sure if that helps you because I'm not sure on how do you want to...

    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

    June 12, 2014 at 4:38 pm

    #1721276

  • RE: Counting the characters in a string before a space

    cbrammer1219 (6/12/2014)

    No I figured I would get the tsql working first, and then attempt that change.

    If you fix the data import, you don't need to work that hard on 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

    June 12, 2014 at 4:01 pm

    #1721270

  • RE: Counting the characters in a string before a space

    Did you even try to change the SSIS package to avoid all these complications?

    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

    June 12, 2014 at 3:54 pm

    #1721268

  • RE: Adding YYYYMMDD and HHMMSS to get mm/dd/yyyy HH:MM:SS

    There's no need to make that extra work with the date. You need to work with the run_duration column because it comes in format HHMMSS as well.

    selectsjh.Job_ID,

    ...

    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

    June 12, 2014 at 3:52 pm

    #1721266

  • RE: what does this query do?

    SQL_Surfer (6/12/2014)

    how can we modify this to keep today's record but delete previous entries?

    Have you tried MERGE to avoid doing this in 2 steps?

    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

    June 12, 2014 at 3:38 pm

    #1721262

  • RE: How can I strip Leading zero's from a string?

    Thank you for the feedback. You had the right idea on how to do it, I just helped you to get all the way there. 😉

    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

    June 12, 2014 at 12:59 pm

    #1721214

  • RE: Just curious, what are your SQL pet peeves ?

    Andrew Kernodle (6/12/2014)

    Yep, we're in the same boat as far as compatibility and versions go. We're technically not supposed to be using 2008R2 by the vendor's contract (2008 is...

    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

    June 12, 2014 at 12:39 pm

    #1721206

  • RE: How can I strip Leading zero's from a string?

    Fair enough. I thought you only had digits.

    Check for the following. 😉

    WITH SampleData AS(

    SELECT '00345.0001' code UNION ALL

    SELECT '02345.0123' code UNION ALL

    ...

    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

    June 12, 2014 at 12:32 pm

    #1721202

  • RE: Counting the characters in a string before a space

    cbrammer1219 (6/12/2014)

    I have attached a flatfile with the data I am processing in SSIS and inserting into MitelCallTrace, then parsing it and inserting it into CallTrace.

    I have posted the create...

    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

    June 12, 2014 at 12:26 pm

    #1721201

Viewing 15 posts - 6,256 through 6,270 (of 8,731 total)