Thanks Chris.

It's same results, still missing backup for those days.

Thanks Jeff.

I think it's really good idea to check the shared location and validate the files.

Appreciate your suggestions.

Thanks Chris.

I was running similar kind of query and it was showing similar results.

I ran your query and it's showing same results which has no backup but when i checked...

Thank you!

We are just setting up 2nd server for DR purpose so existing instance fails then we can use other one.

We don't have more DBs, only two DB

I am calling PowerShell script using batch script.

Batch Script:

powershell.exe -command C:\Users\ServiceCheck.ps1

Powershell Script (ServiceCheck.ps1):

$servers=get-content "C:\Users\servers.txt"

foreach($server in $servers)

{

# go to each server and return the name and state of services

# that are...

Jeff,

I am completely agreed with you but this is a OPENTEXT application software so table design we don't have any control.

Honestly, I don't know how frequently we are adding the...

Thanks Anvar for another code example to cover more level of hierarchie.

I will try and let you know.

Once again thank you very much for your great help!

Appreciate it!

Thanks Anwar for your very good help!

I am little confused when i was looking my data and try to use your query.

I have main ParentId, if i pass parentID then...

Thanks Med Anwar for your help!

WE have total records around 25k.

When i look into OpenText web, it shows following:

I need to generate report like following it shows into web, but...

Jeff,

Wow! I think this will work.

This is a OpenText software document. Rows will be added randomly, not fix.

I will check total rows and let you know.

I need to count by...

So Kind of Hierarchic is like as shown in image (It's not still perfect)

Thanks everyone for your response.

Thanks.

I am greed with you guys as checking with user exact condition. Both condition is overlapping so it's should be only one.

Thanks Phil.

Thanks for the help!

I think following works

ISNULL(loanNum, ' ') <> ' ' or RTRIM (LTRIM(LoanNum) <> ' '

Yes Phil,  I wanted to filter out as don't want to show.

I should try following?

ISNULL(loanNum, ' ') <> ' ' or RTRIM (LTRIM(LoanNum) <> ' '