Forum Replies Created

Viewing 15 posts - 6,391 through 6,405 (of 13,877 total)

  • RE: SSIS Package documentor

    7036golf (11/4/2016)

    Having the same issues as

    pchelptx (12/4/2015)

    - no data in tables and the errors below

    ---------------Get all connections-----------------------------------

    ---------------Get all connections-----------------------------------

    ------------------------Get all variable details-------------------------------------

    ------------------------Get all variable details-------------------------------------

    ------------------------Get all...

    November 4, 2016 at 12:11 pm

    #1910695

  • RE: Determine if a table column is used?

    Try this. Notice how the count is zero for the column containing all NULLs

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

    DROP TABLE #tmp;

    CREATE TABLE #tmp

    (

    ...

    November 4, 2016 at 12:00 pm

    #1910687

  • RE: Sproc/view/function code parser

    SQL Code Guard[/url] may be of interest.

    November 4, 2016 at 11:03 am

    #1910666

  • RE: Get records which satisfy particular condition and exclude others

    Repeatedly asking the same question is not going to speed up replies.

    November 4, 2016 at 8:16 am

    #1910606

  • RE: Get records which satisfy particular condition and exclude others

    sindhupavani123 (11/4/2016)

    I have the following data with client account decision and status

    Clientfields value

    111Decisionaccept

    111Statusdeposited

    112decisionaccept

    113Decisionaccept

    114Decisionaccept

    114Statuscontract

    115DecisionConditional Accept

    115Statusdeposited

    116DecisionConditional Accept

    117DecisionConditional Accept

    118Statuscontract

    118DecisionConditional Accept

    I would like to get

    records...

    November 4, 2016 at 5:54 am

    #1910561

  • RE: how to trace the effected table when a primary table is updated/inserted

    hegdesuchi (11/3/2016)

    Hi,

    When we update/insert any table how do we know which other tables are effected in sql server?

    If we are using SQL profiler how do we set it up?

    The...

    November 3, 2016 at 4:06 pm

    #1910490

  • RE: Exclude the negative value in OT calculation

    sgmunson (11/3/2016)

    philand3 (11/2/2016)

    experts,

    how to exclude the negative value in this OT calculation,

    <<removed posted query for brevity>>

    This is in the category of double-posting... and hoping for an answer that doesn't disagree...

    November 3, 2016 at 6:38 am

    #1910329

  • RE: Concurrency - Please Provide Comments

    whenriksen (10/31/2016)

    Phil Parkin (10/30/2016)

    in this case, for queues of SSIS packages waiting to be executed, within different ETL jobs.

    The volumes I am dealing with are much lower than yours and...

    November 3, 2016 at 5:50 am

    #1910320

  • RE: Exclude the negative value in OT calculation

    philand3 (11/2/2016)

    experts,

    how to exclude the negative value in this OT calculation,

    ,CalcPart AS

    (

    SELECT

    department,subdepartment,dutyhours,person_num, event_date, in_time, out_time, minutes,day,friday,saturday,

    ROW_NUMBER() OVER (PARTITION BY event_date, person_num ORDER BY in_time) AS daypart

    FROM Prep

    )

    ,tmpResult as

    (...

    November 3, 2016 at 5:44 am

    #1910319

  • RE: Suspect data in SQL tables

    rjaye03 (11/2/2016)

    We have just encountered what appears to be suspect data in a lot of our SQL databases that house backend data for internal and external websites. For the...

    November 2, 2016 at 1:58 pm

    #1910226

  • RE: SSMS 2016 slow connection (Windows 10)

    matej_grabnar (11/2/2016)

    I have SSMS RELEASE 2016.5 installed. Tried reopen/reinastall - I even did format & reinstall Windows 10 (with like 1 month of great SQL working connections)

    I have no...

    November 2, 2016 at 8:30 am

    #1910122

  • RE: Include the first zero when converting time from datime into INT

    hoseam (11/2/2016)

    I have

    declare @t datetime = '2016-11-02 07:22:26.320'

    SELECT LEFT(CAST(REPLACE(CONVERT(VARCHAR, @t, 108), ':', '') AS INT), 6)

    which gives me INT value of 72226, and I want it to include the...

    November 2, 2016 at 6:33 am

    #1910080

  • RE: Adding Space to the Database

    GA_SQL (11/2/2016)

    need a script or an idea to create script when my db is full by 75% i want add some space to the db

    Is that because you have set...

    November 2, 2016 at 6:18 am

    #1910075

  • RE: Adding Space to the Database

    GA_SQL (11/2/2016)

    Adding space to the Database , when the db is 75% full

    here i done some script for finding free space

    select

    s.FILEID AS...

    November 2, 2016 at 5:47 am

    #1910067

  • RE: SSMS 2016 slow connection (Windows 10)

    matej_grabnar (11/2/2016)

    After upgrading from Windows 7 to Windows 10 - and after some updates of windows a very slow connection (10 - 20s) to SQL server accrued.

    Queries are executing...

    November 2, 2016 at 5:46 am

    #1910066

Viewing 15 posts - 6,391 through 6,405 (of 13,877 total)