Forum Replies Created

Viewing 15 posts - 4,351 through 4,365 (of 5,502 total)

  • RE: Really complicated select statement

    I'm not sure if I'm heading in the right direction...

    If you want to see all order numbers with different values then you could use something like the following (untested, since...


    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 3, 2010 at 5:23 pm

    #1113354

  • RE: is there a way to limit the amount of rows a user can query?

    You could create a role for that user (and any other user you'd like to add).

    Create views or stored procedures or functions for those user and lock down all tables.

    Within...


    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 3, 2010 at 4:03 pm

    #1113316

  • RE: hourly average

    BaldingLoopMan (2/3/2010)

    trying to wrap my mind around what u guys did.

    ...

    You might want to have a look at Lynns blog to find some helpful date routines.


    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 3, 2010 at 3:52 pm

    #1113314

  • RE: Stored Procedure Help..

    Yes, I'd wrap it into a procedure with proper transaction and error handling (TRY ... CATCH).

    But the major question remains and needs to be considered: How can it be guaranteed...


    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 3, 2010 at 3:42 pm

    #1113305

  • RE: Are the posted questions getting worse?

    Lynn Pettis (2/3/2010)

    Congrats Jack!! :w00t:

    I feel slighted, only 1 person even acknowledge when I hit 10,000. 🙁

    Rumor says there are advantages and disadvantages to climb up to the gods... 😉

    Don't...


    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 3, 2010 at 3:20 pm

    #1113272

  • RE: Are the posted questions getting worse?

    lmu92 (2/3/2010)

    I guess the reason why Steve voted for Golf clap is that Jack didn't get to the "SQL Olympian gods" yet. So he can go from Golf clap...


    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 3, 2010 at 3:18 pm

    #1113268

  • RE: Are the posted questions getting worse?

    CirquedeSQLeil (2/3/2010)

    ...

    No. Golf clap. Expression used for how one claps semi-quietly on the golf course. I believe there is a line from CaddyShack about it.

    I guess the...


    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 3, 2010 at 3:11 pm

    #1113259

  • RE: Stored Procedure Help..

    A few things up front:

    #1: You did a good job the way you provided table defs and sample data!! 🙂 Made it easy to work on. And I'm sure you...


    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 3, 2010 at 3:03 pm

    #1113249

  • RE: Are the posted questions getting worse?

    Totally Off-topic:

    Did you notice? Jack is "SSCrazy Eights" now.

    Congrats from across the ocean!


    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 3, 2010 at 2:25 pm

    #1113209

  • RE: Stored Procedure Help..

    I'm not sure why the values of your column [parentId] are identical to the values of the ID column... Looks redundant, which is obviously not the purpose.

    Please provide more details...


    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 3, 2010 at 2:02 pm

    #1113182

  • RE: SQL Script

    Sounds like an issue that fits into the "running total" category.

    You might want to have a look at this link[/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]

    February 3, 2010 at 1:28 pm

    #1113168

  • RE: CTE in select Statement

    Something like

    With CTE as

    (

    Select a2.* from a1

    inner join a2

    on a1.col=a2.col

    ),

    CTE2 as

    (

    Select a4.* from a3

    inner join a4

    on a3.col=a4.col),

    CTE3 as

    (

    Select a5.* from CTE1

    inner join a5

    on CTE1.col=a5.col

    )

    Select cte3.* from cte

    inner join...


    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 2, 2010 at 4:31 pm

    #1112569

  • RE: Datetime format

    Could you possibly post some of the date values as stored in the table?

    Maybe you're struggling with issues related to the way the values are stored:

    Example:

    If data would be stored...


    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 2, 2010 at 2:36 pm

    #1112537

  • RE: converting datetime column to the text field

    My knowledge regarding SSIS is limited but I'd guess the mapping would still try to convert it to a date format...

    I'm not sure if a stored SSIS package would recognize...


    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 2, 2010 at 2:11 pm

    #1112529

  • RE: End-user Query Builder Tool?

    GSquared (2/2/2010)

    MS Access is excellent for that. Link it to the SQL server, query building can be all drag-and-drop and clicking, without writing a line of code. ...

    I thought...


    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 2, 2010 at 2:07 pm

    #1112527

Viewing 15 posts - 4,351 through 4,365 (of 5,502 total)