Forum Replies Created

Viewing 15 posts - 961 through 975 (of 8,731 total)

  • RE: Code-first vs database-first, any new developments?

    Neither database, nor code design first. You need to have a logical design which would include a correct ER design.
    Skipping this step will only give headaches when trying to...

    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

    September 26, 2017 at 1:02 pm

    #1961040

  • RE: Are the posted questions getting worse?

    WayneS - Tuesday, September 26, 2017 8:03 AM

    Jason A. Long - Saturday, September 23, 2017 5:31 PM

    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

    September 26, 2017 at 8:21 am

    #1960961

  • RE: Function to Round or Truncate DateTime

    Shane Clarke - Tuesday, September 26, 2017 5:08 AM

    Only issue is when joining with other tables.  That's why the original sample...

    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

    September 26, 2017 at 5:37 am

    #1960924

  • RE: Cursor assistance, cursor not updating table

    And here's an example on how to make it dynamic.

    DECLARE @sql nvarchar(max);
    SELECT @sql = N'SELECT fk_id'
        + ( SELECT '  ,MAX( CASE WHEN line_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

    September 22, 2017 at 1:26 pm

    #1960579

  • RE: Cursor assistance, cursor not updating table

    Don't use a cursor for this. There are a couple of alternatives which are more efficient. You can read about them in these articles:
    Cross Tabs and Pivots,...

    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

    September 22, 2017 at 1:15 pm

    #1960577

  • RE: Get the year and Qtr

    Papil - Friday, September 22, 2017 9:48 AM

    Ia am trying to get the year and Qtr from my date column which has...

    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

    September 22, 2017 at 10:15 am

    #1960547

  • RE: Help from Cortana

    And when you think that getting an assistant is a good idea. You might want to think twice and remember to add some security to its functionality.
    https://www.thesun.co.uk/fabulous/4502204/parrot-alexa-shopping-online-amazon-buddy-african-grey/

    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

    September 22, 2017 at 9:48 am

    #1960535

  • RE: Scripting Parameters Comments in Queries

    Go to Menu->Tools->Options...
    Choose the tab SQL Server Object Explorer -> Scripting
    I'm not sure if it can be removed, but you can search through the available options. I don'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

    September 22, 2017 at 9:37 am

    #1960530

  • RE: Dividing a count of rows from a table into equal batch sizes using NTILE

    You're thinking in the wrong direction. Instead of generating the rows and grouping them, you need to generate the groups and calculate which rows would you need to include. So,...

    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

    September 22, 2017 at 8:17 am

    #1960501

  • RE: Are the posted questions getting worse?

    crow1969 - Thursday, September 21, 2017 9:34 AM

    I would guess the conversion routine simply drops all thousands separators, and then converts to...

    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

    September 21, 2017 at 9:55 am

    #1960391

  • RE: General interview questions

    komal145 - Wednesday, September 20, 2017 10:32 AM

    I had an interview where the interviewer asked "how to load data to olap 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

    September 20, 2017 at 1:36 pm

    #1960261

  • RE: Recursive CTE help

    Ray K - Wednesday, September 20, 2017 9:02 AM

    Hi guys -- I could use some assistance with recursive CTEs.  I know the...

    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

    September 20, 2017 at 9:23 am

    #1960186

  • RE: Are the posted questions getting worse?

    Eirikur Eiriksson - Wednesday, September 20, 2017 7:46 AM

    Good to hear and fingers crossed! Find it incredible that it happened exactly...

    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

    September 20, 2017 at 7:57 am

    #1960167

  • RE: Are the posted questions getting worse?

    Jeff Moden - Tuesday, September 19, 2017 7:22 PM

    Luis Cazares - Tuesday, September 19, 2017 2:54 PM

    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

    September 20, 2017 at 7:26 am

    #1960159

  • RE: Filtered Index on a Temp Table, in a Stored Proc, can result in a Error 602

    Lynn Pettis - Tuesday, September 19, 2017 2:53 PM

    Dumb question, do you drop the temp table before exiting the procedure or just...

    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

    September 19, 2017 at 3:07 pm

    #1960048

Viewing 15 posts - 961 through 975 (of 8,731 total)