Forum Replies Created

Viewing 15 posts - 3,286 through 3,300 (of 5,502 total)

  • RE: order of rows during bulk insert

    I strongly recommend you number the rows prior to import.

    I'm sure there are tools available on the web that will add line numbers. I, personally, use a DOS batch file...


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    June 20, 2010 at 3:20 pm

    #1182522

  • RE: Removing duplicate data from column 2 on the priority of column 1

    First: What's the reason to use SSIS for it?

    Create a lookup table holding your website_name and your ordering number. Use something along "ROW_NUMBER() OVER (PARTITION BY email ORDER BY website_name_order)...


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    June 20, 2010 at 2:42 am

    #1182486

  • RE: order of rows during bulk insert

    TIM.OGRADY (6/19/2010)

    Is there a way to ensure that a flat file is loaded into sql in the exact sequence of the source file?

    I am having a similar concern with a...


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    June 20, 2010 at 2:32 am

    #1182485

  • RE: Stored Procedure to Update a 'Set' of values instead of one-at-a-time

    My pleasure 😀


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    June 17, 2010 at 3:43 pm

    #1181865

  • RE: Stored Procedure to Update a 'Set' of values instead of one-at-a-time

    Yes.

    You could provide the primary keys as a comma separated list (without blanks) and use a split string function to covert that list into a table (search for DelimitedSplit8K on...


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    June 17, 2010 at 3:25 pm

    #1181862

  • RE: Using an Int to store a date

    Stefan Krzywicki (6/17/2010)

    However, even the standard datetime has that problem if you're not dealing just with England, America and other former English posessions. Russia used the Julian calendar until 1918,...


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    June 17, 2010 at 2:21 pm

    #1181853

  • RE: "error converting data type nvarchar to numeric"

    I don't think it has to do with the server upgrade...

    it's more likely caused by the ISNUMERIC(ML.MISC_LAB_VALUE) = 1 function together with the CONVERT(DECIMAL...).

    Reason: ISNUMERIC() will return 1 for values...


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    June 17, 2010 at 2:13 pm

    #1181844

  • RE: Using an Int to store a date

    nikhil0416 (6/17/2010)

    ... Comparing two values of the Date data type will almost always perform better than comparing an int with a date value(in which case one has to be implicitly...


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    June 17, 2010 at 1:56 pm

    #1181832

  • RE: Creating a Stored Procedure to return an Int

    Glad I could help 😀


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    June 17, 2010 at 1:53 pm

    #1181830

  • RE: Using an Int to store a date

    Jason Messersmith (6/17/2010)

    I forgot to mention that this is in a data warehouse. so maybe it was to be able to join to a fiscal calendar quicker?

    I...


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    June 17, 2010 at 1:45 pm

    #1181825

  • RE: Creating a Stored Procedure to return an Int

    There a several ways to get the quarter of a given date (in the order of my personal preference for result in an INT format):

    1) use a calendar table that...


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    June 17, 2010 at 1:20 pm

    #1181807

  • RE: Using an Int to store a date

    Stefan Krzywicki (6/17/2010)

    ...

    If you can change it to a date column, I think you should. There may be others who can give you a good reason to keep it...


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    June 17, 2010 at 12:58 pm

    #1181796

  • RE: Using an Int to store a date

    If you have any chance to get the money back from that "consultant": go for it!

    It's one of the worst choices I've seen to store a date value. Even worse...


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    June 17, 2010 at 12:47 pm

    #1181793

  • RE: Vchar to datetime

    Unfortunately, it's a little more complicated, since SQL Server doesn't have a valid dateformat like the one you need to use as an input...

    SELECT CAST(LEFT(@t,8) +' ' +SUBSTRING(@t,9,2)+':' +SUBSTRING(@t,11,2)+':' +SUBSTRING(@t,13,2)...


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    June 17, 2010 at 12:40 pm

    #1181787

  • RE: Recordset Help

    Please read and follow the first link in my signature.

    Providing ready to use table DDL, sample data, expected result and what you've tried so far is the best way to...


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    June 17, 2010 at 10:28 am

    #1181700

Viewing 15 posts - 3,286 through 3,300 (of 5,502 total)