Very good question..

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...

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,...

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...

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...

highest_yearlowest_yearhighest_monthlowest_monthhighest_daylowest_day

2099 2005 ...

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...

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...

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...

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

+1

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...

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...

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

...

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...