Forum Replies Created

Viewing 15 posts - 1 through 15 (of 727 total)

  • RE: Except

    Very good question..

  • RE: T-SQL query error while datetime conversion

    Jacob Wilkins (5/17/2016)


    sqlnaive (5/17/2016)


    Interestingly, what I found is suppose in Table overall I have 1000 records and after all the joins with other tables I get 200 records and in...

  • RE: T-SQL query error while datetime conversion

    Interestingly, what I found is suppose in Table overall I have 1000 records and after all the joins with other tables I get 200 records and in those 200 records,...

  • RE: T-SQL query error while datetime conversion

    drew.allen (5/16/2016)


    sqlnaive (5/16/2016)


    I've one table with one specific integer column containing date as YYYYMMDD format and apart from date it also may contain value 99999999. I'm using this table in...

  • RE: T-SQL query error while datetime conversion

    I checked all the distinct dates and everything looks good. From your query it was also more clear. All the date parts were good and under the definition of that...

  • RE: T-SQL query error while datetime conversion

    highest_year lowest_year highest_month lowest_month highest_day lowest_day

    2099 2005 ...

  • RE: T-SQL query error while datetime conversion

    It's a table. Used inside the view. I've given here just a select from this table. Actually there are many joins with other tables. But the select statement is same...

  • RE: T-SQL query error while datetime conversion

    I tried the following but still the same issue:

    CAST (CASE

    WHEN BusinessDate = '99999999' THEN '99991231'

    ELSE cast(BusinessDate as varchar(8))

    END AS datetime)

    And yes, when I'm trying it with other columns, it's giving...

  • RE: Outer Joins

    Aaah... As soon as I clicked it, I knew it's going to be wrong. Now that it is historical...

    But love being back on SSC...

  • RE: Cross Apply

    The question was confusing because of whatever was mention in the discussions BUT awesome query. Hats off...

  • RE: STUFF

    +1

  • RE: Query Help

    Thanks Imex. It works wonderful. With test data it works wonderful plus it's way efficient than UNION. Secondly with UNION, i was getting duplicate records if it's in both data...

  • RE: Query Help

    yes Gail. It should be:

    colA4 = 'case'

    and colA5 = 'ifelse'

    choosing between union vs union all, i have only option of Union as a record can be in either of the...

  • RE: SSIS package getting failed

    Apart from the above got the two following errors as well

    Error: 2015-07-16 10:15:40.57

    Code: 0x80004005

    Source: Generate Sales Data File

    Description:

    End Error

    Error: 2015-07-16 10:15:41.42

    ...

  • RE: Identity column insert issue

    I have somewhat found what's going on here. The two tables i'm talking here let's say TableA & TableB. The column name of the identity column is row_num_id. As part...

Viewing 15 posts - 1 through 15 (of 727 total)