Forum Replies Created

Viewing 15 posts - 1,546 through 1,560 (of 5,502 total)

  • RE: Why is coalesce function ignoring where clause

    The error most probably points to the column left(Code.Code,3) with a missing alias.

    Regarding the first occurence issue: maybe it's possible to filter it out with a WHERE clause or another...


    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 19, 2011 at 10:32 am

    #1327218

  • RE: Combinations and Permutations

    GSquared (5/18/2011)

    LutzM (5/18/2011)

    GSquared (5/18/2011)

    I put in the non-repeat bit because of the way Steve wrote his original Where clause. I just moved it into the Joins.

    Gus: If this concept...


    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 18, 2011 at 1:12 pm

    #1326732

  • RE: Combinations and Permutations

    Brandie Tarvin (5/18/2011)

    LutzM (5/18/2011)

    GSquared (5/18/2011)

    I put in the non-repeat bit because of the way Steve wrote his original Where clause. I just moved it into the Joins.

    Gus: If this...


    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 18, 2011 at 1:05 pm

    #1326729

  • RE: Combinations and Permutations

    GSquared (5/18/2011)

    I put in the non-repeat bit because of the way Steve wrote his original Where clause. I just moved it into the Joins.

    Gus: If this concept is expanded...


    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 18, 2011 at 12:47 pm

    #1326712

  • RE: Combinations and Permutations

    Something like this?

    SELECT a.id 'a', b.id 'b', c.id 'c', d.id 'd', e.id 'e'

    FROM Combinations a

    CROSS JOIN dbo.Combinations b

    CROSS JOIN dbo.Combinations c

    ...


    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 18, 2011 at 11:11 am

    #1326664

  • RE: assign the same value to new column till new value changes in the table column

    punia (5/18/2011)

    Hi Vineet,

    I did that way but it do not fulfill the requirement.

    It do not work for ID 45. as it assign value 2 to second 'B' rank.

    cycle should be...


    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 18, 2011 at 10:41 am

    #1326637

  • RE: Unable to import more than 65523 rows from excelsheet to sql table using OPENROWSET

    Duplicate post. No replies please.

    Original post: http://www.sqlservercentral.com/Forums/FindPost1110610.aspx


    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 17, 2011 at 3:18 pm

    #1326148

  • RE: assign the same value to new column till new value changes in the table column

    How would you differentiate between

    ID Rank Cycle

    42 A 1

    42 B 1

    42 A 2

    and

    ID Rank Cycle

    42 A 2

    42 B 1

    42 A 1

    ?

    In other words: there is an additional column missing...


    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 17, 2011 at 12:43 pm

    #1326064

  • RE: Why is coalesce function ignoring where clause

    It seems like you got trapped by a "semi-optimal" table design...

    You might want to look into UNPIVOT to normalize the table. This would make the query much easier and most...


    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 17, 2011 at 12:35 pm

    #1326060

  • RE: Stored procedure Execution with Prompt "Overwrite or not"

    Another option (or expanding one of the alternatives Gus mentioned) would be to use a variable when calling the sproc indicating whether it's the first run or a subsequent call.

    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 16, 2011 at 4:11 pm

    #1325520

  • RE: Are the posted questions getting worse?

    Stefan Krzywicki (5/16/2011)

    LutzM (5/16/2011)

    ...

    I think one of the major issues for not being considered is the fact that SQL Server requires a Microsoft OS whereas Oracle and DB2 offer more...


    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 16, 2011 at 1:21 pm

    #1325415

  • RE: Are the posted questions getting worse?

    Stefan Krzywicki (5/16/2011)

    Here's an interesting article on Oracle satisfaction[/url]

    SQL Server's not even mentioned, I guess we have a way to go in being considered suitable for very large databases. 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]

    May 16, 2011 at 12:48 pm

    #1325390

  • RE: Selecting specific characters in a field

    Just in case you're looking for a solution to recognize both characters (code snippet heavily borrowed from Ron):

    DECLARE @T VARCHAR(12)

    SET @T = 'xy9^1234567890'

    SELECT PATINDEX ( '%9^%' ,@T)

    SELECT SUBSTRING(@T,PATINDEX ( '%9^%'...


    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 15, 2011 at 3:52 pm

    #1324790

  • RE: SQL procedure for customer classification

    You might want to have a look at the first article referenced in my signature for a guide on how to post ready to use sample data.


    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 15, 2011 at 3:46 pm

    #1324788

  • RE: Are both these select statements same?

    As a more general answer you might want to have a look at Gails blog[/url] regarding left outer join vs not exists. 😉


    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 15, 2011 at 3:11 pm

    #1324781

Viewing 15 posts - 1,546 through 1,560 (of 5,502 total)