Forum Replies Created

Viewing 15 posts - 3,451 through 3,465 (of 5,502 total)

  • RE: Insert only one particular transaction?

    A TRY ...CATCH block might 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]

    May 24, 2010 at 4:57 am

    #1171462

  • RE: List of parameters having default values

    It's more than unlikely to get those values, since there are several ways to assign a default value to a parameter (e.g. as part of the CREATE PROCEDURE statement, using...


    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]

    May 24, 2010 at 3:59 am

    #1171442

  • RE: Help creating a simple validation rule PLEASEEEEE

    Without seeing your table defs and a description of your business case it's hard to tell...

    There are several versions around how to deal with such a scenario. Some are better...


    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]

    May 24, 2010 at 3:32 am

    #1171437

  • RE: Dataimport from csv-file

    You should add the following two options to import unicode data:

    CODEPAGE = 'RAW'

    DATAFILETYPE = 'widechar'

    That should help you to import your Swedish character (as long as the...


    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]

    May 24, 2010 at 3:08 am

    #1171427

  • RE: Week Number of a specific Date

    Gopi Muluka (5/24/2010)

    See this

    DECLARE @DT DATETIME, @WeekNumber INT

    SET @DT='03/01/2010'

    SELECT @WeekNumber=DATEPART(wk,@DT)

    SELECT @WeekNumber

    You need to be careful with DATEPART(wk,...) since it depends on the setting of DATEFIRST. Furthermore, it always starts with...


    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]

    May 24, 2010 at 2:56 am

    #1171424

  • RE: Select Distinct values based on timestamp

    Please havea look at ROW_NUMBER(). Use it with 'phone_number' ordered desc and select the results with rwn=1.

    [sarcasm ON] Since you marked it as "urgent" I replied the fastest way 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]

    May 24, 2010 at 2:51 am

    #1171421

  • RE: Counting maximum number of consecutive wins/losses

    You're very welcome 😀


    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]

    May 23, 2010 at 2:18 pm

    #1171328

  • RE: Xquery on XML column

    Sorry for answering late...

    A great resource is Jacob Sebastian's blog.

    And, if you don't find the answer there: post your question here on SSC. I've learned a lot and I'm...


    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]

    May 23, 2010 at 2:16 pm

    #1171327

  • RE: xml serialization and for xml sql server

    You might find an answer by searching Jacob Seabstian's blog.

    If not, please post a (fake) sample of your current data nd your expected result.

    We might be able to 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]

    May 23, 2010 at 1:59 pm

    #1171323

  • RE: Store procedure problem

    The problem is you're updating all rows with your first statement, since there is no WHERE condition that would limit the number of rows affected.

    Another option to get the result...


    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]

    May 23, 2010 at 1:55 pm

    #1171322

  • RE: Counting maximum number of consecutive wins/losses

    Hi Wayne,

    here's what I came up with (side note: I added an ID column to your original table to keep the order the data were inserted):

    ;WITH CTE AS

    (

    SELECT p_or_l,...


    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]

    May 23, 2010 at 1:49 pm

    #1171321

  • RE: Tables are not visible

    I'm not sure if this is the best place to ask for issues with a 3rd party product...

    You should check a website/forum related to that software.


    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]

    May 22, 2010 at 9:32 am

    #1171225

  • RE: Getdate time zone issue

    You might consider using GETUTCDATE() instead.

    But you need to take care of the different time zone you're in.


    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]

    May 22, 2010 at 9:27 am

    #1171222

  • RE: How to convert MySQL to SQL 2k5?

    Joie Andrew (5/20/2010)

    halifaxdal,

    I don't think that Lutz was trying to give you any attitude at all. I think he was simply trying to identify what you have already...


    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]

    May 21, 2010 at 6:48 am

    #1170782

  • RE: Tricky Aggregation

    Please read and follow the instructions given in the article referenced in the first link in my signature.

    This will allow us to work on a solution instead of trying 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]

    May 20, 2010 at 3:57 pm

    #1170491

Viewing 15 posts - 3,451 through 3,465 (of 5,502 total)