Forum Replies Created

Viewing 15 posts - 3,136 through 3,150 (of 8,731 total)

  • RE: Processing strings.

    ben.brugman (3/25/2016)

    Luis Cazares (3/25/2016)

    In my opinion, you would be better fixing the process that creates the string. Something as simple as changing the delimiter would solve all the headaches.

    Probably most...

    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

    March 25, 2016 at 3:53 pm

    #1867812

  • RE: Error: The database is not accessible. ( object explorer)

    You must create a user for that login on each database.

    https://msdn.microsoft.com/en-us/library/ms173463.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

    March 25, 2016 at 1:20 pm

    #1867795

  • RE: INSERT Statement - How to Handle to Avoid Thousands

    kocheese (3/25/2016)

    So if there are three ProjectCategory rows, I would have three inserts for the same value.

    No, you don't need three inserts. You need one insert statement that...

    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

    March 25, 2016 at 12:47 pm

    #1867790

  • RE: Error: The database is not accessible. ( object explorer)

    hlsc1983 (3/25/2016)

    I created a new user with administrator rights in Windows7. I can connect to the server instance , and see the list of dbs but I cannot expand...

    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

    March 25, 2016 at 11:51 am

    #1867776

  • RE: Processing strings.

    In my opinion, you would be better fixing the process that creates the string. Something as simple as changing the delimiter would solve all the headaches.

    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

    March 25, 2016 at 11:09 am

    #1867768

  • RE: INSERT Statement - How to Handle to Avoid Thousands

    kocheese (3/25/2016)

    I realize this database is not normalized, but unfortunately I inherited it when the previous developer left and I was hired to replace him and now I must 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

    March 25, 2016 at 8:05 am

    #1867742

  • RE: The SIGN

    I missed the duplicate row :pinch:

    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

    March 25, 2016 at 7:10 am

    #1867732

  • RE: INSERT Statement - How to Handle to Avoid Thousands

    Maybe something like this:

    DECLARE @ProjectType varchar(20) = 'Infrastructure'

    , @ProjectSubType varchar(20) = 'ALL'

    ...

    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

    March 25, 2016 at 6:59 am

    #1867728

  • RE: sql and stored procedure

    I like Orlando's idea, but here are some other options:

    Use a Central Management Server. If you're going to do this manually, you could actually just register the servers in SSMS...

    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

    March 25, 2016 at 6:47 am

    #1867726

  • RE: Search for hyphen in database: it does not find the hyphen?

    I just realized that you're querying the source table. Change the ASCII function for UNICODE. That should show the difference as shown by Stephanie.

    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

    March 24, 2016 at 2:46 pm

    #1867635

  • RE: How do I install AdventureWorks in my local PC

    mw112009 (3/24/2016)

    Luis:

    See attached.

    I tried "local", "." and my Computer Name.

    I think its a right issue. What am I missing here ? What should I tell the help desk folks...

    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

    March 24, 2016 at 2:33 pm

    #1867629

  • RE: Today's Random Word!

    Ed Wagner (3/24/2016)

    djj (3/24/2016)

    Ed Wagner (3/24/2016)

    Luis Cazares (3/24/2016)

    TomThomson (3/24/2016)

    djj (3/24/2016)

    H2

    O

    O2

    Breathe

    Respiration

    Perspiration

    Inspiration

    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

    March 24, 2016 at 2:08 pm

    #1867617

  • RE: Search for hyphen in database: it does not find the hyphen?

    What do you get if you run this query?

    WITH

    E(n) AS(

    SELECT n FROM (VALUES(0),(0),(0),(0),(0),(0),(0),(0),(0),(0))E(n)

    ),

    E2(n) AS(

    SELECT a.n FROM E a, E b

    ),

    E4(n) AS(

    ...

    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

    March 24, 2016 at 2:07 pm

    #1867616

  • RE: How do I install AdventureWorks in my local PC

    mw112009 (3/24/2016)

    Ed:

    I agree, But I do not know how to connect. I mean I know how to open SSMS and then connect to other servers, run sql statements.

    In this case...

    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

    March 24, 2016 at 2:01 pm

    #1867614

  • RE: Today's Random Word!

    TomThomson (3/24/2016)

    djj (3/24/2016)

    H2

    O

    O2

    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

    March 24, 2016 at 11:54 am

    #1867559

Viewing 15 posts - 3,136 through 3,150 (of 8,731 total)