Forum Replies Created

Viewing 15 posts - 436 through 450 (of 5,502 total)

  • RE: Show all data from four tables joined or matched on a particular column

    you might want to look into a FULL JOIN of all four tables.


    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 23, 2013 at 3:36 pm

    #1590619

  • RE: I need to represent the reading taken for every point of a room date wise in picture attached manner through SQL

    Hi,

    please help us help you and provide ready to use sample data and expected result as described in the first article referenced in my signature.


    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 23, 2013 at 5:14 am

    #1590596

  • RE: Need help with a select, insert

    I agree it looks like homework.

    But the funny part is: the expected result is wrong based on the given requirement (at least form my point of view)... :w00t:

    @daglugub: what...


    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 23, 2013 at 3:30 am

    #1590592

  • RE: select to add alternate lines with text as 'go'

    I'd use the cte approach. I'm confident it can be compressed a little further but this would be my starting point:

    WITH cte_originalquery AS

    (

    SELECT 1 AS Number UNION ALL

    SELECT 2 AS...


    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 23, 2013 at 3:23 am

    #1590591

  • RE: create and print html file using SQL Server Agent job

    Thank you for your reply. I'll give it a try even though I don't think it will make a difference for two reasons:

    a) the proxy I'm using is based 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 23, 2013 at 3:10 am

    #1590589

  • RE: PIVOT Operator with Dynamic Columns

    You might want to look into the Dynamic Cross Tab approach as referenced in my signature.

    Might be the less strugglig way to achieve what you're looking for.

    As a side note:...


    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 23, 2013 at 3:05 am

    #1590588

  • RE: Require serial access to table, Stored Procedure, TABLOCKX

    You could use the OUTPUT clause in the INSERT statement and capture the primary key together with the values inserted in a table variable.

    See BOL (BooksOnLine) for an example (keyword...


    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 23, 2013 at 2:49 am

    #1590587

  • RE: How to convert this XML into columns

    I'll bring some hay for the hippo!!


    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 9, 2012 at 2:37 pm

    #1470932

  • RE: How to convert this XML into columns

    Here's the link to the solution I posted.

    The OP's answer?

    Neither "This will work." nor "The logic should be..."

    But instead: "Where should I put this query in my original SQL...


    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 9, 2012 at 1:51 pm

    #1470912

  • RE: How to convert this XML into columns

    You still havent learned that we'd like to know your EXPECTED result. NOT the ACTUAL result which we all know is not what you're looking for.

    PLEASE, PLEASE, PLEASE tell us...


    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 9, 2012 at 1:37 pm

    #1470899

  • RE: How to convert this XML into columns

    You still haven't learned that we don't sit around a glass ball and figure out what "it doesn't work" means in your case.

    I'm also surprised you continue to use 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]

    April 9, 2012 at 8:45 am

    #1470683

  • RE: forimg a sql query using split

    Jeff, I'm feeling today is one of those days where I'm just getting ignored... 😉


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

    #1470420

  • RE: Dates of MMR vaccine

    Ok, here's the only way I can think of: to use the "Quirky update" as described in Jeff Modens article[/url]

    It is absolutely required to read the article and fully understand...


    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 7, 2012 at 9:30 am

    #1470399

  • RE: Tell me the solution Please

    Per definition a CASE function will return the result based on the first match.

    There's very little we can do. The requirement doesn't make much sense to me.

    Please provide table def...


    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 7, 2012 at 3:07 am

    #1470367

  • RE: forimg a sql query using split

    Neither one of your statements "I don't get the result" nor "i get the substring error" do really help us to narrow down the issue. SQL Server is kind enough...


    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 7, 2012 at 2:59 am

    #1470366

Viewing 15 posts - 436 through 450 (of 5,502 total)