Since it looks like you're using SQL 2005, based on the forum you posted in, the easiest and most secure way to do that is via a CLR stored procedure....

Try something like this out, see if it does what you need:

IF OBJECT_ID(N'tempdb..#T') IS NOT NULL

DROP TABLE #T;

CREATE TABLE #T (

ID INT IDENTITY PRIMARY KEY,

ParentID INT NULL);

INSERT INTO #T (ParentID)

SELECT...

Henrico Bekker (11/11/2010)

---

Also testing at the moment...

can someone try the following please?

create a small db in 2011, set compat mode to 2008, back up, try to restore in 2008, see...

You're welcome.

Use a recursive CTE to crawl the hierarchy (Books Online has an example of how to do this), and retain the top level ParentID as a third column in it....

I broke it down into pieces. See if this helps:

declare @text varchar(250)

set @text = 'Login succeeded for user ''domain\user''. Connection made using Windows authentication. [CLIENT: xxx.xxx.xxx.xxx]'

SELECT @text,

CHARINDEX('''', @text, 0),

CHARINDEX('.',...

You're welcome.

Can you ping from one to the other?

You're welcome.

Keep in mind that the math I did on it only works if the numbers are integers. Otherwise, you have to convert to integers before you divide, or...

Or someone's kid.

You're welcome.

You're welcome.

It's essentially the conversion from logical data model to a physical data model, so far as I understand it. Beyond that, it's all details.

The recursive UNION in your insert crashed SSMS for me. Might want to edit that out.

Does this do what you need:

SELECT EMP,

SUM(CAST(SUBSTRING(TRANSTME, 1, 3) AS INT)) + SUM(CAST(SUBSTRING(TRANSTME, 4,...

I'm not clear on what you want. Can you show an example?