Forum Replies Created

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

  • 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"

     ...

    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.

    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...

    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...

    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,...

    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

    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...

    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...

    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...

    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...

    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....

    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

    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

    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:
    ......

    April 10, 2017 at 7:07 am

    #1937414

  • RE: Running Total

    robertopmorris - Friday, April 7, 2017 2:04 PM

    Jeff:

    Thanks for the response.

    There are about 16,000 to 20,000 rows in the data set in...

    April 7, 2017 at 8:27 pm

    #1937299

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