Forum Replies Created

Viewing 15 posts - 1,216 through 1,230 (of 5,502 total)

  • RE: Are the posted questions getting worse?

    Gianluca Sartori (7/19/2011)

    There's someone you all know that deserves your vote here[/url].

    I'm sure you know who I'm talking about. 😉

    Vote added.

    Thank you Jeff for all the help you 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]

    July 21, 2011 at 11:10 am

    #1356619

  • RE: SQL Query issue with RowNumber - Any help is greatly appreciated!

    Craig Farrell (7/18/2011)

    Without seeing your sample data, I had to make some assumptions. Don't where clause AFTER you initiate the ROW_NUMBER(). That's what's removing the rows on 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]

    July 18, 2011 at 1:55 pm

    #1354477

  • RE: SQL Query issue with RowNumber - Any help is greatly appreciated!

    a few issues:

    a) what do you mean by "not display all the records on the first page, with page count = 10"? Are we talking about a Reporting Services issue...


    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 18, 2011 at 1:53 pm

    #1354476

  • RE: Simple Aggregate Function Question [Novice]

    Any chance to post your solution? "Got it" could be explained a little more 😉


    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 18, 2011 at 12:43 pm

    #1354433

  • RE: divided by zero error

    Glad I could help 😀

    And thank you for the feedback!


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

    #1354355

  • RE: To show data of items not purchased

    Untested...

    SELECT [Cust]

    ,[Item]

    FROM [OASISDEV].[dbo].[TT] TT1

    WHERE NOT EXISTS (SELECT 1 FROM [OASISDEV].[dbo].[TT] TT2 WHERE

    TT1.[Cust]=TT2.[Cust] AND TT2.[Item] = 15 )

    GROUP BY [Cust]

    ORDER BY [Cust]


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

    #1354128

  • RE: how to pass column name to split char function???

    Step 1: search this site for DelimitedSplit8K. You'll find a much better performing function...

    Step 2: Use that function together with CROSS APPLY

    Something like the following code snippet (untested):

    SELECT Graduate.GID, Graduate.GName,...


    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 18, 2011 at 2:57 am

    #1354097

  • RE: Simple Aggregate Function Question [Novice]

    It might be your grouping condition needs to be modified (just guessing, though):

    SELECT DISTINCT (vulnID), COUNT(vulnid) AS COUNT, MONTH(scandate) FROM [external.vuln_instances]

    GROUP BY vulnID, MONTH(scandate)

    ORDER by VULNID

    Other...


    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 17, 2011 at 4:27 pm

    #1354012

  • RE: Order by/ Group by / query help

    Sounds like test or homework. (what other reason would exist that you cannot reformat the question?)

    [Edit] hint: in order to find all orders from today you could use something like...


    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 17, 2011 at 4:18 pm

    #1354010

  • RE: An unhandled exception has occurred in a component in your application

    duplicate post. noe replies please.

    Original post: http://www.sqlservercentral.com/Forums/FindPost1143091.aspx


    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 17, 2011 at 9:53 am

    #1353961

  • RE: Reading XML File into a table

    You could use

    SELECT * FROM OPENROWSET(

    BULK 'c:\SampleFolder\SampleData3.txt',

    SINGLE_BLOB) AS x


    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 17, 2011 at 7:13 am

    #1353948

  • RE: Reading XML File into a table

    What SQL Server version do you use?

    It might be easier to do it using XQuery, assuming you use SQL 2005 and up:

    SELECT

    v.value('medFormID[1]','int') AS ID,

    v.value('FormName[1]','varchar(50)') AS FormName

    FROM @xml.nodes('document') T(c)

    CROSS APPLY...


    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 17, 2011 at 6:43 am

    #1353944

  • RE: Sql data intact, but can't display in application

    bsreddy00 (7/17/2011)

    http://xxxx/2011/07/2000-2005-2008-sql-server-version.html

    And what is your question / comment?


    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 17, 2011 at 5:05 am

    #1353937

  • RE: Are the posted questions getting worse?

    WayneS (7/15/2011)

    Lynn Pettis (7/15/2011)

    Chad Crawford (7/15/2011)

    Craig Farrell (7/14/2011)

    Hey guys, does anyone know of boot camp training session(s) for SQL Server for practical skills (not certifications). I'm talking real...


    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 17, 2011 at 2:40 am

    #1353929

  • RE: How to split a record into two records?

    kish1234 (7/16/2011)

    Hi Lutz,

    Thanks for your reply.

    What happens, if I want to make my select statement dynamic.

    My actual request from client is to get all the incidents that are raised as...


    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 17, 2011 at 2:38 am

    #1353928

Viewing 15 posts - 1,216 through 1,230 (of 5,502 total)