Forum Replies Created

Viewing 15 posts - 6,601 through 6,615 (of 13,877 total)

  • RE: Log Data Being Read/Queried

    Eric M Russell (10/4/2016)


    If for whatever reason the extended event trace doesn't give you what you need about input parameter values, then can also implement procedure call auditing using a...

  • RE: Parse street

    maikel01 (10/4/2016)


    Hi Guys,

    First post for me here, so i dont know if i am at the right place.

    I have a street that i need to dissect a streetname in 3...

  • RE: ssis and email

    Thom A (10/4/2016)


    This doesn't really sound like an SSIS task, no. Generally SSIS is used for ETL, and what you're doing here is simply checking the data and notifying someone...

  • RE: DUPLICATING ROW TABLE BY A VALUE IN A COLUMN

    JALLY (10/3/2016)


    yes, i want to create these duplicates.

    Merely repeating your request, rather than answering my question, does not fill me with enthusiasm in terms of providing a useful response, sorry.

  • RE: DUPLICATING ROW TABLE BY A VALUE IN A COLUMN

    JALLY (10/3/2016)


    Hello,

    How can i return rows in a table by a value in a column of that table:

    for example:

    i have a row with table structure below :

    !D Schedule ISCI rotationnumber

    1...

  • RE: Storing XML Config files in SSIS

    JustMarie (10/3/2016)


    Phil Parkin (9/28/2016)


    My company uses Control M to batch jobs. That requires config files. Moving to the catalog isn't an option.

    I'm interested. Can you explain why, please, in...

  • RE: Get the salary based on empno and month

    GA_SQL (10/3/2016)


    Ok,

    ..Such that there is a single table containing salaries, with appropriate effective dates.

  • RE: Pro rata monthly budget by week

    Kn1807 (10/3/2016)


    I need to pro-rata a monthly budget so that a greater proportion is allocated to beginning of month.

    They want it to be:

    working days 1-5 = 40% of total budget

    6-10...

  • RE: Get the salary based on empno and month

    GA_SQL (10/3/2016)


    i have table for each month which stores the employee's salary, i need SP which takes the input has empno and month with year has input, which should display...

  • RE: Get children of a parentID

    Please have a look at this link and see whether you may be able to adapt it to your situation.

    What you are probably looking for is a 'recursive CTE'.

  • RE: query to repeat insert same rows

    There's a quick 'n' dirty way of doing this which resembles the technique used by Des, whose set-up script I have copied (thanks!):

    IF OBJECT_ID('tempdb..#Required', 'U') IS NOT NULL

    ...

  • RE: SQL Server license requirements

    ashok.makil (10/1/2016)


    My query is whether SQL server license is required for the WEB server & for the application server ?

    Or is it required only for the database server.

    Regards.

    Ashok Makil

    It's required...

  • RE: Sql Server 2016 Installation Issue

    There is no 32-bit version. You need a 64-bit system to install SQL Server 2016. Check the system requirements page.

  • RE: Sql Server 2016 Installation Issue

    pavan.msbi558 (9/30/2016)


    Hi All,

    when i trying to install sql server 2016.iso file i am getting below error . Please give me solution for this issue

    sql server media is not supported on...

  • RE: How to copy entire Solution from one drive to another, rename, and all paths adjust accordingly

    quinn.jay (9/30/2016)


    John Rowan (9/30/2016)


    All you need are the .dtsx files. If you need to open them in a solution for editing, create a new project in Visual Studios, start...

Viewing 15 posts - 6,601 through 6,615 (of 13,877 total)