Forum Replies Created

Viewing 15 posts - 526 through 540 (of 1,246 total)

  • RE: Is SQL Server Replication going away?

    Maybe I am getting my terminology mixed up. The article mentions that replication between 2008 and 2016 is unsupported. This under the heading of "Items Deprecated in SQL Server...

    ----------------------------------------------------

  • RE: questions about sql

    I keep things simple, if it is in sys.tables then it is a table even if it is not ordered. I can always use an ORDER BY clause to pull...

    ----------------------------------------------------

  • RE: What is the best way to SELECT SUM while using PARTITION BY and WHERE and GROUP BY?

    Thanks for the feedback. And I wont bog you down with questions, just that if you want to let us know the exact issues you encountered then we can certainly...

    ----------------------------------------------------

  • RE: questions about sql

    (3) Design a package to transfer 10 files from FTP and store them to hard drive?

    Done. Ohh was this a question? 😛

    Did you have to draw this out on a...

    ----------------------------------------------------

  • RE: Load data using SSIS

    provide the serverpassword for FTP using a package config file.

    I know this is the quickest and easiest way to go about it. You know that you are storing a...

    ----------------------------------------------------

  • RE: Update column based on filter

    I also wonder if you may want in the future to know if when those actions occurred. In your current design you would need three new columns for the times...

    ----------------------------------------------------

  • RE: Find a date that is closest to a between date check

    We are going to need your table definitions and a script to fill them with sample data. (Directly from the articles that you were linked to). I am not clear...

    ----------------------------------------------------

  • RE: Temporary tables and Table variables storage

    SQL Server could hold everything in RAM. Yet the database objects need to be tagged as to what database they belong to. I look at it as temp tables and...

    ----------------------------------------------------

  • RE: Calculating odds ratio with T-SQL and R

    Good stuff, thank you for taking the time to explain this.

    ----------------------------------------------------

  • RE: Calculating odds ratio with T-SQL and R

    Diligentdba 46159 (8/31/2016)


    ' I would not underestimate the competence level of members here to pick up new knowledge. ' - neither do I but I do think the average sql...

    ----------------------------------------------------

  • RE: Calculating odds ratio with T-SQL and R

    Odds ratio is better explained here since there is a more detailed example https://en.wikipedia.org/wiki/Odds_ratio

    It makes better sense now, though I wouldn't call this simplistic necessarily.

    the sql server world is...

    ----------------------------------------------------

  • RE: Problem with Web Service Task

    lemmae880 (8/29/2016)


    HI

    CAN ANY ONE HELP PLEASE

    TITLE: Web Service Task

    ------------------------------

    Could not read the Web Services Description Language (WSDL) file. The input WSDL file is not valid. The following...

    ----------------------------------------------------

  • RE: Calculating odds ratio with T-SQL and R

    It seems to me that the odds ratio is equivalent to a percentage. n1/n2 only tells me how many of the bottom subgroup there are for each one of the...

    ----------------------------------------------------

  • RE: Views not changing when table changes

    This is why one must be very careful with the SELECT * approach. Since you will have to run a refresh of the view, I find it less potentially confusing...

    ----------------------------------------------------

  • RE: Script (C#) to add row to Object Variable (SSIS 2008 R2)

    SteveD SQL (8/30/2016)


    Hi MMartin1

    Thanks for your response, while my tables do have check and RI constraints I also use surrogate keys and therefore most of my data import type packages...

    ----------------------------------------------------

Viewing 15 posts - 526 through 540 (of 1,246 total)