Forum Replies Created

Viewing 15 posts - 5,581 through 5,595 (of 8,731 total)

  • RE: Serial Date conversion

    Based on the value 735510.40461, what are you expecting to get?

    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

    November 4, 2014 at 8:55 am

    #1756562

  • RE: Does the database exist?

    In case anyone wants a link to official documentation in BOL.

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

    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

    November 4, 2014 at 8:24 am

    #1756556

  • RE: SQL Server 2012 - Express, 180 Day Evaluation, or Developer Edition?

    Express will have limited functionality.

    Evaluation and Developer will offer the same features as Enterprise edition. The problem with Evaluation would be the time constraint.

    How much can you learn from Developer...

    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

    November 3, 2014 at 4:10 pm

    #1756432

  • RE: good SQL Server dba books

    The books section in this site is a good source.

    http://www.sqlservercentral.com/Books/

    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

    November 3, 2014 at 3:03 pm

    #1756420

  • RE: Posted from SSIS 2005 Forum, on tight deadline need help.

    This solution might help you on what you need.

    http://beyondrelational.com/modules/2/blogs/106/posts/11123/ssisdynamically-set-file-mask-filespec.aspx

    Another quick option would be to use one ForEach Loop for each extension (more work, but easier).

    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

    November 3, 2014 at 12:04 pm

    #1756385

  • RE: Best way to validate telephone number

    You're missing a validation to get only numeric values. A value like 'ABCDE67890' would still pass your test. I'm leaving 2 options that validate for digit-only values.

    Information of this function...

    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

    November 3, 2014 at 9:53 am

    #1756356

  • RE: How to extract values from a column which has multiple delimiters?

    This is a different option using Pattern Splitting (using Lynn's sample data).

    select

    *

    from dbo.TestData td

    cross apply (select stuff((select ',' + ca.Item

    ...

    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

    November 3, 2014 at 7:45 am

    #1756331

  • RE: Are the posted questions getting worse?

    spaghettidba (11/3/2014)

    Now he's trying to set up a virtual lab environment and getting sysprep errors...

    You have to give him credit, it's not easy to work with Windows Evolution Edition. :hehe:

    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

    November 3, 2014 at 7:14 am

    #1756323

  • RE: Are the posted questions getting worse?

    Lynn Pettis (10/31/2014)

    Getting a error configuring mirroring. I am a programmer with no administration or network knowledge.

    Sorry, but this is a little scary at first.

    I understand that (s)he is...

    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

    October 31, 2014 at 2:04 pm

    #1756150

  • RE: The Geek Costume

    barry.mcanally (10/31/2014)

    This is my Michael Myers outfit complete with movie replica mask. Gave a few folks a fright already and I'm only just walking my husky!

    For some reason, I was...

    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

    October 31, 2014 at 10:42 am

    #1756098

  • RE: SQL server newbie

    JJR333 (10/31/2014)

    ... shrink the database...

    Be careful, you shouldn't be shrinking the database.

    http://blog.sqlauthority.com/2011/01/19/sql-server-shrinking-database-is-bad-increases-fragmentation-reduces-performance/

    I can't remember if express version comes with SQL Server Agent. If it does, you should use it 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

    October 31, 2014 at 9:52 am

    #1756072

  • RE: The Geek Costume

    I could get a fancy hawaiian shirt, remove some hair and dress up as Steve Jones :hehe:

    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

    October 31, 2014 at 9:38 am

    #1756066

  • RE: Calculating working hours between 2 dates.

    ikjeft01 (10/30/2014)

    not a fan of all those magic numbers.... 960? 465? 450? 585?

    That's why I included a bunch of comments to know what they're referring to.

    ikjeft01 (10/30/2014)

    Also, i'm thinking 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

    October 30, 2014 at 6:15 pm

    #1755948

  • RE: Arithmetic overflow error converting varchar to data type numeric.

    From the examples that you posted, I could only test the last one and the problem is with your precision which comes short. Changing it to 11 makes it work....

    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

    October 30, 2014 at 2:38 pm

    #1755921

  • RE: Some way to create a deterministic computed column that only has to count once?

    You're describing something that's known as Quirky Update. To get it right, you need to follow some rules or the results can't be guaranteed. Check the following article describing it.

    http://www.sqlservercentral.com/articles/T-SQL/68467/

    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

    October 30, 2014 at 12:11 pm

    #1755894

Viewing 15 posts - 5,581 through 5,595 (of 8,731 total)