Forum Replies Created

Viewing 15 posts - 3,661 through 3,675 (of 8,731 total)

  • RE: separate bad data from valid data

    arkiboys (12/9/2015)

    Luis Cazares (12/9/2015)

    I would define the columns from the text file as strings, then use a data conversion or derived column transformation to change the columns' types. That transformation...

    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

    December 9, 2015 at 7:54 am

    #1844908

  • RE: separate bad data from valid data

    I would define the columns from the text file as strings, then use a data conversion or derived column transformation to change the columns' types. That transformation should have 2...

    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

    December 9, 2015 at 7:26 am

    #1844903

  • RE: Strange SSIS problem - could use a little help

    Are you sure the SSIS package is inserting the data in the correct server?

    If the package log indicates it's inserting rows and the destination server doesn't show any activity, 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

    December 8, 2015 at 1:16 pm

    #1844763

  • RE: Cumulative count

    This follows the rule for Desired Open.

    I'm guessing that you're getting these values from a query and not a table, and the Closed Count should have the value only for...

    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

    December 8, 2015 at 1:11 pm

    #1844762

  • RE: Are the posted questions getting worse?

    Eirikur Eiriksson (12/8/2015)

    BrainDonor (12/8/2015)

    Here's one I've never seen before - every thread on a full page of the search started by the same person.

    Someone is very busy.

    Too busy for RTFM

    😎

    OMG,...

    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

    December 8, 2015 at 12:49 pm

    #1844758

  • RE: Today's Random Word!

    Ed Wagner (12/8/2015)

    Revenant (12/8/2015)

    Ed Wagner (12/8/2015)

    crookj (12/8/2015)

    lithopanspermia

    Star Trek

    Voyage

    Home

    Alone

    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

    December 8, 2015 at 12:14 pm

    #1844749

  • RE: SQL Query

    patrickmcginnis59 10839 (12/8/2015)

    smmkr17 (12/5/2015)

    Current table

    ColA ColB ColC

    A 1 Yes

    A 2 No

    A 1 Yes

    A 1 Yes

    B 1 Yes

    B 2 Yes

    C 1 Yes

    D 1 No

    My result should be

    A No

    B Yes

    C No

    If ColA...

    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

    December 8, 2015 at 12:10 pm

    #1844748

  • RE: Cumulative count

    Can you explain the rows for 2015-07-23 on the new sample data?

    Why are the Open counts summed individually and the Closed counts aren't? Why are the previous summed as 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

    December 8, 2015 at 11:44 am

    #1844745

  • RE: separate bad data from valid data

    Depending on the type of bad data. A conditional split could work, or simply error handling to redirect bad rows.

    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

    December 8, 2015 at 10:30 am

    #1844729

  • RE: Displaying only valid data

    Could you unpivot the data in the query?

    CREATE TABLE #Test(

    A1 CHAR(2),

    A2 CHAR(2),

    A3 CHAR(2),...

    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

    December 8, 2015 at 9:16 am

    #1844697

  • RE: Cumulative count

    John Mitchell-245523 (12/8/2015)

    That doesn't return the result set that the OP requires. He appears to want the cumulative count to show 0 unless there is actually a value in...

    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

    December 8, 2015 at 9:05 am

    #1844689

  • RE: Cumulative count

    Why do you have a zero on CummClosedDate for 2015-07-08? If you really need a cumulative count, the case is not needed.

    SELECT IndividualDate,

    ClosedDate,

    ...

    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

    December 8, 2015 at 8:49 am

    #1844678

  • RE: String manipulation : Need to change the first and last letters to upper case

    3 possible options. I used LOWER, but I'm not sure if you need it.

    PRINT UPPER(LEFT(@name,1)) + LOWER( SUBSTRING(@name,2,Len(@name)-2)) + UPPER(right(@name,1))

    PRINT STUFF( STUFF( LOWER(@Name), 1, 1, UPPER(LEFT(@name,1))), LEN(@name), 1, UPPER(RIGHT(@name,1)))

    PRINT UPPER(LEFT(@name,1))...

    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

    December 7, 2015 at 1:52 pm

    #1844486

  • RE: How to write Query that one filed have 2 Values

    Some other ways. The last one is similar to serg's, but should perform better because it should read less rows. However, I can't assure it will perform better without real...

    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

    December 7, 2015 at 10:31 am

    #1844442

  • RE: Converting a date

    Sean Lange (12/7/2015)

    Sergiy (12/6/2015)

    Jason A. Long (12/6/2015)

    It's probably worth mentioning that the CAST/CONVERT in the predicate only works when using certain datatypes.

    And only on certain versions of CQL Server.

    Microsoft SQL...

    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

    December 7, 2015 at 7:54 am

    #1844389

Viewing 15 posts - 3,661 through 3,675 (of 8,731 total)