Forum Replies Created

Viewing 15 posts - 6,286 through 6,300 (of 13,877 total)

  • RE: Updating from text file

    PJ_SQL (11/21/2016)


    Hello,

    I am sending data(text file) to third party which they import to their tool which users pull information from and make changes.

    That data sent is combination of multiple...

  • RE: Input string format error in Execute Sql Task

    mcfarlandparkway (11/21/2016)


    I have an Execute Sql Task where I am using this SP.

    CREATE PROCEDURE [dbo].[InsData]

    @DB VARCHAR(20),

    @FeT VARCHAR(20),

    @SType VARCHAR(50),

    @Id INT OUTPUT

    AS

    BEGIN

    SET NOCOUNT ON

    INSERT INTO dbo.Emp(FeT,DB,SType,StrtDate)

    VALUES(@FeT, @DB, @SType, getdate())

    SELECT @Id =...

  • RE: want no header row in output

    Snargables (11/21/2016)


    Is there a way to call a sql select w/o it returning the column header row? Is there some sort of setting i can run before the select?

    What client...

  • RE: Are the posted questions getting worse?

    djj (11/21/2016)


    WayneS (11/21/2016)


    Hugo Kornelis (11/17/2016)


    Luis Cazares (11/17/2016)


    Hugo Kornelis (11/17/2016)


    Eirikur Eiriksson (11/17/2016)


    Brandie Tarvin (11/17/2016)


    Beatrix Kiddo (11/17/2016)


    It's in the link there.

    CREATE OR ALTER (Yes, we heard you !!!) – New CREATE OR...

  • RE: Integration Services evaluation period has expired

    Nagaram (11/21/2016)


    when I run installation as upgrade getting below errors , However I am a admin user.

    "TITLE: SQL Server Setup failure.

    ------------------------------

    SQL Server Setup has encountered the following error:

    Access to the...

  • RE: Trigger causing deadlocks

    zoggling (11/21/2016)


    John Rowan (11/21/2016)


    Consider changing your design. I prefer to not persist this type of value in my data. A view would be a great way to expose...

  • RE: Change Detection with (44) Columns!

    Jerid421 (11/21/2016)


    I am mirroring about (23) tables in another DW. I have built my first incremental loads package, for the first table, and it successfully checks for new rows,...

  • RE: Are the posted questions getting worse?

    Brandie Tarvin (11/21/2016)


    Ed Wagner (11/21/2016)


    Phil Parkin (11/21/2016)


    Ed Wagner (11/21/2016)


    Phil Parkin (11/21/2016)


    Ed Wagner (11/21/2016)


    Jeff Moden (11/21/2016)


    I have to do some more research on it but it may be time for me...

  • RE: Integration Services evaluation period has expired

    Nagaram (11/21/2016)


    Can you please share the steps or weblink to upgrade it

    It should be simple enough. In overview

    1) Get software for the edition of SQL Server you wish to install...

  • RE: Are the posted questions getting worse?

    Ed Wagner (11/21/2016)


    Phil Parkin (11/21/2016)


    Ed Wagner (11/21/2016)


    Jeff Moden (11/21/2016)


    I have to do some more research on it but it may be time for me to get ready to retire.

    [font="Arial Black"]Microsoft...

  • RE: Are the posted questions getting worse?

    Ed Wagner (11/21/2016)


    Jeff Moden (11/21/2016)


    I have to do some more research on it but it may be time for me to get ready to retire.

    [font="Arial Black"]Microsoft Replaces Command Prompt with...

  • RE: Trigger causing deadlocks

    zoggling (11/21/2016)


    Will an index not just potentially slow things down further?

    Can you see any way in which this trigger can be improved? This seems to be our sole (and frequent)...

  • RE: RETRIEVE NEXT TIME VALUE FROM NEXT RECORD

    Here is the forum etiquette link: http://www.sqlservercentral.com/articles/Best+Practices/61537/%5B/url%5D

    Notice how striking a resemblance your test data bears to that shown in the 'The Wrong Way to Post Data' section.

    If you want a...

  • RE: Integration Services evaluation period has expired

    Nagaram (11/21/2016)


    Hello Experts,

    When I SSIS package from SQL Server Agent, getting error as below

    "Description: Integration Services evaluation period has expired. End Error Error: 2016-11-21 16:00:00.96...

  • RE: RETRIEVE NEXT TIME VALUE FROM NEXT RECORD

    You've been here long enough to know what is required: sample DDL, INSERT statements containing sample data and desired results based on your sample data, please.

Viewing 15 posts - 6,286 through 6,300 (of 13,877 total)