Forum Replies Created

Viewing 15 posts - 1,156 through 1,170 (of 5,502 total)

  • RE: General Question

    What is wrong with the tasks you're assigned to?

    Sounds like you don't want to "get your hands dirty"... 😉

    It all depends on the organization you're working for. At some places...


    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]

    August 2, 2011 at 12:28 pm

    #1362483

  • RE: BCP command to import values for selected columns

    link is fixed (and verified). Sorry.


    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]

    August 2, 2011 at 12:13 pm

    #1362460

  • RE: Problem Query

    To add what the others already stated: whatever answer you'll get from the folks around: most of it is guessing (usually based on best practice/experience).

    The concept Chris and ColdCoffee suggested...


    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]

    August 2, 2011 at 12:09 pm

    #1362451

  • RE: BCP command to import values for selected columns

    please have a look at this link.

    The link contains information on how to use a format file with bcp.


    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]

    August 2, 2011 at 11:49 am

    #1362416

  • RE: error in SSAS cube

    duplicate post. no replies please.

    Originjal post: http://www.sqlservercentral.com/Forums/FindPost1152391.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]

    August 2, 2011 at 5:10 am

    #1362038

  • RE: error in SSAS cube

    duplicate post. no replies please.

    Originjal post: http://www.sqlservercentral.com/Forums/FindPost1152391.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]

    August 2, 2011 at 5:10 am

    #1362037

  • RE: XML Stored proc argument

    How do you define "empty"?

    XML variable

    a) is NULL

    b) is an empty string

    c) contains nodes without elements

    d) contains nodes with :nil values


    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]

    August 2, 2011 at 2:05 am

    #1361978

  • RE: sql help with @parameterization

    What do you mean by "set a prompt for a start date and a end date"?

    What programming language do you use for your app development?

    How do you plan to use...


    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]

    August 1, 2011 at 5:17 pm

    #1361900

  • RE: Count records that where active each month

    I would use a calendar table for this kind of query.


    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]

    August 1, 2011 at 5:12 pm

    #1361897

  • RE: Function not working properly - help needed

    Both functions are syntactically correct and both return results.

    Whether the results are what you're looking for is unknown to us.

    I recommend you explain a little more detailed what you're trying...


    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]

    August 1, 2011 at 11:01 am

    #1361704

  • RE: MS Access as a front end to SQL Server?

    The "simplest way" depends on what the requirements are and what you're familiar with.

    An ACCESS solution for example might not be a good choice for a web interface.

    A .NET programmer...


    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]

    July 31, 2011 at 2:51 am

    #1361298

  • RE: dynamic data types

    Straight from BOL (BooksOnLine, the SQL Server help system):

    Use varchar(max) when the sizes of the column data entries vary considerably, and the size might exceed 8,000 bytes.

    The same applies for...


    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]

    July 31, 2011 at 2:46 am

    #1361297

  • RE: sql for xml path

    Here's one possible solution. In order to generate multiple nodfes with the same node name it is required to unpivot the original table first. Then two subqueries are used 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]

    July 30, 2011 at 7:19 am

    #1361218

  • RE: Multiple languages in same column - how to sort, select

    Did you consider using one column per language with the proper collation at the column level?

    Or a concept similar to sys.messages, where a language_id is stored to identify the related...


    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]

    July 30, 2011 at 6:40 am

    #1361211

  • RE: Query: How to summarize data by date nexus points

    R. Scott Mobley (7/29/2011)

    ...

    That said, I still am not clear on how it actually works (don't you just love magic code), but was able to easily modify it to use...


    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]

    July 30, 2011 at 6:31 am

    #1361210

Viewing 15 posts - 1,156 through 1,170 (of 5,502 total)