![]() |
Need to select/pick a value to load into another table using below conditions - can someone help and throw some ideas -
14 Mar 2016
| 1 comment
,
|
![]() |
Trying to use REGEXP_INSPR to identify if a VARCHAR(50) column contains data that can be converted to Decimal(8,2) and if so convert it. Below is my SELECT:
28 Jan 2015
| 2 comments
,
|
![]() |
Hi. I am wondering what capabilities TD offers in the way of case statements in joins.
03 Jun 2014
| 1 comment
,
|
![]() |
Hi Guys,
11 Feb 2014
| 10 comments
,
|
![]() |
Hello Experts,
05 Dec 2013
| 2 comments
,
|
![]() |
My data has four columns date, departure, destination and depart time. I have a case statement that groups depart times. It works fine but it does not group departures between 18:31 and 19:00. Time is
11 Nov 2013
| 3 comments
,
|
![]() |
Hi experts, select case when 1=1 then cast('00010101' as timestamp format 'YYYYMMDD') end O/P: 1/1/0001 00:00:00.000000
08 Jun 2013
| 3 comments
,
|
![]() |
I am comapring accid from previous month and current month. The following query is not working pls. advise!
09 Aug 2011
| 2 comments
,
|
![]() |
I want to execute SUM of a field at different grouping levels... is it possible to use SUM inside CASE statement??? Something like below..
20 Jun 2010
| 30 comments
,
|