Hi Barry,

I mean using your recursive view it is still returning only very few records (24 in total), for a records number of 4000 in ISC_OrgUnits, I should be able...

Hi Barry,

Thank you very much for your time. I have just pull out the real data as spreadsheet (see the attachment). I don't see a positive result in your recursive...

Thank you Barry.

I am still wondering if a function is possible?

Thanks Barry,

This is my first time using recursive view, the result doesn't seem to be reasonable, 'cause I have 60773 nodes in ISC_OrgUnits and 23 in RSUNew, presumably the view...

Thank you Barry,

But I do need a Scalar-Valued Function, I need to call the function in other function/stored procedure. Can you help me that?

FUNCTION [dbo].[fnGetTopOrgUnitIDInRSU] (@OrgUnitID varchar(20)) returns varchar(20)

Thanks in...

Thanks for the answer.

thanks.

Problem is I can't connect to it now, first thing is how to connect to it.

up

Some update: after another reboot, now I get "Can not open user default database, login failed"

Thanks for replying. Can you elaborate? there was no any problem before, the only thing I am doubting is the DB is too big and I am just about to...

Ian Scarlett (7/7/2009)

---

Rather than add a SortOrder column to the table, just include one in your query e.g.

select id, forename, case when forename = 'Kim' then 1 else 2 end...

Thanks for replying, I can't add extra column to the table, any other thought?

Thank you very much, it works perfectly like I expect.

Never mind Gail, I've figured out. Thank you for your time.

🙂

Hi Gail,

As I said, the table structure is just like what I posted.

ID

Field1

(Field2...)

...

Sample data:

1 aaaa

2 bbbb

3 cccc