Forum Replies Created

Viewing 15 posts - 1,816 through 1,830 (of 5,502 total)

  • RE: Table Scan

    Can you post the actual execution plan together will both table definition including any index definition if they exist? (I'd expect no index on the tables since you mention 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]

    March 3, 2011 at 3:18 pm

    #1294373

  • RE: Create stored procedure help

    I would either use a varchar(8000) variable and a comma delimited list (or any delimiter that will never ever be part of the parameter) and split it in the sproc...


    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]

    March 3, 2011 at 3:12 pm

    #1294371

  • RE: How to ping a SQL Server datbase?

    Lowell (3/3/2011)

    LutzM (3/3/2011)

    Duplicate post. No replies please.

    Original post can be found 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]

    March 3, 2011 at 3:09 pm

    #1294369

  • RE: Shredding XML - Need to Include OfferId

    pamozer (3/3/2011)

    Thank you. I actually like the version not using cross apply.

    ... until you test both versions against a larger XML file...

    Your preference may change 😉


    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]

    March 3, 2011 at 2:42 pm

    #1294354

  • RE: How to ping a SQL Server datbase?

    Duplicate post. No replies please.

    Original post can be found 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]

    March 3, 2011 at 2:40 pm

    #1294352

  • RE: Are the posted questions getting worse?

    CirquedeSQLeil (3/3/2011)

    ...

    I'm confused now. HIPAA = HIPPO != Rhino 😎

    Hoola-HIPAA-Hippo as requested 🙂


    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]

    March 3, 2011 at 2:37 pm

    #1294349

  • RE: Combine two fields together

    Use your original 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]

    March 3, 2011 at 12:43 pm

    #1294263

  • RE: custom sql server

    You could use a cte with ROW_NUMBER() OVER (PARTITION BY Case_Id ORDER BY DateTime DESC) and then query for row=1.


    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]

    March 3, 2011 at 11:45 am

    #1294197

  • RE: Help With Query

    phood (3/3/2011)

    Based on your forum etiquette I did a hack job on this post so I deleted what was in here and will post again in a bit when I...


    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]

    March 3, 2011 at 11:34 am

    #1294189

  • RE: Combine two fields together

    Since I don't know where the blank is coming from (presumably because Field1 is defined as CHAR(5), but it's also possible that the value of field2 starts with a blank)...


    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]

    March 3, 2011 at 10:50 am

    #1294167

  • RE: Question with running .sql file

    You could modify your current script to return the query or any other information before the actual statement.

    Something like

    SELECT 'query: SELECT * FROM sys.columns'

    SELECT * FROM sys.columns


    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]

    March 3, 2011 at 10:46 am

    #1294161

  • RE: Combine two fields together

    would you please provide the sample data you'd like to concatenate?

    Something like

    SELECT 'abc','def'

    Also, please include your current approach.


    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]

    March 3, 2011 at 10:38 am

    #1294155

  • RE: Help With Query

    Please provide table definition and ready to use sample data as described in the first link in my signature. Also, please provide your expected result based on those samples together...


    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]

    March 3, 2011 at 10:13 am

    #1294135

  • RE: Error CASE in GROUP BY

    The issue is the

    CONVERT(VARCHAR,DATEADD(DAY,2, @fec),112),

    part of your GROUP BY statement.

    Since there is no column reference, it'll throw the error you see.

    You should get the expected result set result by either...


    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]

    March 2, 2011 at 12:05 pm

    #1293677

  • RE: Are the posted questions getting worse?

    Craig Farrell (3/2/2011)

    ...

    By Jove! You've forgotten about taking care of your SOX while you're at it! In dealing with a rainforest, you'll catch some nasty things...


    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]

    March 2, 2011 at 11:19 am

    #1293647

Viewing 15 posts - 1,816 through 1,830 (of 5,502 total)