@SSC-Addicted- Then how to default to email address for that AD alias?

For Example: Username: <domain-name>\<network-id> (dnid123)

Now when I click on subscribe then it picks up as SendTo="nid123" but I want...

It didn't work as intended. It is now coming as blank (nothing) field.

It is not picking up email address.

Thank you all 🙂

I checked the query and it works fine, can you please make sure you have selected everything. Also objname and newname are different. I am trying to rename PrimaryKey but...

I have formatted the question, I did my best to achieve it.

Thank you for your help.

I looked at the CAST and CONVERT online but was not able to find the solution.

It would be always "YY-MON" (MON=First three letters of the month).

In meantime, I am...

Thanks, this is exactly what I was looking for.

Yes, you are correct; I meant Row 1 and Row 5 are dupes & Row 2 and Row 4 are dupes.

In your example Row 1 and Row 5 are not...

I am sorry about that, later on I just realized it. I will be careful next time.

Didn't meant to waste anyone time.

No, this is similar but not the same. I...

Hi,

I have updated below table:

Col1Col2 Col3 Col4 RowNumber

123AX ...

Header Col1 Col2 Col3 Col4 ... Coln ...

Hey Phil,

The query is close by what I am looking for but two things:

- Query is only resulting back original rows which has similar duplicate data.

- What if data is...

I know it is complex:

Please see below, hope it is more clear:

Headers Col1 Col2 Col3 Col4 ...

For above example Col3 needs to check with Col3 only.

Yeah, this is for any column.