Forum Replies Created

Viewing 15 posts - 8,686 through 8,700 (of 8,731 total)

  • RE: Can anyone let me know best way to do this backup and restore task?

    A.J. Wilbur (7/24/2012)

    nagkarjun1 (7/24/2012)

    Can anyone provide me the script with copyonly option with out affecting the other process on db

    This is a forum for help, not for people to do...

    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

    July 24, 2012 at 2:05 pm

    #1517066

  • RE: "Value is not a boolean" error for filter based on a boolean ... what value should I use for True?

    Remember that bit is not boolean, so you have to compare it to 1.

    e.g. bit_field = 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

    July 24, 2012 at 1:40 pm

    #1517052

  • RE: Literal Dates

    craig 81366 (7/23/2012)

    This is why I always write date literals in the form 'yyyymmdd' without separators.

    Getting others to realise the importance of doing so is another story.

    +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

    July 23, 2012 at 6:57 am

    #1516201

  • RE: Table Design Question

    SQLKnowItAll (7/19/2012)

    ... Don't summarize or group your sales in tables...

    You're probably right and probably not.

    As I understand, he's trying to summarize data from an already existing sales table. If...

    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

    July 19, 2012 at 2:49 pm

    #1515186

  • RE: Is This Case Statement Possible

    The easiest way is:

    IF @Condition = 'Something'

    SELECT *

    FROM MyTable

    WHERE myfield = @Variable

    ELSE

    SELECT *

    ...

    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

    July 19, 2012 at 12:37 pm

    #1515105

  • RE: Snapshots

    tbailey 19088 (7/19/2012)

    The given answer is absolutely incorrect. http://msdn.microsoft.com/en-us/library/ms189281.aspx states explicitly how to revert to a selected snapshot if multiple snapshots exist.

    1. Select the snapshot you wish to restore.

    2. Drop...

    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

    July 19, 2012 at 11:51 am

    #1515067

  • RE: Snapshots

    coldfusion244 (7/19/2012)

    Luis Cazares (7/19/2012)

    Why is everyone so upset about the answer? It's clear that the question is if you can restore the database without deleting the other snapshots. Otherwise you...

    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

    July 19, 2012 at 9:10 am

    #1514918

  • RE: sql query

    Swetha527 (7/19/2012)

    I think you are unable to provide the dynamic script for the scenario i have given.

    Thank you.

    Is this a reponse from a six year old?

    After reading Lynn contributions on...

    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

    July 19, 2012 at 8:50 am

    #1514900

  • RE: Problemas en la ejecucion de DTS en SQL Server 2000

    Ivan,

    Si batallas con el inglés te puedo ayudar a traducir, aunque no puedo ayudarte con ese error.

    Everyone else,

    I can help with translation, but I'm not sure what's the error.

    Translation for...

    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

    July 19, 2012 at 8:35 am

    #1514878

  • RE: Snapshots

    Why is everyone so upset about the answer? It's clear that the question is if you can restore the database without deleting the other snapshots. Otherwise you wouldn't have multiple...

    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

    July 19, 2012 at 8:32 am

    #1514877

  • RE: SQL Jokes & Riddles!!!

    capn.hector (7/17/2012)

    Luis Cazares (7/16/2012)

    Is this the right place to demonstrate how good is greater than evil, just by using SQL?

    i would like to see that

    There are plenty of ways, the...

    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

    July 18, 2012 at 6:38 am

    #1514171

  • RE: Is This Case Statement Possible

    You could solve this with Dynamic code or by writing different queries trough a condition (IF...ELSE...).

    I'm not sure if that is what you need.

    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

    July 17, 2012 at 2:07 pm

    #1513872

  • RE: Aggregate

    You must do the sum before you cast your values.

    SELECT id,

    nm,

    CAST(REPLICATE(' ',16-LEN(SUM(AMT*1000))) + CONVERT(varchar(32),SUM(AMT*1000))...

    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

    July 17, 2012 at 1:46 pm

    #1513852

  • RE: Why does the syntax work for insert and not insert into?

    dwilliscp (7/17/2012)

    Different server than where the stored Proc is running.

    Taken from BOL http://msdn.microsoft.com/en-us/library/ms188029.aspx

    "You cannot create new_table on a remote server..."

    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

    July 17, 2012 at 11:18 am

    #1513738

  • RE: Why does the syntax work for insert and not insert into?

    Have you tried this?

    select top 5 *

    into [this.that].dbo.ztb_test

    from zt_sysjobs

    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

    July 17, 2012 at 9:57 am

    #1513688

Viewing 15 posts - 8,686 through 8,700 (of 8,731 total)