Forum Replies Created

Viewing 15 posts - 5,206 through 5,220 (of 8,731 total)

  • RE: Convert mm/dd/yyyy, m/d/yyyy and mm/d/yyyy Date format To Date/datetime (yyyy/mm/dd) in SSIS

    I'm sorry, I didn't read that last part. I'll blame the lack of coffee.

    Leaving your flat file column as a string, you could use a conditional to generate null values...

    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

    February 19, 2015 at 10:18 am

    #1778708

  • RE: Convert mm/dd/yyyy, m/d/yyyy and mm/d/yyyy Date format To Date/datetime (yyyy/mm/dd) in SSIS

    Why don't you define your column as a date data type in your flat file connection and save yourself some problems? Your destination column should be a date data type...

    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

    February 19, 2015 at 9:18 am

    #1778677

  • RE: I have a field that has data like this and I need to pull out what is between the "-" and "x" 5.625X11.25-2.875x8.5 would be 2.875

    My bad, I didn't review the formula correctly.

    The problem is that you're counting characters before the first X and you're using that length to chop the last part which isn't...

    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

    February 18, 2015 at 3:12 pm

    #1778493

  • RE: name search idea requested

    If full text search is not a possibility for you (but hopefully it will), you could try an alternative by splitting the names/phrases into separate words to validate that at...

    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

    February 18, 2015 at 2:52 pm

    #1778486

  • RE: I have a field that has data like this and I need to pull out what is between the "-" and "x" 5.625X11.25-2.875x8.5 would be 2.875

    Drop the RTRIM().

    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

    February 18, 2015 at 2:41 pm

    #1778482

  • RE: Which plan is better?

    I wouldn't say that a plan is better than the other one, just different. The only difference is that in one plan it's a single statement and in the other...

    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

    February 18, 2015 at 2:27 pm

    #1778475

  • RE: Change row to column

    Read the following article regarding CROSS TABS. [/url]

    This is an example on how to do it.

    SELECT [Date/Time],

    MAX( CASE WHEN Tag = 0 THEN Value END) Tag0,

    ...

    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

    February 18, 2015 at 11:52 am

    #1778439

  • RE: DBA vs. Developer Question / Issue

    An experienced developer that likes to work with heaps in SQL Server is as good as a newbie.

    I guess the correct option would be to prevent her on what you're...

    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

    February 18, 2015 at 9:07 am

    #1778384

  • RE: Suggestion for replace a function or method

    A suggestion would be not to have the concatenated groups on the view and build only those needed.

    If you have your view with each group on a single row, you...

    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

    February 18, 2015 at 8:31 am

    #1778372

  • RE: Duplicate Values in UNPIVOT

    Maybe you'd like to check a different method to unpivot.

    http://www.sqlservercentral.com/articles/CROSS+APPLY+VALUES+UNPIVOT/91234/

    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

    February 18, 2015 at 8:25 am

    #1778369

  • RE: I have a field that has data like this and I need to pull out what is between the "-" and "x" 5.625X11.25-2.875x8.5 would be 2.875

    Lowell's solution is very complete, but if you only need one part of the string, it seems as an overkill to me.

    WITH MyCTE([jmaPartShortDescription])

    AS

    (

    SELECT '5.625X11.25-2.875x8.5 ' UNION ALL

    SELECT '5.625X35.25-2.875x32.5 ' UNION...

    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

    February 17, 2015 at 9:35 am

    #1778100

  • RE: SQL Injection, Still?

    Just to give an example on what can be done. But I agree that future replies should be done on a new thread.

    CREATE PROCEDURE _SearchCustomer

    @IdClient INT,

    ...

    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

    February 17, 2015 at 9:06 am

    #1778093

  • RE: Are the posted questions getting worse?

    SQLRNNR (2/16/2015)

    Grant Fritchey (2/16/2015)

    Lynn Pettis (2/15/2015)

    TomThomson (2/14/2015)

    Lynn Pettis (2/14/2015)

    TomThomson (2/14/2015)

    Eirikur Eiriksson (2/7/2015)

    TomThomson (2/7/2015)

    Grant Fritchey (2/5/2015)

    Really? Yankees fans? Are they even human?

    Usually not - they're mostly American.

    Tom, must say that I...

    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

    February 16, 2015 at 9:43 am

    #1777860

  • RE: looking for practice test and questions for mcsa exams

    You can look for some in here

    I've read that Trascender is a good option to study.

    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

    February 16, 2015 at 9:28 am

    #1777855

  • RE: create format file without delimiter

    Check the following page from BOL: https://msdn.microsoft.com/en-us/library/ms187833.aspx

    In the Sample XML Format Files section (bottom of the page):

    F. Importing fixed-length or fixed-width fields

    The following example describes fixed fields of 10 or...

    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

    February 16, 2015 at 7:55 am

    #1777837

Viewing 15 posts - 5,206 through 5,220 (of 8,731 total)