Forum Replies Created

Viewing 15 posts - 22,111 through 22,125 (of 26,490 total)

  • RE: How generate Dates on the fly

    Great, you like CTE's. Guess what, Bob's solution is also a CTE. What we are trying to get you to understand is that just because your solution works,...

  • RE: Lets help the experts help themselves

    t.walker (3/6/2009)


    I really support that idea. I think a more private invited members forum would enable me to speak more freely/

    Although I am a rookie here, I am also a...

  • RE: Are the posted questions getting worse?

    I can't see an exclusive thread or forum really working here. If that's what it would take for someone to feel comfortable here at SSC, maybe this isn't the...

  • RE: How generate Dates on the fly

    Jeff Moden (3/6/2009)


    Lynn Pettis (3/6/2009)


    Not the request I made. I know which I'd use. I want Mangal to justify to me why I should use his solution even...

  • RE: How generate Dates on the fly

    CTE (3/6/2009)


    You should use Bob's solution, best way create Time dimension and use it.

    One question came, I given 1 solution, which is not that bad, another person gives another solution,...

  • RE: How generate Dates on the fly

    Mangal,

    Justify for me why I should use your recursive CTE in place of Bob's solution. I have tested the two side by side, and I find Bob's solution to...

  • RE: Lets help the experts help themselves

    I have to admit that I am not really a Saint. I just have made a decision that if I am going to try and help someone, I am...

  • RE: Considerations for delete

    Looks like CrazyMan chose this thread to work in, so please direct comments and suggestions there.

  • RE: How generate Dates on the fly

    Mangal9i (3/6/2009)


    Yes my query little slow.

    Talking about execution plan, run both my query and your query and see cost of the query.

    Its 1% VS 99%.

    I was not aware that someone...

  • RE: Are the posted questions getting worse?

    I'd be curious to know if Mangal has bothered to check his original thread. What had turned into a "heated discussion" on a reply he had made to Steve...

  • RE: SQL Server 2005 SP 3

    Eyes, hurt.

    I need to thank everyone who provided suggestions and guidance on this problem. There were some missing files that i needed to find and replace in the Windows/Installer...

  • RE: Are the posted questions getting worse?

    GSquared (3/6/2009)


    Roy Ernest (3/6/2009)


    I was not able to check this thread much yesterday since I had a late night shift the day before. I check today morning and this thread...

  • RE: Distinct going slower than *

    I have been following this thread since it started. It is now 54 posts long and I am getting a little confused and I really don't feel like starting...

  • RE: Lets help the experts help themselves

    t.walker (3/6/2009)


    OK, there are some great points here and perhaps I was being rather uncharitable when I wrote it. It came off the back of trying to research an issue...

  • RE: How to find Week start date and Week end date

    Chris Morris (3/6/2009)


    karthikeyan (3/6/2009)


    Thanks a lot to all.

    I just wanted to know what about my solution? won't it be a god solution? I think 'YES'. Becuase i have used UPPER...

Viewing 15 posts - 22,111 through 22,125 (of 26,490 total)