Forum Replies Created

Viewing 15 posts - 5,431 through 5,445 (of 5,502 total)

  • RE: insert same colums in couple of tables

    Hi Vasco,

    I disagree with Vijaya's statement:.

    Vijaya Kadiyala (4/14/2009)

    Hi

    You need to manually write No.Of Alter statements based on No.Of Tables.

    There is no Magic;-)

    Reason:

    Assuming the tables to be modified are as provided...


    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 14, 2009 at 12:41 pm

    #977540

  • RE: insert same colums in couple of tables

    Hi,

    would you please be a little more specific on what you're trying to do?

    Do you want to add values to the same (existing) columns or do you want to alter...


    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 14, 2009 at 6:07 am

    #977147

  • RE: Are the posted questions getting worse?

    Steve Jones - Editor (4/13/2009)

    OK, I'm lost again. I'll pick up the Flo story when someone posts a link.

    Here's the link:

    http://www.sqlservercentral.com/Forums/FindPost695508.aspx

    Edit: link added to 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]

    April 13, 2009 at 10:00 am

    #976705

  • RE: Are the posted questions getting worse?

    Alvin Ramard (4/13/2009)

    Bob Hovious (4/13/2009)

    It's not a big deal, Steve. Folks have been referring to Flo as "she/her". I swapped a few cordial posts...


    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 13, 2009 at 9:40 am

    #976694

  • RE: Searching (_) underscore in a Column

    Hi,

    As per BOL (search "wildcard characters [SQL Server]"):

    C. Using the ESCAPE clause

    The following example uses the ESCAPE clause and the escape character to find the exact character string 10-15% in...


    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, 2009 at 12:58 pm

    #975359

  • RE: Loading XML into a relational table

    Hello Hans,

    If I'm getting you right you're asking for a tool that will take the nodes and create tables based on that and fill those tables with the columns with...


    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, 2009 at 9:09 am

    #975142

  • RE: How to change the data from ROW to COLUMN

    Hi,

    if the columns you want to change your rows to are always the same and you're I'd recommend to use the PIVOT function.

    If you need dynamic columns you should...


    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 8, 2009 at 11:57 am

    #974561

  • RE: Reference to an undefined name 'X"

    Hi,

    I'm not sure whether you figured it out already or not...

    the reason for failure is that your declaration is missing a local namespace definition.

    If you add

    ...


    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 6, 2009 at 2:55 pm

    #972920

  • RE: Select column in a specific order based on values.

    Hi Matthias,

    I'm sorry for not responding earlier but I just returned from a weekend trip.

    The only modification I can see with SS2K5 is the replacement of the temp table...


    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 5, 2009 at 1:36 pm

    #972217

  • RE: Select column in a specific order based on values.

    Sergiy (4/2/2009)

    I guess what OP really needs is a comma (or other delimiter) separated list of values for some report.

    If that's the case, isn't it exactly what the code 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]

    April 3, 2009 at 12:15 am

    #971317

  • RE: Select column in a specific order based on values.

    @Barry:

    Since your table #r is similar to table #t2 in my previous post I'm wondering if there is an even easier solution than mine to get the output the OP...


    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 2, 2009 at 5:02 pm

    #971197

  • RE: Select column in a specific order based on values.

    Maybe this solution is a little easier to expand to 10 columns...

    What needs to be done is to add one SELECT statement to #t1 and two more CASE per addtl....


    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 2, 2009 at 3:17 pm

    #971134

  • RE: Limiting applications - discussion

    Did you look into application roles?

    Brian Kelley's article below pretty much describes your scenario. Maybe it's an option, even with all the con's...

    http://www.sqlservercentral.com/articles/Security/sqlserversecurityprosandconsofapplicationroles/1116/


    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 1, 2009 at 3:34 pm

    #970278

  • RE: Looping a stored procedure

    The reason why your proc just processes one line is because you requested to do so:

    CREATE procedure TP__CreateProgressNotes

    (

    @staffkey int

    ,@Userid int)

    ...

    select ... where staffkey=@staffkey

    If you want to insert all lines...


    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 1, 2009 at 3:15 pm

    #970259

  • RE: Group By or maybe not?

    Hi,

    attached please find a query that's running ok on SS2K5

    What I've done is simply join all your queries to the master table [Konta] via LEFT OUTER JOIN

    and run those queries...


    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 31, 2009 at 9:56 am

    #969239

Viewing 15 posts - 5,431 through 5,445 (of 5,502 total)