Forum Replies Created

Viewing 15 posts - 1,381 through 1,395 (of 8,731 total)

  • RE: Are the posted questions getting worse?

    jasona.work - Friday, April 14, 2017 8:59 AM

    Lynn Pettis - Friday, April 14, 2017 8:43 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

    April 14, 2017 at 10:38 am

    #1938192

  • RE: Nuance of datetime data type in SQL Server

    SQLian - Thursday, April 13, 2017 3:29 AM

    As pedantic as this is.....

    "I can see only one way to do this"

     ...

    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

    April 13, 2017 at 1:46 pm

    #1938123

  • RE: Latest

    This is additional work, but I noticed it today.
    You can apply filters to avoid this problem.

    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

    April 13, 2017 at 11:11 am

    #1938105

  • RE: calling back function

    girl_bj - Thursday, April 13, 2017 8:41 AM

    i would like to clean it on certain condition.
    if user input name which contains Mary...

    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

    April 13, 2017 at 10:51 am

    #1938102

  • RE: Convert Date Time Parameter to String

    OMG, don't use strings. SSRS parameters have 2 properties: value and label. Value should be a date/time data type, while label can be a string representation of that value 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

    April 13, 2017 at 10:29 am

    #1938094

  • RE: Date conversion in ssis

    Thom A - Thursday, April 13, 2017 7:30 AM

    SSIS does no understand named months (or at least I'm pretty sure it doesn'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

    April 13, 2017 at 9:09 am

    #1938079

  • RE: Today's Random Word!

    Ed Wagner - Thursday, April 13, 2017 7:19 AM

    ManicStar - Thursday, April 13, 2017 7:13 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

    April 13, 2017 at 7:32 am

    #1938042

  • RE: Date conversion in ssis

    Charmer - Thursday, April 13, 2017 5:03 AM

    Hi Team,

    I am trying to convert this date format "11-APR-2016 11:24:36.000000" in derived column 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

    April 13, 2017 at 7:07 am

    #1938030

  • RE: SQL code

    sqlnewbie17 - Wednesday, April 12, 2017 12:41 PM

    ServerName    type    type_desc    DBname    physical_name    state    state_desc    Datetime
    A        0    ROWS        Db1    E:\Db1.mdf    0    ONLINE        43:27.2
    A        0    ROWS        Db2    E:\Db2.mdf    0    ONLINE        43:27.2
    B        1    LOG        Db1    F:\Db1.ldf    0    ONLINE        43:27.2
    B        1    LOG        Db2    F:\Db2.ldf    0    ONLINE        43:27.2
    C        0    ROWS        Db3    E:\Db3.mdf    0    ONLINE        43:27.2
    C        1    LOG        Db3    F:\Db3.ldf    0    ONLINE        43:27.2
    D        0    ROWS        Db4    E:\Db4.mdf    0    ONLINE        43:27.2
    D        1    LOG        Db4    F:\Db4.ldf    0    ONLINE        43:27.2
    E        0    ROWS        Db5    E:\Db5.mdf    0    ONLINE        43:27.2
    E        1    LOG        Db5    F:\Db5.ldf    0    ONLINE        43:27.2
    E        0    ROWS        Db6    E:\Db6.mdf    0    ONLINE        43:27.2
    E        1    LOG        Db6    F:\Db6.ldf    0    ONLINE        43:27.2
    E        0    ROWS        Db7    E:\Db7.mdf    0    ONLINE        43:27.2
    E        1    LOG        Db8    E:\Db8.ldf    0    ONLINE        43:27.2

    I need to represent the above table in this way in a select statement.
    Any number...

    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

    April 12, 2017 at 2:22 pm

    #1937938

  • RE: Adding to the end of a variable inside a loop

    Here's a version that doesn't use a loop.

    DECLARE @recipientsX varchar(150)
       ,@copy_recipientsX varchar(150)
       ,@blind_copy_recipientsX varchar(150)
       ,@SubjectLineX varchar(150)
       ,@attachmX1...

    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

    April 11, 2017 at 12:08 pm

    #1937694

  • RE: Adding to the end of a variable inside a loop

    chriso 73655 - Tuesday, April 11, 2017 10:48 AM

    I have a variable that i am assigning HTML code for an email inside...

    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

    April 11, 2017 at 10:55 am

    #1937677

  • RE: Unable to see management studio

    vijay.singh 46672 - Tuesday, April 11, 2017 6:54 AM

    Hi,

    I installed SQL Server 2016 express but i am unable to see Management studio....

    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

    April 11, 2017 at 7:07 am

    #1937596

  • RE: Are the posted questions getting worse?

    Greg Edwards-268690 - Monday, April 10, 2017 11:02 AM

    jasona.work - Monday, April 10, 2017 7:16 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

    April 11, 2017 at 6:25 am

    #1937590

  • RE: Mass associations without looping?

    This method is slower but doesn't depend on sequential data, just on the PartyID being unique.

    WITH cteParties AS(
      SELECT *, ROW_NUMBER() OVER(ORDER BY PartyID) pid

    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

    April 10, 2017 at 7:45 am

    #1937430

  • RE: Speeding up this function??

    Luis Cazares - Thursday, April 6, 2017 6:58 AM

    ...
    To know more about what I did here, check the following articles:
    ......

    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

    April 10, 2017 at 7:07 am

    #1937414

Viewing 15 posts - 1,381 through 1,395 (of 8,731 total)