Forum Replies Created

Viewing 15 posts - 1,186 through 1,200 (of 5,502 total)

  • RE: Dynamic Pivot Columns for Changing column starting points

    Ok, here's the static version based on your sample data:

    ; WITH routeorder as

    (

    SELECT

    t.*,

    rs.stpid,

    rs.num,

    -- assign a sequential number to each stop for a specific route

    -- regardless whether...


    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 25, 2011 at 2:27 am

    #1357638

  • RE: Urgent: Handling [& , ' etc] in TSQL

    Sridoc2020 (7/24/2011)

    Do you know how I can force to accept following name in above query which contains comma

    18765_McHaney,Packet,DI,4.2.10_1

    No. Hence my recommendation to rename the files before the import.


    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 24, 2011 at 5:57 pm

    #1357580

  • RE: Dynamic Pivot Columns for Changing column starting points

    It's a little late over here in Europe (almost 2am), so I'll have a look at it tomorrow if there is no reply...


    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 24, 2011 at 5:46 pm

    #1357578

  • RE: Urgent: Handling [& , ' etc] in TSQL

    I thought about renaming or copy the files (with a more useful file name) just for the load process...


    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 24, 2011 at 5:33 pm

    #1357576

  • RE: Urgent: Handling [& , ' etc] in TSQL

    Would it be an option to get the file name list and rename it using xp_cmdshell?


    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 24, 2011 at 5:05 pm

    #1357574

  • RE: Dynamic Pivot Columns for Changing column starting points

    Do you have a table holding all stops per trip in the required sequence? (including the sort order)? Something like route_stop_id (identity column for that table), [route], direction, stopnumber, stopdescription.

    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]

    July 24, 2011 at 3:19 pm

    #1357569

  • RE: Dynamic Pivot Columns for Changing column starting points

    The question I have is: do you have the logic already build up how to deal with two identical stop names?


    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 24, 2011 at 11:12 am

    #1357545

  • RE: dynamic update,insert,delete with sp???

    Solution: dynamic SQL wrapped by a SQL injection prevention algorithm.

    But the picture of the completed puzzle may look ugly...;-)

    I, personally, vote against such a concept: it's hard to maintain and...


    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 24, 2011 at 4:08 am

    #1357521

  • RE: Dynamic Pivot Columns for Changing column starting points

    You could use the DynamicCrossTab aproach as described in the related link in my signature.

    If you're not familiar with the CrossTab concept, the CrossTab reference would be a good start.

    There...


    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 24, 2011 at 3:15 am

    #1357515

  • RE: Insert with id of inserted row

    Please have a look at the examples provided in BooksOnLine, the SQL Server help system.

    If you're struggling with modifying it to meet your requirements please post some ready 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 23, 2011 at 4:13 am

    #1357410

  • RE: SQL: Modify XML values identified through cross apply

    mister.magoo (7/23/2011)

    ...

    Thanks, and yes you can do a conditional replace using

    replace value of (...) with ( if ( condition ) then "value1" else "value2" )

    but my initial tests...


    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 23, 2011 at 4:07 am

    #1357409

  • RE: Caclulate Distance

    This link should help you to get started.


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

    #1357400

  • RE: How to get CustomerCount based on Customer Updated by Users and their UserTypes

    Some ready to use sample data as described in the first link in my signature would make it a lot easier for us to start working on the solution instead...


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

    #1357399

  • RE: Insert with id of inserted row

    Please don't call us "blokes". This is not a chat room for kids but a professional forum.

    Regarding the issue you're struggling with:

    I recommend to call a stored procedure with 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]

    July 23, 2011 at 3:01 am

    #1357397

  • RE: Stored Procedure Statistics

    ESAT ERKEC (7/23/2011)

    I found solution in here you can collect everythink....

    http://msdn.microsoft.com/en-us/library/cc645955.aspx

    thanks for everybody....

    That's the trace approach Gail mentioned in her first reply (option 2). Make sure you're taking care of...


    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 23, 2011 at 2:55 am

    #1357396

Viewing 15 posts - 1,186 through 1,200 (of 5,502 total)