Thank you friends.

Regards,

Abhas.

Hi,

Below is expected result. i want to compare each with next row on datetimefield and fetch the difference between two. Again comparision is ID wise. If next row contains different...

• This reply was modified 4 years, 5 months ago by  abhas.
• This reply was modified 4 years, 5 months ago by  abhas.

.Thanks Anthony,
I am fetching employee data using SP from source 1 and columns are empid,firstname,lastname
From Manager table I am fetching EmpId,Manageremail. etc.

I am using two sources...

Thanks drew,

Thank you so much, Your approach is working fine.

🙂

Thanks,

Abhas.

Eirikur Thanks for reply...

Rule is username should be first letter of first name + LastName.

Now, If first letter of first name + LastName is repeated then consider first two letters...

Hi Guys,

Again posting as one test case has failed. 🙁

below code generates username wrong. it is creating usernames as below:

APatil

Abhas1Patil

But requirement is

APatil

AbPatil

SET NOCOUNT ON;

IF OBJECT_ID(N'tempdb..#TEMP_USER') IS...

Hi Friends,

Thanks for your suggestion mhtanner and MMartin1 but client want this implementation only.Explained issue but they want like that only. 🙁

Thanks again Eirikur for your help. You...

Hi,

Thank you so much Eirikur and David.

Really appreciate your efforts. Its working as per requirement.

Only one issue - when same firstName and LastName comes then creating only one username....

Hi Eirikur,

Requirement is as below:

Need to create username. Logic is:

First letter of firstname + Lastname.

Eg. Firstname = Abhas and LastName = Patil then username = apatil

Now again case come...

hi,

if first two letters are same then use first three letters for second user and so on......

Thanks

Abhas.

Thanks Eirikur and Jeff.

Now again requirement has changed. Now instead of increment, new logic is as below:

First letter of firstname + LastName.

If username alreadu exists then create as:

First two...

Thanks Eirikur,

your code works exactly as per requirement.

Sorry for mentioning incomplete question.

Thank you so much.

Regards,

Abhas.

Thanks Eirikur,

your code works fine, but while inserting into TEMP_USER table, after creating username, getting issue. For first time insert it works fine but if next day again 'aarav patil'...

Hi Philip,

I am able to load all tabs but how to load the tabs whose name format is : 1Q17, 4Q16,3Q16 etc.

Thanks,

Abhas.

Thanks Jhon,

I have changed code as below and its working for me.

Code == "\"CPP\"" &&! (ClData!= "\"n/a\"" ||ClData!= "\"n/a~\"" )

Thanks,

Abhas