Forum Replies Created

Viewing 15 posts - 7,441 through 7,455 (of 8,731 total)

  • RE: Update column based on other column value

    You're welcome. I was gladly surprised the first time I realized that I could update/delete a CTE (is mostly like views).

    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

    November 20, 2013 at 9:18 am

    #1667847

  • RE: I want to be a DB Admin

    If you want to learn and practice, a good free resource can be Microsoft Virtual Academy.

    http://www.microsoftvirtualacademy.com/

    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

    November 20, 2013 at 9:09 am

    #1667844

  • RE: Which is better (Case, IsNull, COALESCE)

    Remember to have in mind the data type that ISNULL and COALESCE return.

    ISNULL will try to convert the second expression to the data type of the first expression.

    COALESCE will convert...

    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

    November 19, 2013 at 5:54 pm

    #1667642

  • RE: How to register a valid product key

    It's no longer a free edition. For a free edition it would say Evaluation Edition

    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

    November 19, 2013 at 3:49 pm

    #1667618

  • RE: Update column based on other column value

    Here's a more concise way to do it. You can update the table by updating the CTE.;-)

    WITH CTE AS(

    SELECT *, ROW_NUMBER() OVER( PARTITION BY ID ORDER BY ltr) rn

    FROM #tmp

    )

    UPDATE...

    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

    November 19, 2013 at 3:24 pm

    #1667614

  • RE: How to Create Excel file in SSIS

    The data flow will insert the data. If the file doesn't exist then it will create it. In fact, when the file doesn't exist, you have to define as well...

    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

    November 19, 2013 at 3:11 pm

    #1667608

  • RE: Improving DELETE performance

    LinksUp (11/19/2013)

    pmscorca (11/19/2013)

    Ultimately, the batch approach seems the better solution ..., isn't it?

    Test, test, and test!!

    There are a number of techniques to populate a test table with millions of rows...

    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

    November 19, 2013 at 2:56 pm

    #1667602

  • RE: How to Create Excel file in SSIS

    You could create a connection and change in the Expressions property to change the ConnectionString Property to something like this:

    "C:\\MyPath\\"+ (DT_STR, 50, 1252) (MONTH(GETDATE()) == 1 ? "January" : MONTH(GETDATE())...

    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

    November 19, 2013 at 1:50 pm

    #1667576

  • RE: How to insert data into table from linked server

    The Import/Export Wizard creates a "real SSIS" package, which you can save and open to edit or just review it and maybe run it again.

    It's a great tool for starters...

    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

    November 19, 2013 at 1:40 pm

    #1667571

  • RE: How to insert data into table from linked server

    A "large amount of data" might vary depending on the infrastructure of your company.

    If you right click on your database and then choose Tasks-> Import Data... you will get a...

    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

    November 19, 2013 at 1:25 pm

    #1667566

  • RE: How to insert data into table from linked server

    Maybe an SSIS package would be a better option if your doing a big load.

    To insert to a "local" table using a linked server, just use the insert into as...

    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

    November 19, 2013 at 12:16 pm

    #1667537

  • RE: Improving DELETE performance

    Use a DELETE in batches.

    DECLARE @i int = 1

    WHILE @i > 0

    BEGIN

    DELETE TOP (1000000)...

    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

    November 19, 2013 at 11:07 am

    #1667506

  • RE: Convert a field from numeric type to date format

    Sean Lange (11/19/2013)

    And then it would be HIGHLY advisable to change your schema that you store dates in a date column instead of numeric. It will save you countless hours...

    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

    November 19, 2013 at 8:29 am

    #1667433

  • RE: Columns to Rows

    And now correcting previous posted queries as they had syntax errors.

    Select distinct IDID,

    Data= REPLACE((Select distinct t1.data as [data()]

    From #Unpivot t1

    Where t1.IDID = t2.IDID

    Order by t1.data FOR XML...

    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

    November 19, 2013 at 8:24 am

    #1667431

  • RE: Columns to Rows

    I'm just modifying Dwain's query to reduce the code by using dense_rank.

    WITH SampleData (ID, Data) AS

    (

    SELECT 'A', 'P1' UNION ALL

    SELECT 'A', 'P1' UNION ALL

    SELECT 'A', 'P2' UNION ALL

    SELECT 'A', 'P2'...

    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

    November 19, 2013 at 8:17 am

    #1667426

Viewing 15 posts - 7,441 through 7,455 (of 8,731 total)