Forum Replies Created

Viewing 15 posts - 8,146 through 8,160 (of 13,882 total)

  • RE: SQL Update Query

    debbie.coates 19265 (9/1/2015)

    Thats exactly right, LC has the priority, I just ran your script and tht is doing exactly what I am trying to do.

    I think not. This code gives...

    September 1, 2015 at 3:30 am

    #1823580

  • RE: SQL Update Query

    Vladan (9/1/2015)

    Phil,

    i may be mistaken, but I understand the reply with "consecutive months" precisely in the way you asked the question 🙂 that is, that there is no overlapping except...

    September 1, 2015 at 3:25 am

    #1823576

  • RE: SQL Update Query

    debbie.coates 19265 (9/1/2015)

    Yes, but only in the case of Type "LC", this value can overwrite all otheres. All the other types are in consecutive months.

    Can you give us some...

    September 1, 2015 at 3:15 am

    #1823573

  • RE: SQL Update Query

    Vladan (9/1/2015)

    Hi Debbie,

    I think that the problem is that you shouldn't need to update anything that is in this format. I can understand, that you create some report or whatever...

    September 1, 2015 at 2:51 am

    #1823566

  • RE: SSIS Error on Lookup - Expression with variable concatenation failed .

    sql crazy kid (9/1/2015)

    Error Description

    [LKP - If row exists in Target [104]] Error: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E14.

    An OLE DB record...

    September 1, 2015 at 2:38 am

    #1823562

  • RE: Variable conversion in SSIS

    vipin_jha123 (9/1/2015)

    I created 1 variabel with string data type.

    and on expression I tried to convert zonevalue variable to string using (WST_D18) but not getting

    May I ask how you ever expected...

    September 1, 2015 at 2:34 am

    #1823561

  • RE: Are the posted questions getting worse?

    TomThomson (8/31/2015)

    GilaMonster (8/31/2015)

    A question for those who have upgraded to Windows 10 and have SQL and Visual Studio installed:

    What the total size of the Windows and 2 Program Files directories?

    I'm...

    September 1, 2015 at 2:28 am

    #1823560

  • RE: Variable conversion in SSIS

    What have you tried so far?

    September 1, 2015 at 1:28 am

    #1823549

  • RE: Upgrade pacakges from SQL 2008 R2 to SQL 2014

    Sounds like you need to open up those dataflows and make sure that everything is looking correct. Specifically, I would check the following:

    1) Connections: source and destination both reachable.

    2) Columns:...

    August 31, 2015 at 3:39 am

    #1823320

  • RE: Stored proc runs slow after upgrade to SQL 2012

    Eirikur Eiriksson (8/30/2015)

    balasach82 (8/30/2015)

    Its a new Win 2008 R2 box with 128 GB ram. SQL is allocated about 4 GB (min) max (61 GB). Thsi configuratin is much higher than...

    August 30, 2015 at 5:09 am

    #1823254

  • RE: Foreach loopcontainer to load file which contains the string %vendor%

    Answered here.

    August 27, 2015 at 11:41 pm

    #1822972

  • RE: SSIS Catalog Logging

    Yes.

    August 24, 2015 at 3:18 pm

    #1822108

  • RE: HOW TO USE LAG() FUNCTION

    Nilssond (8/21/2015)

    CREATE TABLE dbo.SCHEDULES(SCHEDULEID VARCHAR(10), EFFECTIVE_DATE DATE, AMOUNT DECIMAL(4,3))

    INSERT INTO dbo.SCHEDULES(SCHEDULEID, EFFECTIVE_DATE, AMOUNT) VALUES('CMS_MI_8202', '2015/01/01', 6.200)

    INSERT INTO dbo.SCHEDULES(SCHEDULEID, EFFECTIVE_DATE, AMOUNT) VALUES('CMS_MI_8202', '2015/02/01', 6.225)

    INSERT INTO dbo.SCHEDULES(SCHEDULEID, EFFECTIVE_DATE, AMOUNT) VALUES('CMS_MI_8205', '2015/01/01', 90.025)

    INSERT...

    August 22, 2015 at 2:39 am

    #1821830

  • RE: Are the posted questions getting worse?

    Luis Cazares (8/21/2015)

    Ed Wagner (8/21/2015)

    Brandie Tarvin (8/21/2015)

    Phil Parkin (8/21/2015)

    Ah yes, tried to take a sneaky shortcut. Needs to be fixed:

    and sjh.run_date >= (year(getdate() - 1) * 10000 + month(getdate() -...

    August 21, 2015 at 7:23 am

    #1821683

  • RE: Stored Procedure Running Much Slower in SSIS Package

    I don't have an answer for you, but I do have a question.

    Did you consider doing this in a dataflow?

    Dataflow source = (your query)

    Dateflow target = suitably configured OLEDB command.

    It...

    August 21, 2015 at 6:17 am

    #1821651

Viewing 15 posts - 8,146 through 8,160 (of 13,882 total)