Forum Replies Created

Viewing 15 posts - 9,091 through 9,105 (of 13,876 total)

  • RE: Script to change SQL Server and SQL Server Service Logins.

    Welsh Corgi (9/9/2014)

    Welsh Corgi (9/9/2014)

    I need a Script to change SQL Server and SQL Server Service Logins.

    Does any one have a script to do this?

    Hi.

    Why did you remove your post?

    Talking...

    September 10, 2014 at 1:25 am

    #1744332

  • RE: Concurrent Stored Procedures

    pgmoschetti (9/9/2014)

    Thank you Phill. What I know about the client is as follows:

    - it's a SCADA software (Citect SCADA)

    - the SQLExec is using ADO.NET behind the scene

    - the four SQLExec...

    September 9, 2014 at 7:16 am

    #1744105

  • RE: Concurrent Stored Procedures

    This depends on how 'SQLExec' is implemented. More details needed about that before we can answer.

    September 9, 2014 at 3:38 am

    #1744055

  • RE: ? conditional

    ronan.healy (9/9/2014)

    ill probably have to use an sql script to update the columns as that doesn't get all 3 in for me

    Please explain why not.

    I thought you wanted Comp A,...

    September 9, 2014 at 3:35 am

    #1744053

  • RE: ? conditional

    Perhaps something like this?

    BASIS_IND == "A" ||BASIS_IND == "T" ?: "Comp " + BASIS_IND : "Comp"

    You might need to use & instead of + to concatenate the text - can't...

    September 8, 2014 at 8:37 am

    #1743885

  • RE: ? conditional

    ronan.healy (9/8/2014)

    ok is there anyway I cant put the 3 rd expression in as anything that's not a or t I just want as comp

    There is no need for a...

    September 8, 2014 at 8:33 am

    #1743883

  • RE: ? conditional

    The basic syntax is as follows:

    boolean_expression?expression1:expression2

    Your expression

    BASIS_IND == "A" ||BASIS_IND == "T" ?: "Comp A": "Comp T" : "Comp"

    has an 'expression3' - which I imagine is causing the error. (In...

    September 8, 2014 at 7:51 am

    #1743865

  • RE: ? conditional

    Try removing the first question mark.

    September 8, 2014 at 4:54 am

    #1743816

  • RE: Excecute process Task for executing a bat file

    vijayalakshmii.venkatesh (9/5/2014)

    I have a exec file which takes multiple input variables and produce output in the form of Table.

    Can I achieve this through Excecute process Task...

    September 5, 2014 at 2:58 am

    #1743444

  • RE: View results not displaying nil columns

    If you remove the AND clause completely, are the required rows displayed?

    Please do a SELECT from dbo.cdbAttribInst showing the value of ainAttribID for the rows you want to appear and...

    September 5, 2014 at 1:31 am

    #1743421

  • RE: Variable - evaluates to include seconds - every reference it has new value (seconds)

    There is an SSIS System Variable called 'StartTime'.

    You may be able to create an Expression which uses this, thus avoiding the need for a Script Task.

    September 5, 2014 at 1:13 am

    #1743418

  • RE: View results not displaying nil columns

    cstrati (9/5/2014)

    Hi Phil

    Thanks for your reply.

    Unfortunately I've ran your script and I'm getting the same 4 results.

    It doesn't appear that the columns that are emtpy display when adding 'Null'...

    September 5, 2014 at 1:01 am

    #1743412

  • RE: View results not displaying nil columns

    Also, if lots of data is involved, that WHERE clause is going to tax the database engine because of all those function calls. We may be able to help optimise...

    September 5, 2014 at 12:46 am

    #1743409

  • RE: View results not displaying nil columns

    cstrati (9/5/2014)

    I have a view I've created which displays client sortname, partner and date added which displays 7 results.

    When I add another table to this view to display the Industry...

    September 5, 2014 at 12:44 am

    #1743407

  • RE: Pairing Data Vault and Biml for DW Agility

    mark 66658 (9/3/2014)

    Hi, thanks for the article on DataVault and BIML! I'd very much like to see a series of articles on the topic if at all possible. ...

    September 4, 2014 at 12:27 am

    #1743091

Viewing 15 posts - 9,091 through 9,105 (of 13,876 total)