Forum Replies Created

Viewing 15 posts - 7,546 through 7,560 (of 13,876 total)

  • RE: overlap query where to and from can be same ( of next and previous range)

    rajemessage 14195 (2/12/2016)

    is the second one correct or not.

    i have to find out where it is overlapping in second case.

    Your description is unclear. Are you able to introduce clarity by...

    February 12, 2016 at 2:06 am

    #1858258

  • RE: numeric data in varchar datatype

    SQLAddict01 (2/11/2016)

    I have a column with varchar data type but has numeric data in it

    I know I can't use arithmetic operation for varchar

    This is my query

    select * from table1

    where col1>...

    February 11, 2016 at 2:13 pm

    #1858180

  • RE: numeric data in varchar datatype

    yb751 (2/11/2016)

    Just a couple things to consider. Make sure you validate your data to make sure it's actually a number. i.e. (ISNUMERIC). Secondly, try to avoid using CONVERT...

    February 11, 2016 at 2:11 pm

    #1858178

  • RE: Trigger issue committing data

    JKSQL (2/11/2016)

    If a record does not exist in this table the update on "SomeTable" should work. When I debug I see it working the way I would expect but...

    February 11, 2016 at 11:35 am

    #1858130

  • RE: SSIS Import File Format

    mikefle (2/11/2016)

    Does anyone have any views on what is the best file format to request data to be sent in?

    We have a number of processes where files are sent to...

    February 11, 2016 at 10:08 am

    #1858090

  • RE: Concat question

    Jacob Wilkins (2/11/2016)

    It's because CONCAT converts NULLs to empty strings prior to concatenation; that's its difference/advantage to ordinary concatenation with +.

    In the first case, when region is null, it's converted...

    February 11, 2016 at 10:04 am

    #1858088

  • RE: creating an aquireConnection error

    bark stuff (2/11/2016)

    Hello, I have a ssis package that reads from hadoop via an ODBC source in a for loop. The ODBC connection is a bit flaky and...

    February 11, 2016 at 6:00 am

    #1857986

  • RE: Personalising SSMS

    Steve Jones - SSC Editor (2/10/2016)

    SQL Prompt and Search for me. Of course, I work for Redgate, so I get the former.

    I change fonts usually to make it easier to...

    February 10, 2016 at 1:28 pm

    #1857860

  • RE: Personalising SSMS

    leehbi (2/10/2016)

    Hi,

    I've started to personalise my SSMS environment to aid development. Not a lot but small things make a difference over the long term.

    Some of the things I've done...

    February 10, 2016 at 12:37 pm

    #1857838

  • RE: package doesn't run when moved to production server

    scotdg (2/10/2016)

    SQL Server Integration Services

    Phil Parkin (2/10/2016)

    When I run the package from SSIS

    I still don't know for sure what this means. I presume you mean SSDT.

    Here[/url] are some of the...

    February 10, 2016 at 11:56 am

    #1857829

  • RE: Add two varchar columns which has numeric data

    SQLAddict01 (2/10/2016)

    I have two varchar columns, but I have numeric data in both the columns.

    Is it possible to add two columns?

    Please let me know

    Thanks

    Sure. Here's a way:

    DECLARE @x varchar(10) =...

    February 10, 2016 at 11:23 am

    #1857816

  • RE: package doesn't run when moved to production server

    When I run the package from SSIS

    I still don't know for sure what this means. I presume you mean SSDT.

    February 10, 2016 at 9:32 am

    #1857769

  • RE: Select Latest record by comparing 2 tables.

    kavithaje (2/10/2016)

    It is just dummy table name. Query is working fine now.

    Am able to get single record based on time stamp.

    Thank you.

    Perhaps you would describe what was wrong with Drew's...

    February 10, 2016 at 8:58 am

    #1857747

  • RE: A cautionary tale on the 2014 CE

    Interesting, thanks for posting this.

    February 10, 2016 at 8:55 am

    #1857745

  • RE: package doesn't run when moved to production server

    OK.

    The package runs fine on the production server when I run it from SSIS

    Can you elaborate on exactly what you mean here - what steps are you taking?

    February 10, 2016 at 8:13 am

    #1857731

Viewing 15 posts - 7,546 through 7,560 (of 13,876 total)