Forum Replies Created

Viewing 15 posts - 3,946 through 3,960 (of 13,855 total)

  • RE: Compare of variables and handling nulls

    INSERT scripts can be generated from SSMS, though it's not entirely intuitive how you do it.

    Please take a look here.

  • RE: How to find out why a column from Source won't be inserted in Target

    DinoRS - Wednesday, October 17, 2018 4:18 AM

    DELETE FROM dbo.Table
    WHERE     (YEAR(CONVERT(datetime, CONVERT(char(8), FILE_DATE))) = YEAR(GETDATE()))

    works pretty well. I know this...

  • RE: How do you handle SSIS package merging between two BI teams?

    Data Cruncher - Wednesday, October 17, 2018 4:42 AM

    Uhm, got it.. So we'll keep raising hands to get a priority on a...

  • RE: SSIS Connection String by Project Variable

    ... check for files with the current date ...

    What do you mean by this?

    • DateCreated = today?
    • DateModified = today?
    • Filename contains today's date, in some...

  • RE: How to find out why a column from Source won't be inserted in Target

    DinoRS - Tuesday, October 16, 2018 9:54 AM

    It just refuses to work when you go for a YEAR(FILE_DATE) when all values are...

  • RE: Casting one datetime as date converts other datetime fields

    robert.wiglesworth - Tuesday, October 16, 2018 8:58 AM

    I have a table with two DateTime fields. When I select them and cast one...

  • RE: How to find out why a column from Source won't be inserted in Target

    DinoRS - Tuesday, October 16, 2018 7:35 AM

    The decision to store a date in bigint format was not mine, I basically just...

  • RE: How to find out why a column from Source won't be inserted in Target

    DinoRS - Tuesday, October 16, 2018 6:59 AM

    Hi there,

    so I have the following problem: I have a Dataflow which picks up FILE_DATE...

  • RE: Command-line Building of a Single Solution for Multiple Versions of SQL Server

    vanceother - Tuesday, October 16, 2018 4:29 AM

    I posted this same article to the Continous Integration forum but thought the SSDT forum...

  • RE: Sorting by a column when the name is derived via a CASE statement

    j.clay 47557 - Monday, October 15, 2018 6:17 AM

    Hi everyone

    I have created the following SQL statement which works fine. However, it would...

  • RE: Compare of variables and handling nulls

    allan.ford17 - Sunday, October 14, 2018 9:18 PM

    Hi,

    I wanted to compare 3 variables and set a flag if any of the three...

  • Viewing 15 posts - 3,946 through 3,960 (of 13,855 total)