Forum Replies Created

Viewing 15 posts - 1,591 through 1,605 (of 5,502 total)

  • RE: Neeed Select Statement:Help to show record of student

    You could either use PIVOT or the CrossTab approach.

    For the former, please have a look at BOL, the concept of the latter is referenced in my signature block.

    As a side...


    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 5, 2011 at 1:51 am

    #1320239

  • RE: SQL SERVER QUERY

    Instead of using GOTO I'd recommend you either include those code sections directly into the related IF block. If there's too much code, use separate sprocs and call those.


    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 5, 2011 at 1:47 am

    #1320238

  • RE: Is there any way to run the query more than 8000 character via openquery?

    Do you have a chance to either create a view or a sproc at the db referenced in OPENQUERY that would hold the content of @sqlquery? Then you could just...


    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 5, 2011 at 1:44 am

    #1320237

  • RE: how to prevent a user form editing a record in a table that is referenced in another tabe

    You could either add a foreign key constraint with no cascading actions or change the user permission to deny update of that specific column. The former would be the solution...


    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 5, 2011 at 1:41 am

    #1320236

  • RE: JavaOne & Oracle Develop Conference 2011

    [SET SARCASM ON]

    The products mentioned above must have great community web sites. What else would be the reason to ask for recommendations like the above in a SQL Server forum?

    [SET...


    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 5, 2011 at 1:34 am

    #1320235

  • RE: UPDATE query question

    I don't think your latest reply will return the same result since you'd only number the rows with filed1=0 instead of all related rows.

    Regarding PARTITION BY: it owuldn't make 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 4, 2011 at 5:00 pm

    #1320153

  • RE: Likned Server Error

    Does the sproc return any error when run from SSMS (Management Studio)?

    If so, what tool do you use to "run (and design) the report in intranet"? Assuming it is SSRS...


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

    #1320145

  • RE: UPDATE query question

    I'd like to ask for table def and sample data to verifiy if the query is exactly what you're looking for.

    But there's definitely one thing I'd change: replace the name...


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

    #1320141

  • RE: UPDATE query question

    raistlinx (5/4/2011)

    ...

    Yes that is what I understood the problem to be from the analyst who gave it to me. I knew it had to be a common problem. Is there...


    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 4, 2011 at 3:57 pm

    #1320131

  • RE: UPDATE query question

    Looks like a "classic" triangular join to me.

    It might be a better way to use ROW_NUMBER() instead of the COUNT(*) in a subquery approach.

    Would it be possible to post table...


    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 4, 2011 at 3:22 pm

    #1320117

  • RE: Likned Server Error

    I'm guessing toward the same direction as Stefan:

    Assuming V_KASSTRNS and V_PERSONAL are views, both could have the hardcoded APP06 linked server referenced in the underlying query.

    I'd check the definition of...


    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 4, 2011 at 2:13 pm

    #1320084

  • RE: Stored procedure question

    You might also want to have a look at Gails blog regarding the caveats of catch-all-queries[/url]


    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 4, 2011 at 12:49 pm

    #1320037

  • RE: What or Yes

    Ninja's_RGR'us (5/4/2011)

    What culture is he from?

    I personnally wouldn't be offended... but I'm from around here :-D.

    I'm from around here, too. How come we never met? :-D:-P

    Regarding the subject (but not...


    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 4, 2011 at 12:24 pm

    #1320014

  • RE: I have a table #racetest from where I want to get two lines with max discharge dates with each year

    either

    SELECT TOP 2 ORDER BY dischargedate DESC

    or a CTE using

    ROW_NUMBER() OVER(PARTITION BY id ORDER BY dischargedate DESC) AS row

    and a query using WHERE row<=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]

    May 3, 2011 at 2:10 pm

    #1319383

  • RE: Retrieve the information from XML column

    It shouldn't cause a performance issue since the XML structure is neither complicated nor large in size.

    The best way to know is to test 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]

    May 3, 2011 at 11:07 am

    #1319249

Viewing 15 posts - 1,591 through 1,605 (of 5,502 total)