Thanks Lynn.

Regards

DJ

thanks so much Lyn for the one liner code for my requirement-

If the first 8 characters meet one of the following two scenarios:

1. All 8 are numeric-no special characters or...

Thanks much Lynn that really cool ti works .

but just for my understanding sake wanted to learn what does this line do - GHRMSContingentID like N'[A-Za-z0-9][0-9][0-9][0-9][0-9][0-9][0-9]%'

? in simple ay...

Hi Lynn,

i tried it this way-\--

when [w].[GHRMS Contingent ID] IS NOT NULL

-- if the 1st 8 characters meet All 8 are numeric-no special...

Thanks that helped me a lot.

Regards

DJ

Yes thanks much 🙂

My Bad , you are right DateDiff will always give whole number.

thanks

DJ

Hi Friend,

it sounds correct since I'm using same code but I needed to know how to get the O/P of that code as a WHOLE NUMBER.

thanks

DJ

Dear Journey Man,

I have to calculate the value for a field "[ORC Position Duration (months)]" using the following 2 fields from DataBase source- 1)Target Start Date , and 2) Temporary...

Hi Champion-

I have to calculate the value for a field "[ORC Position Duration (months)]" using the following 2 fields from DataBase source- 1)Target Start Date , and 2)...

Dear Jeff,

thanks for helping me with the code.

It worked accurately as per need.

Kind Regards

DJ

Dear Jason,

The Field name is "Latest Filled Date," and format is smalldate time - below are few values of this field:

Latest Filled Date

2013-11-20 13:43:46.000

Latest Filled Date

2013-12-10 13:42:45.000

Latest Filled Date

2013-11-22...

Thanks much Luis for the help I used instead of IIF the alternative-

select *, cast (

case

when [ES Fully approved data 1] = ''

and[ES Fully approved data 2] = ''

and...

IIF comes from SQL 2012 and not sqo 2008 hence need some alternative soultion please

Hi Luis,

I tried but seems SQL server 2008 does not recognize 'IIF' is that being deprecated ?

thanks

dj