Forum Replies Created

Viewing 15 posts - 2,521 through 2,535 (of 8,731 total)

  • RE: Query Question for New Guy

    Try this, you might need to check if you need to use the start or the end of the connection or both. I don't know, so I just left 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

    July 13, 2016 at 8:35 am

    #1889881

  • RE: Microsoft SQL Developer Certification For beginers

    Certification is designed for professionals with at least 2 years of experience using the products.

    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 13, 2016 at 7:26 am

    #1889849

  • RE: Columns to row

    Like this?

    DECLARE @sql nvarchar(MAX) = N'',

    @Table nvarchar(128) = N'Test'

    SELECT @sql = N'SELECT

    TT.PK

    ,X.COL

    FROMdbo.' + QUOTENAME(@Table) + N'TT

    CROSS APPLY

    (

    ' + STUFF(( SELECT N' UNION ALL

    SELECT TT.' +...

    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 13, 2016 at 7:08 am

    #1889840

  • RE: Sequential Numbers Joined to Serial Number Table

    There's a problem with your sequential number generator. It's explained in here: http://www.sqlservercentral.com/articles/T-SQL/74118/

    Here are 2 alternatives. One is using NOT IN as in your original query, the other is using...

    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 12, 2016 at 1:59 pm

    #1889720

  • RE: Copy huge table from one server to another

    You should try using bcp, it should use less resources to accomplish what you're doing. 😉

    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 12, 2016 at 12:18 pm

    #1889691

  • RE: MySQL database issue

    FrankKelly (7/12/2016)

    I need help to restore a mysql database. I'm using cpanel and phpmyadmin.I see not restore function in phpmyadmin.

    I'm sorry, this forum is specialized in Microsoft SQL Server, so...

    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 12, 2016 at 12:11 pm

    #1889689

  • RE: Multiple joins to same table in view

    Forget what I said earlier, you should be able to do it, you just need to unpivot one table.

    SELECT wo.fldWorkOrderID,

    wf.fldWorkOrderFixID,

    fldValueId1,

    ...

    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 12, 2016 at 10:21 am

    #1889652

  • RE: Multiple joins to same table in view

    I would say that you're stuck with the 6 outer joins.

    The problem is that you're joining on different columns from your WorkOrders table.

    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 12, 2016 at 9:48 am

    #1889643

  • RE: Sequence generation

    So what's the problem? What is impeding you to do 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 12, 2016 at 8:19 am

    #1889615

  • RE: Join 4 tables and get data based on a bitwise column

    Can you share sample data (no need for real data) for UsrList and LOG_UsrAccess tables? Also the expected results from that sample data.

    Thank 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 12, 2016 at 7:50 am

    #1889608

  • RE: Today's Random Word!

    djj (7/11/2016)

    Ray K (7/11/2016)

    Ed Wagner (7/11/2016)

    Lion

    Tiger

    Bears (oh, my)

    Care

    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 11, 2016 at 1:07 pm

    #1889502

  • RE: Is it possible to find and extract inline SQL from SSRS reports?

    You can use Notepad++ and the option "Search in files".

    You could possibly use a Regular expression as "<CommandText>*.SELECT", without the quotes.

    Remember that reports are simply xml files.

    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 11, 2016 at 8:59 am

    #1889436

  • RE: How can I use parameterized query (Select statement Where Col1= 'U') in OLEDB source of Data Flow task?

    John Mitchell-245523 (7/11/2016)

    Luis Cazares (7/11/2016)

    Mohit Dhiman (7/11/2016)

    3 - variable is used as ? in sq statement as param -- DOES NOT WORK

    Can't see why this should not work. Which version...

    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 11, 2016 at 7:55 am

    #1889416

  • RE: Today's Random Word!

    Ed Wagner (7/11/2016)

    Boom

    chick-chicky-boom

    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 11, 2016 at 6:25 am

    #1889389

  • RE: How can I use parameterized query (Select statement Where Col1= 'U') in OLEDB source of Data Flow task?

    Mohit Dhiman (7/11/2016)

    3 - variable is used as ? in sq statement as param -- DOES NOT WORK

    Can't see why this should not work. Which version of SSIS are 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 11, 2016 at 6:19 am

    #1889388

Viewing 15 posts - 2,521 through 2,535 (of 8,731 total)