Forum Replies Created

Viewing 15 posts - 4,666 through 4,680 (of 13,877 total)

  • RE: Error uploading jgp

    lucaskhall - Tuesday, February 20, 2018 12:42 PM

    the cv_wo_xtd_imgs tables holds photos that are uploaded and I have an on insert trigger...

    February 20, 2018 at 12:52 pm

    #1980526

  • RE: Error uploading jgp

    lucaskhall - Tuesday, February 20, 2018 12:22 PM

    Thanks for the input I guess now I am curious why it only seems to...

    February 20, 2018 at 12:36 pm

    #1980523

  • RE: SSIS equivalent of a case when

    david_h_edmonds - Tuesday, February 20, 2018 11:51 AM

    Hi Phil, thanks for the reply. Derived_Status is already a mapping table field that I...

    February 20, 2018 at 11:55 am

    #1980515

  • RE: SSIS equivalent of a case when

    david_h_edmonds - Tuesday, February 20, 2018 9:57 AM

    Hi, I have come up with a different solution, not quite as sustainable with high...

    February 20, 2018 at 11:02 am

    #1980507

  • RE: Error uploading jgp

    lucaskhall - Tuesday, February 20, 2018 9:10 AM

    i have an SSIS package that takes a image in my database and uploads it...

    February 20, 2018 at 10:52 am

    #1980502

  • RE: 5 years or older

    craig.jenkins - Tuesday, February 20, 2018 5:50 AM

    I'm an idiot, sorry guys

    Don't be so hard on yourself, we've all done it 🙂

    February 20, 2018 at 5:57 am

    #1980428

  • RE: 5 years or older

    Thank Guys, i've attached some dummy data below. As you can see the regdates are not older than 5 years

    And that is why you are selecting them.

    February 20, 2018 at 5:46 am

    #1980425

  • RE: 5 years or older

    craig.jenkins - Tuesday, February 20, 2018 4:38 AM

    Guys, if i have a list of dates in a table how do i query...

    February 20, 2018 at 5:13 am

    #1980419

  • RE: Inserting multiple records dynamic

    smthembu - Monday, February 19, 2018 9:37 AM

    Good day,
    I need to insert 7000 records into Table B and also add the same...

    February 19, 2018 at 9:56 am

    #1980296

  • RE: Delete rows based on a second table

    xxx-593414 - Monday, February 19, 2018 8:02 AM

    I have two Tables (In Ms Sql Server)
    Table Name           Column Names
    MasterCities          Countryy    City
    VisitedCities           Country    ...

    February 19, 2018 at 8:23 am

    #1980279

  • RE: Script task loses code in SSDT 2015?

    caf 13920 - Monday, February 19, 2018 6:39 AM

    Is there a bug with SSDT 2015 also regarding the Script Task component? If...

    February 19, 2018 at 6:43 am

    #1980259

  • RE: Data Files (mdf)

    Lj Burrows - Monday, February 19, 2018 5:47 AM

    Yes you can merge two or more database to one by restoring the databases...

    February 19, 2018 at 5:56 am

    #1980256

  • RE: Need to get consecutive duplicate rows

    Please describe why the solution i provided is unsatisfatory. It worked ok for me.

    February 17, 2018 at 3:18 pm

    #1980184

  • RE: Need to get consecutive duplicate rows

    Here is one way:

    WITH AllVals
    AS
    (
      SELECT
       *
      ,  PrevColB = LAG(t.ColB, 1) OVER (ORDER BY t.ColA)
      ,  PrevColC = LAG(t.ColC, 1)...

    February 16, 2018 at 2:12 pm

    #1980139

  • RE: Are the posted questions getting worse?

    Luis Cazares - Friday, February 16, 2018 11:55 AM

    Phil Parkin - Friday, February 16, 2018 10:33 AM

    February 16, 2018 at 12:35 pm

    #1980120

Viewing 15 posts - 4,666 through 4,680 (of 13,877 total)