Nice one! 🙂

Thank you Jeff for your example.

The original table is very simple, only two columns (childid, parentid) and with PK on the child id column.

Since this table only has...

Hi Mark and thank you for your answer and explanation.

Yes, I understand that having out-nodes would be preferable but unfortunately this is not possible in the table.

The solution with keeping...

Hi Jeff.

A new topic is now started with the name "finding...

capn.hector (4/13/2012)

---

F.L (4/12/2012)

---

Hello,

Hijacking this thread since OP seems to be satisfied with the solution provided. (I hope that is OK)

I´m trying to use CTE to find the very top parent...

Hello,

Hijacking this thread since OP seems to be satisfied with the solution provided. (I hope that is OK)

I´m trying to use CTE to find the very top parent within a...

Since I must be missing something crucial, could someone please explain why you can’t achieve the same thing with a SCD component? Isn’t this a type 1 SCD (Update/Insert)?

I know...

Very nice script indeed.

Just a question, isn’t there some misinformation in this part?

BEGIN

--IF PAGE LEVEL LOCKING IS DISABLED THEN REBUILD

BEGIN TRY

EXEC ('USE ['+@DB_NAME+'];ALTER INDEX ['+@IND_NAME+'] ON ['+@SCHEMA_NAME+'].['+@TAB_NAME +'] REORGANIZE ')

END...

Anyone has some more suggestions on how to do this?

Is there anything built in for MS SQL 2008?

Also, The visio url seems not to work anymore. Anyone knows the name...

Thanks,

However, can this wrapper really work?

As Dave Wille says sysjobactivity contains many records for each job and for me most jobs contain values in Start_execution_date and Stop_execution_date even if they...

Hi, I would like to try this out but I can't find the "pr_RunAgentJob".

Is this similar to the sp_start_job in MS SQL 2005?

Also I found that code was missing in...

Hi

Thanks for your answer.

I must say that "SQL Server 2008 Management and Administration" seems like a perfect choice, specially by reading the reviews!

The “Accelerated SQL Server 2008” seems to contain...

Thank you all for your suggestions and tips!

ggraber: Yes you are right, don't know why I used the select * :hehe:

I think I will go for the PIVOT suggested by...

Yes of course 🙂

Sorry about that

Here is a small example:

CREATE TABLE #Users([UserAlias] [nchar](10) COLLATE Latin1_General_CI_AI NOT NULL,

[FName] [nchar](20) COLLATE Latin1_General_CI_AI NULL,

[LName] [nchar](20) COLLATE Latin1_General_CI_AI NULL,

[Organization] [nchar](20) COLLATE Latin1_General_CI_AI NULL)

INSERT INTO...