Forum Replies Created

Viewing 15 posts - 196 through 210 (of 5,502 total)

  • RE: How to View OR Retrieve all the tabs in SQL.

    Lynn, I'd like to disagree regarding "no reopening a previous tab".

    There are tools out there (e.g. RedGate's SQL Prompt -> advert intented 😉 ) that'll allow you to save, search,...


    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, 2014 at 11:27 am

    #1710532

  • RE: SSRS 2012 Report rendering time in pdf format in RDLC

    duplicate post. no replies please.

    Use the original post instead.


    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, 2014 at 9:25 am

    #1710524

  • RE: Is there a fast way for SQL to do a Group By Count on items within a group?

    But this query doesn't return the result set as requested since there's a TOP 15 involved for each group...


    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, 2014 at 5:45 am

    #1710519

  • RE: Is there a fast way for SQL to do a Group By Count on items within a group?

    I agree, Kevin.

    But if the OP really want to "force" the data to stay in memory, one way could be a dll that would query the aggregated data and keep...


    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, 2014 at 3:41 am

    #1710501

  • RE: is it possible to save data in excel by user id

    See Phil Factor's article[/url] for detailed examples of different ways to export to Excel.


    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 2, 2014 at 8:46 am

    #1710370

  • RE: is it possible to save data in excel by user id

    Do you need to physically save the file or just to mail it?

    If the latter, have a look at sp_send_dbmail.

    You'll need to loop through the userID's and send the mail...


    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 2, 2014 at 8:17 am

    #1710356

  • RE: Is there a fast way for SQL to do a Group By Count on items within a group?

    isuckatsql (5/2/2014)

    Kevin,

    You are correct!

    I am not sure on the best way to do this.

    Based on the Microsoft Outlook scenario, i assume you would need one SP for each...


    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 2, 2014 at 5:09 am

    #1710303

  • RE: is it possible to save data in excel by user id

    This is more than a vague question...

    What do you mean "save by userId"? Just the sort order within a Excel worksheet? An additional line between each userId to separate 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 2, 2014 at 5:01 am

    #1710300

  • RE: Importing improperly formatted excel file

    One-timer: Adda filter to the EXCEL section, filter out empty rows (for every 2nd column) and copy the relevant cells (CTRL +C, CTRL +V).

    Permanent Process: Copy the table to 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 1, 2014 at 11:26 am

    #1710174

  • RE: Reset sp_prepexec

    There is no "initial" value. See this link for a syntax description.

    The handle is a system generated int value to uniquely identify the statement. The handle is not

    You can...


    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 1, 2014 at 5:23 am

    #1710065

  • RE: SSMA to migrate data from oracle to sqlserver

    Cross post.

    Discussion already started here.


    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 1, 2014 at 5:03 am

    #1710064

  • RE: time-out in a Job using link server

    Please check the settings for

    linked server properties -> security options -> query timeout

    and

    SQL Server instance -> connections->remote server connections -> remote query timeout

    and compare it to the query processing...


    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 1, 2014 at 4:24 am

    #1710059

  • RE: date format while inserting irrespective of regional settings

    It doesn't depend on the SQL Server setting but on the setting of the date format setting at the point the INSERT statement.

    It is influenced by the following settings:

    SET DATEFORMAT

    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 1, 2014 at 4:12 am

    #1710058

  • RE: how to setup SQL instance

    On what SQL Server instance did you install the Adventure Works database?

    How can we provide a step by step solution if you don't provide us any information except "I cannot...


    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]

    April 27, 2014 at 11:27 am

    #1709042

  • RE: Replace code in SP

    Since you obviously simply don't like the alias v_userpro I provided a solution that doesn't use it at all.

    Please note that it is absolutely equivalent to what I posted before...


    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]

    April 27, 2014 at 6:20 am

    #1709031

Viewing 15 posts - 196 through 210 (of 5,502 total)