Forum Replies Created

Viewing 15 posts - 1,921 through 1,935 (of 5,502 total)

  • RE: Selecting largest column value in a row (normalizing dimensions)

    Matt_V (2/14/2011)

    Hmmm, interesting idea. I haven't used computed persistant columns much so I'll have to look into that more, however it would my my queries much simplier again.

    Quick question,...


    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]

    February 14, 2011 at 1:02 pm

    #1286704

  • RE: Selecting largest column value in a row (normalizing dimensions)

    Would it be an option to add those three calculations as computed persisted columns?

    It came to my mind when you stated the inbound is infrequent...


    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]

    February 14, 2011 at 12:38 pm

    #1286687

  • RE: How to group by where we have char data type

    Just search thissite for "string concatenate for xml path".


    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]

    February 14, 2011 at 12:28 pm

    #1286678

  • RE: Detected but now Prevent This Deadlock

    rameshbhumi (2/14/2011)

    Hi,

    We are also seeing these Queries getting triggered from BO Server to Database. I would like to know what exactly the purpose of these Queries. It will be Great...


    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]

    February 14, 2011 at 11:25 am

    #1286636

  • RE: how do u know..

    EmilyCenters (2/13/2011)

    thanks

    Spam. Reported.


    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]

    February 13, 2011 at 12:24 pm

    #1286182

  • RE: delete query

    duplicate post. No replies please.

    Discussion already started here.

    @praveen: I asked you before not to yell at us. All it does is limiting the replies you might get.


    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]

    February 13, 2011 at 5:53 am

    #1286136

  • RE: delete help using output.deleted option

    duplicate post. No replies please.

    Discussion already started here.

    @praveen: I asked you before not to yell at us. All it does is limiting the replies you might get.


    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]

    February 13, 2011 at 5:53 am

    #1286135

  • RE: delete help using output.deleted option in sql

    praveensc2003 (2/13/2011)

    Hey i just checked with this query given by you

    still i am getting error message. Could you please help me to resolve this issue

    Msg 547, Level 16, State...


    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]

    February 13, 2011 at 5:46 am

    #1286133

  • RE: delete help using output.deleted option in sql

    Except for the double usage of some parts of the statement it shoult work...

    DECLARE @DeleteOutput3 TABLE (CONID INT PRIMARY KEY CLUSTERED)

    DELETE Contact

    OUTPUT

    deleted.CONTACTID

    INTO @DeleteOutput3

    WHERE CONTACTID = 10;

    DELETE FROM SalesHeader INNER JOIN

    @DeleteOutput3...


    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]

    February 13, 2011 at 4:09 am

    #1286128

  • RE: Trouble when count by week in SQL

    Please read and follow the advice given in the first link in my signature on how to provide sufficient information. This will include table def, 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]

    February 13, 2011 at 4:02 am

    #1286127

  • RE: Very Complicate Query....

    rajesh-303966 (2/12/2011)

    Lutz,

    Is it possible to make the pos=1 and RtnSetid1 dynamic as

    By declaring variable value upto 6 for ex. x <= 6 posx and RtnSetidx likethat....

    Kindly help me 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]

    February 13, 2011 at 3:39 am

    #1286126

  • RE: Very Complicate Query....

    Ninja's_RGR'us (2/12/2011)

    ...

    That's precisely why Mr Magoo was asking the question. That's something that should be handled at the presentation layer. Not by t-sql.

    While it CAN be done....


    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]

    February 13, 2011 at 3:24 am

    #1286124

  • RE: OPENXML issue

    There are two issues:

    #1: in line 1 you have [Customer Customer ID="1" ] There seems to be an additional blank after the second "Customer". It should either be Customer_ID or...


    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]

    February 12, 2011 at 4:36 pm

    #1286082

  • RE: Very Complicate Query....

    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]

    February 12, 2011 at 4:09 pm

    #1286079

  • RE: Very Complicate Query....

    That sounds like a job forCrossTab together with Row_Number to get it sorted as requested.

    If you can't predict the max. number of column groups (e.g. the 5 you posted) you...


    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]

    February 12, 2011 at 9:42 am

    #1286029

Viewing 15 posts - 1,921 through 1,935 (of 5,502 total)