YUCK!!! Can you go to the to other group and tell him how horrible their naming convention is? Add an underscore, space, anything...

Fixing this at the source will be...

Revenant (5/15/2012)

---

The problem, IMO, is that in many orgs there is never enough time to do things right the first time, but always enough time to "revisit" them, unfortunately with...

I would suggest that the looping concept above is not going to be very good for performance. What you are looking for is a slight tweak to an InitCap type...

/soapbox on

Yeah this just screams of bad things. I have referred to Access as "Corporate Cancer" for a long time. It seems that MS has decided we need fight an...

+1 yes this looks correct assuming we are...

If you want some real help please read the following article. How to Post Performance Problems[/url]

Without some details there is <0% chance that anybody will be offer any really good...

That sounds to me then like your connection is getting closed and therefore losing your app role. Maybe you should try either not closing the query object in between or...

You aren't being a pain. 😛 I think you need to build...

That is because you don't have data for that. Your second QA Fund 1 is from ID 7. There is nothing that says it has a parent of QA Fund...

You don't have any missing rows.

Take a look at this, it will show the ID of the children.

;WITH cte AS

(

SELECT CAST('' + Name AS VARCHAR(100)) as 'Name', ID

FROM dbo.RELATION

WHERE PARENT_ID...

Thanks that helps to see what the issue a ton!!!

I don't see how you would get the "missing" row. What you have coded is exactly what the data says should...

That is not ddl and does not make anything easier. Create table scripts and sample data (insert statements).

It would be quite a bit easier to help if you provided ddl and sample data. take a look at the first link in my signature for best practices when...

Using the example provided previously something like this would work too.

CREATE TABLE #tmp

(ID int primary key)

INSERT INTO #tmp

VALUES

(1)

INSERT INTO #tmp

VALUES

(2)

INSERT INTO #tmp

VALUES

(3)

INSERT INTO #tmp

VALUES

(5)

INSERT INTO #tmp

VALUES

(9)

INSERT INTO #tmp

VALUES

(10)

INSERT INTO #tmp

VALUES

(11)

INSERT...

tburk 5368 (5/14/2012)

---

I tried the loop and it cleared out the whole field and not just the ascii characters. i wrote it into a function

CREATE FUNCTION [dbo].[ReplaceCharacters] ( @InputString...