Forum Replies Created

Viewing 15 posts - 4,846 through 4,860 (of 5,502 total)

  • RE: Cursorfetch - number of variables declared in the INTO list must match that of selected columns

    steyaert (10/28/2009)

    Have the same error for a different reason, although I haven't found it yet. In my "short" stored procedure, it says the error is at line 340. ...


    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]

    October 28, 2009 at 12:54 pm

    #1071999

  • RE: query to modify

    I just checked this thread again and figured that OP's last login was on 10/14/2009 9:30:22 AM (assuming, he's not using multiple nicknames).

    So he missed all the solutions 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]

    October 24, 2009 at 8:18 am

    #1070374

  • RE: How I can make look like I expert on SQL Server?

    Hi torpkev,

    would you mind removing the last word before your sig in your prev post?

    Kinda crossing the line...

    Btw: I'm not sure if this thread is feeding a troll (I'm not...


    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]

    October 16, 2009 at 1:50 pm

    #1067169

  • RE: date columns based query

    Edit: duplicate post.


    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]

    October 16, 2009 at 12:57 pm

    #1067132

  • RE: date columns based query

    Please read and follow the recommendation given in the first link in my signature.

    It will help us help 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]

    October 16, 2009 at 12:50 pm

    #1067119

  • RE: Are the posted questions getting worse?

    Roy Ernest (10/15/2009)

    What is going on in THE THREAD? Wasnt there a Code ban on THE THREAD? :hehe:

    [childish] It wasn't me who started it regarding the specific issue.[/childish]

    Want me...


    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]

    October 15, 2009 at 1:12 pm

    #1066462

  • RE: Are the posted questions getting worse?

    Bob Hovious 24601 (10/14/2009)

    That's how I interpreted it, Gail. This was my quick-and-dirty solution.

    Sample code removed to limit the amount of actual code on THE THREAD.

    if you can'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]

    October 15, 2009 at 12:56 pm

    #1066450

  • RE: How to insert using values from query results for one field of statement

    atharmon (10/13/2009)

    I do appreciate result set processing over row level processing, but performance would really depend on number or rows.

    Usually, such statement calls for some sample code to prove...


    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]

    October 14, 2009 at 1:07 pm

    #1065928

  • RE: user defined functions & columns

    Please provide more information on what you're trying to do.

    It's hard for us to translate

    "......

    .....

    "

    into something that "manipulates all columns in the table"

    We don't even know what table you're...


    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]

    October 14, 2009 at 12:20 pm

    #1065902

  • RE: query to modify

    steveb. (10/14/2009)

    Well i guess it wasn't really urgent after all..

    Or the UNPIVOT hint pointed him in the right direction (at least one of the directions leading to the expected...


    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]

    October 14, 2009 at 12:06 pm

    #1065895

  • RE: How to insert using values from query results for one field of statement

    cjohn5552 (10/13/2009)

    Hey,

    Thanks for your reply. The query is of the form:

    select personID from people

    where height = 'X'

    and weight =...


    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]

    October 13, 2009 at 4:47 pm

    #1065442

  • RE: Missed the end of the month

    krypto69 (10/13/2009)

    is this wrong?

    original way:

    WHERE

    isnull(datediff(dd,ld.delq_dt,getdate()),0) < 30

    this:

    WHERE

    isnull(datediff(dd,ld.delq_dt,'2009-09-30'),0) < 30

    Now I'm totally confused...

    During the last couple hours I've been trying to explain how to get the data from the previous...


    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]

    October 13, 2009 at 4:31 pm

    #1065439

  • RE: Missed the end of the month

    I don't get any results either.

    But this might be caused by the fact that I don't ave anything to test against. 😉

    Please follow the first link in my signature...


    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]

    October 13, 2009 at 1:25 pm

    #1065358

  • RE: T-sql to XML( can any one help me out plz ...:( )

    sam-1083699 (10/12/2009)

    ...

    My role is to query the data according to the client requirement and convert the data in to xml file and save the xml file in some folder......


    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]

    October 13, 2009 at 1:20 pm

    #1065355

  • RE: query to modify

    Bob Hovious 24601 (10/13/2009)

    I've got a solution for you, but first I'd like to know why this is urgent.

    Now the OP know's that there are (at least) two people 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]

    October 13, 2009 at 1:00 pm

    #1065345

Viewing 15 posts - 4,846 through 4,860 (of 5,502 total)