Hi Sean,

When you say-

"

I haven't seen all the other threads but from what you posted I can't figure out why you are using DATEDIFF at all. It doesn't meet your...

Thanks so much for the help to get me understand this since I come from Java world...

Also needed some help to know which is a best book to learn TSQL...

Hi Ed,

thanks for the info, yes I have used similar logic and it's working-

///

LOGIC FOR CONSOLIDATED NEW SLLI REPORT-

create table #tmp_Set_Flags- temp table created

insert into #tmp_Set_Flags

select...

Thanks Lynn you are right

Hi Lynn,

that will not help since in my case one of the dates can remian NULL hence if that's the case then it will not work using > , =...

I would prefer datediff since that way not dependent of type of date format in DB hence need help please:-)

Hi friends,

the temp table idea helped me-

I used the logic as below- it helped me thanks a lot!!!

//

create table #tmp_Set_Flags- temp table created

insert into #tmp_Set_Flags

select JP RECORDS

FROM...

Thanks so much that worked as per requirement 🙂

Hi,

seems the code you gave is workign just tried-

//

declare @a nvarchar(50)

set @a= 'HPJP00000013'

select @a=case when @a like ' [^ ]%' then LTRIM(@a) end

print @a

//

When I put one leading space then...

Hi,

sorry if I was not clear in my request above,

Basically what I'm looking for is-

I have string with value "HPJP00000013"

if this field value has one LEADING SPACE...