Forum Replies Created

Viewing 15 posts - 5,326 through 5,340 (of 5,502 total)

  • RE: Are the posted questions getting worse?

    GilaMonster (6/6/2009)

    From what I understand, the current rule is that documented features have to go through a 1 or 2 stage deprecation cycle (sysobjects, deprecated in 2k5, final deprecation 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]

    June 6, 2009 at 11:41 am

    #1005744

  • RE: How to query data on weekly basis

    Did you look into BooksOnline (aka BOL), the SQL Server Help that usually is installed together with SQL Server? You can open it by using {F1} from the Management Studio.

    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]

    June 6, 2009 at 11:26 am

    #1005743

  • RE: Need to export column headings with stored procedure

    Hi,

    referring my previous post I would have done it as follows (example from AdventureWorks, thought it would clarify a little more what I was thinking about than just throwing those...


    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]

    June 6, 2009 at 9:54 am

    #1005738

  • RE: Are the posted questions getting worse?

    WayneS (6/6/2009)

    You know, it's always those complex T-SQL concepts that trip up so many people.

    Good going Gail!

    Hi Wayne,

    your link doesn't work (double referenced).


    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]

    June 6, 2009 at 7:06 am

    #1005689

  • RE: Need to export column headings with stored procedure

    Edit: problems during post submission.


    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]

    June 6, 2009 at 2:30 am

    #1005657

  • RE: Need to export column headings with stored procedure

    Edit: problems during post submission.


    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]

    June 6, 2009 at 2:13 am

    #1005654

  • RE: Need to export column headings with stored procedure

    Another option would be to add the column names using the UNION ALL function within the SELECT statement of the BCP command.

    Something like

    SELECT 'Col1','Col2','Col3' UNION ALL

    SELECT CAST(Col1 AS VARCHAR(10)),...


    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]

    June 6, 2009 at 2:11 am

    #1005653

  • RE: How to query data on weekly basis

    You might want to look up DATEPART function in BOL.

    Then you can use it to do a SUM() GROUP BY DATEPART().

    If you need a more detailed answer you should provide...


    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]

    June 6, 2009 at 1:39 am

    #1005649

  • RE: Whats faster, flat files or SQL table

    If I understand you correctly you're asking what's faster:

    You have an asp.net application and you're asking for the faster of the following two options (using .net coding):

    1) find a specific...


    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]

    June 6, 2009 at 1:31 am

    #1005648

  • RE: Remove time part from datetime column

    Sergiy (6/5/2009)

    You know why programmers (old school, those who studied computing, not just .net) mix Helloween with Christmas?

    Because 31OCT = 25DEC.

    LOL :hehe:

    Haven't seen that one for a long long time!

    Do...


    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]

    June 6, 2009 at 1:12 am

    #1005647

  • RE: Concatenate values from multiple records into single field

    SELECT

    ArticleID,

    STUFF((SELECT ' ' + Title + ' ' +Text FROM TABLE t2 WHERE t2.ArticleID = t1.ArticleID FOR XML PATH('')),1,1,'')

    FROM

    TABLE t1

    GROUP BY

    ArticleID


    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]

    June 5, 2009 at 5:11 pm

    #1005588

  • RE: Convert XML to relational form using attribute values

    TT (6/5/2009)

    SELECT

    Row_Id,

    C.value('./@_VALUE' , 'NVARCHAR(30)'),

    C.value('./@_KEY','NVARCHAR(30)')

    FROM @Temp Cross APPLY TempXml.nodes('DATA/FIELD') T(C)

    Just change your FROM clause to

    FROM (SELECT TOP 10 * FROM @Temp ORDER BY Row_Id) as sub Cross APPLY TempXml.nodes('DATA/FIELD')...


    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]

    June 5, 2009 at 4:56 pm

    #1005586

  • RE: insert into

    Hi FlamedLove05,

    please provide a little more information so we can see what you see...

    1) The row you provided is incomplete. Please provide completed SQL statement.

    2) We don't know the structure...


    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]

    June 5, 2009 at 4:26 pm

    #1005578

  • RE: Concatenate values from multiple records into single field

    Hi,

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

    I don't know how your expected result "20090605 Section header+Paragraph+Paragraph+section+Paragraph+Paragraph..." would correlate in any way with your...


    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]

    June 5, 2009 at 4:16 pm

    #1005576

  • RE: Convert XML to relational form using attribute values

    The reason why I used a "real" temp table is that you cannot use a table variable within a dynamic SQL unless you declare it inside the SQL statement.

    Reason:...


    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]

    June 5, 2009 at 4:11 pm

    #1005574

Viewing 15 posts - 5,326 through 5,340 (of 5,502 total)