Forum Replies Created

Viewing 15 posts - 706 through 720 (of 859 total)

  • RE: Are the posted questions getting worse?

    GSquared (4/3/2012)

    Brandie Tarvin (4/3/2012)

    Revenant (4/2/2012)

    AUI, meaning Administering Under Influence.

    Isn't that illegal?

    I'm sure there's some sort of law against that... Or is the law for it? I can never remember.

    I'm pretty...

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    April 3, 2012 at 9:35 am

    #1468304

  • RE: SQL Bits X...

    Sean Lange (4/3/2012)

    capn.hector (4/2/2012)

    Koen Verbeeck (4/2/2012)

    EL Jerry (4/2/2012)

    Sean,

    I'm quite sure the community will agree with me that you deserve the Nobel Patience Prize for your participation in that...

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    April 3, 2012 at 9:31 am

    #1468298

  • RE: I have SQL Server and Backup Server in different domain.

    the only way to resolve the issue is to some how authenticate between domain1 and domain2 whether running a batch file to link the users or linking the domains...

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    April 3, 2012 at 9:28 am

    #1468297

  • RE: Help with creating a trigger

    SQL_Enthusiast-AZ (4/3/2012)

    Thank you capn.hector and anthony.green,

    I didn't think it would be so easy. I thought there would be some kind of logic that would much more complicated... Sorry, I...

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    April 3, 2012 at 9:24 am

    #1468293

  • RE: Constraint or Trigger

    anthony.green (4/3/2012)

    do a foriegn key to the same table and pass in the right manager employee id for the employee, standard parent child relationship

    of course if the employee id changes...

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    April 3, 2012 at 8:49 am

    #1468265

  • RE: Schedule restore

    SQLKnowItAll (4/3/2012)

    Anders Pedersen (4/3/2012)

    Or don't use the maintenance plans to backup SQL and only save the date in the file name. That way don't need linked servers as long as...

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    April 3, 2012 at 8:40 am

    #1468255

  • RE: Help with creating a trigger

    shoud get you close.

    CREATE TRIGGER TriggerName

    ON Table.Column

    AFTER UPDATE --can also do AFTER INSERT, UPDATE if you want both

    AS

    INSERT INTO ZZ_CUSTOMER_HOLD_REASON

    SELECT CUSTOMER.HOLD_REASON,CUSTOMER.CUSTOMER_ID,

    ...

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    April 3, 2012 at 8:21 am

    #1468238

  • RE: How to deploy scripts??

    itskanchanhere (4/3/2012)

    In these tools "go" command does not work which is understood. I need to come up with a way in which scripts can be deployed by these team using...

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    April 3, 2012 at 8:09 am

    #1468225

  • RE: How to deploy scripts??

    itskanchanhere (4/3/2012)

    In these tools "go" command does not work which is understood. I need to come up with a way in which scripts can be deployed by these team using...

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    April 3, 2012 at 8:08 am

    #1468223

  • RE: SQL to Access conversion

    for your sample data can you post hard coded inserts. we do not have your underlying tables so SELECT * INTO #BLah FROM BlaBla will not work in...

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    April 3, 2012 at 8:00 am

    #1468220

  • RE: SQL Bits X...

    Koen Verbeeck (4/2/2012)

    EL Jerry (4/2/2012)

    Sean,

    I'm quite sure the community will agree with me that you deserve the Nobel Patience Prize for your participation in that thread. 🙂

    "El" Jerry.

    We're...

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    April 2, 2012 at 6:25 pm

    #1467975

  • RE: Restore Failed

    EDIT: Double post. wow i double clicked and it posted twice.

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    April 2, 2012 at 4:35 pm

    #1467956

  • RE: Restore Failed

    SQLRNNR (4/2/2012)

    If the backup file is corrupt, you will need to find a backup file that is not corrupt or take a new backup.

    corupt backups can not be restored. ...

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    April 2, 2012 at 4:35 pm

    #1467955

  • RE: Database Properties Question

    dcsurfer67 (4/2/2012)

    Hi there,

    I have a backend on SQL 2008 and whne I look at the DB properties, general, the size is 5.25MB and space available is .80MB. What is...

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    April 2, 2012 at 2:55 pm

    #1467914

  • RE: Most Efficient Way to Transfer ERD to SQL server

    flebber.crue (4/2/2012)

    I never thought about keeping the scripts for backup but that is a good point.

    Is there a good editor to write the SQL in?

    i find i like...

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    April 2, 2012 at 2:52 pm

    #1467913

Viewing 15 posts - 706 through 720 (of 859 total)