Forum Replies Created

Viewing 15 posts - 8,641 through 8,655 (of 8,731 total)

  • RE: Anything out there better than SSRS

    I'm not sure if there's a conflict of interests by posting the following but...

    If you're looking for a nice tool that can be easy for the execs to work with,...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    August 7, 2012 at 12:41 pm

    #1522782

  • RE: Commenting in Dynamic query

    SQLRNNR (8/7/2012)

    Luis Cazares (8/7/2012)

    SQLRNNR (8/7/2012)

    mtassin (8/7/2012)

    And what happened to Steve's statement of NO MORE IMAGES for queries?

    Steve? Come on...

    Not that it matters for this one... but it did...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    August 7, 2012 at 12:18 pm

    #1522774

  • RE: Commenting in Dynamic query

    SQLRNNR (8/7/2012)

    mtassin (8/7/2012)

    And what happened to Steve's statement of NO MORE IMAGES for queries?

    Steve? Come on...

    Not that it matters for this one... but it did look like a...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    August 7, 2012 at 11:58 am

    #1522758

  • RE: 0 is equal to zero length string. Can someone explain how this can be?

    JasonRowland (8/7/2012)

    Luis Cazares (8/7/2012)

    You might find this article interesting.

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

    So you won't have to wait for Celko to "do some digging". Here are the exact rules for implicit conversion in SQL...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    August 7, 2012 at 10:00 am

    #1522694

  • RE: 0 is equal to zero length string. Can someone explain how this can be?

    You might find this article interesting.

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

    So you won't have to wait for Celko to "do some digging". Here are the exact rules for implicit conversion in SQL Server. It's not...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    August 7, 2012 at 7:52 am

    #1522607

  • RE: Commenting in Dynamic query

    This is a tricky question and even though I knew the answer I got it wrong, but I blame myself for not putting enough attention.

    However, the explanation is wrong and...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    August 7, 2012 at 6:58 am

    #1522550

  • RE: Commenting in Dynamic query

    honza.mf (8/3/2012)

    Unfortunately nobody will have the most interesting combination finished with "where Fld1 =0 --*/".

    I guess you're wrong. This codes executes and returns 0 rows and no error.

    SET @str4 =...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    August 4, 2012 at 3:08 pm

    #1521725

  • RE: Help on query performance

    I guess I figured out how to reduce that over 5 hours query to a 5 minutes query (at least for the first run) and that's a really nice improvement.

    There...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    August 3, 2012 at 11:42 am

    #1521550

  • RE: Reverse Of Number without Using reverse()

    Peter Brinkhaus (8/3/2012)

    sestell1 (8/3/2012)

    Interesting thread.

    Well, in that case, here's another one. Only works on INT's >= 0.

    SELECT

    N,

    LEFT(CAST(N % 10 AS CHAR(1)) +

    ...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    August 3, 2012 at 9:59 am

    #1521496

  • RE: How to retrive data in particular format?

    I'm not sure what are you trying to do.

    Does a model_id can have more than 3 vinno?

    Would this help?

    SELECT DISTINCT

    A.vinno,

    ...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    August 3, 2012 at 8:24 am

    #1521426

  • RE: Reverse Of Number without Using reverse()

    shahsn11 (8/3/2012)

    I really appreciate you for your answer thanks. And the output was the same as i was thinking.

    Since i am a newbie , i am having some problem while...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    August 3, 2012 at 7:46 am

    #1521396

  • RE: newbie sql S.o.S - please help

    Lowell (8/3/2012)

    for me , RBS needs the acronym spelled out, please;

    is that Remote Backup Software? Remote Buying System? Royal Bank of Scotland? Really Bad Service? some software package?

    Role Based...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    August 3, 2012 at 7:42 am

    #1521391

  • RE: Benefits of using Windows 2008 R2 over R1

    Why would you upgrade to SQL 2008 if SQL Server 2012 has been released now?

    I misread, your question. I have some information at home, but I believe that from SQL...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    August 3, 2012 at 7:25 am

    #1521377

  • RE: Help on query performance

    This is shocking for me, I've run both queries several times and using the view is at least twice faster. Am I missing something?

    This is the code I used to...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    August 3, 2012 at 6:53 am

    #1521355

  • RE: Help on query performance

    Thank you Sean, I know it might be a lot of work looking at it in depth (when is not really your job).

    About the NOLOCKs they were there when I...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    August 2, 2012 at 1:10 pm

    #1521107

Viewing 15 posts - 8,641 through 8,655 (of 8,731 total)