Forum Replies Created

Viewing 15 posts - 6,121 through 6,135 (of 13,874 total)

  • RE: SSIS Package - sql task using stored procedure not populating all columns

    rtp (1/3/2017)

    Hi,

    I am having trouble with SSIS package which should insert rows from my Object named EmployeeList.

    I am not getting an error, but when it inserts into my table it...

    January 3, 2017 at 6:11 pm

    #1920523

  • RE: How to create error conditions inside function

    mcfarlandparkway (1/3/2017)

    Here we are returning 4 columns as I mentioned only one @NUM.

    There is another reason to use table valued function.

    Can you please modify the above one where to use...

    January 3, 2017 at 3:04 pm

    #1920514

  • RE: How to create error conditions inside function

    Put a THROW in there somewhere.

    January 3, 2017 at 2:14 pm

    #1920498

  • RE: SSMS 2016 / Windows 10 / Multiple Desktops

    sgmunson (1/3/2017)

    Phil Parkin (1/3/2017)

    sgmunson (1/3/2017)

    Phil Parkin (1/3/2017)

    sgmunson (1/3/2017)

    I have yet to play with that feature, and as I have multiple monitors, as well as Classic Shell installed and configured to...

    January 3, 2017 at 12:25 pm

    #1920456

  • RE: Renaming fields and combining them into one column

    joe 46898 (1/3/2017)

    I have a table with the following structure.

    Ind_Id | First_Name | Last_Name | FootBall | Soccer | Baseball | Basketball | Volleyball | Fuseball

    The sports columns have...

    January 3, 2017 at 10:53 am

    #1920442

  • RE: SSMS 2016 / Windows 10 / Multiple Desktops

    Thom A (1/3/2017)

    Hmm, interesting. I could replicate the problem, but not with SSMS. Strangely it was Outlook 2016 that wanted my attention. SSMS was happy to plum away

    I almost...

    January 3, 2017 at 8:06 am

    #1920389

  • RE: SSMS 2016 / Windows 10 / Multiple Desktops

    Thom A (1/3/2017)

    I'm yet to try out the feature myself, but I imagine it very much to be like the Multiple Desktop functionality that many Linux distributions have had for...

    January 3, 2017 at 7:20 am

    #1920364

  • RE: Conditional Join

    thbaig (1/3/2017)

    Phil Parkin (1/3/2017)

    So do the left join and then use COALESCE to pick up t2 data if it exists:

    select ColName = coalesce(t2.col,t1.col)

    If following is as per suggestion, it return...

    January 3, 2017 at 7:15 am

    #1920361

  • RE: SSMS 2016 / Windows 10 / Multiple Desktops

    sgmunson (1/3/2017)

    Phil Parkin (1/3/2017)

    sgmunson (1/3/2017)

    I have yet to play with that feature, and as I have multiple monitors, as well as Classic Shell installed and configured to have the task...

    January 3, 2017 at 7:08 am

    #1920358

  • RE: SSMS 2016 / Windows 10 / Multiple Desktops

    sgmunson (1/3/2017)

    I have yet to play with that feature, and as I have multiple monitors, as well as Classic Shell installed and configured to have the task bar appear on...

    January 3, 2017 at 6:49 am

    #1920346

  • RE: Conditional Join

    So do the left join and then use COALESCE to pick up t2 data if it exists:

    select ColName = coalesce(t2.col,t1.col)

    January 3, 2017 at 6:36 am

    #1920341

  • RE: recommendation of tempb files

    kevaburg (12/31/2016)

    Phil Parkin (12/31/2016)

    kevaburg (12/31/2016)

    Microsofts recommendations are a "one-shoe-fits-all" solution that I am not a huge fan of.

    The reason I said this is because of this statement......

    As a general...

    December 31, 2016 at 8:39 am

    #1920203

  • RE: recommendation of tempb files

    kevaburg (12/31/2016)

    Microsofts recommendations are a "one-shoe-fits-all" solution that I am not a huge fan of.

    ...

    Here is a direct quote from the Microsoft recommendations:

    Create as many files as needed to maximize...

    December 31, 2016 at 7:30 am

    #1920198

  • RE: Huge regression after upgrading from 2014 to 2016

    Jeff Moden (12/31/2016)

    kevaburg (12/31/2016)

    I experienced performance regression after a migration project due to differing collations between the source database and tempdb. As I prepared the Server for the Migration...

    December 31, 2016 at 7:24 am

    #1920197

  • RE: Where to place WITH (NOLOCK) ?

    BOR15K (12/30/2016)

    ThomasRushton (12/30/2016)

    Phil Parkin (12/30/2016)

    Further to Thomas' answer, the flippant answer given by many people here would be 'in the garbage'.

    y'know, that was my first answer... but I...

    December 30, 2016 at 1:21 pm

    #1920154

Viewing 15 posts - 6,121 through 6,135 (of 13,874 total)