Well you had me entertained until you decided to send that sad excuse of an e-mail to the interviewee. It really showed your lact of tact and sadly you sent...

Thanks, but this isn't a Comcast project nor do I work for Comcast. I'm confident that there are people out there like myself who have helped others in the past...

Thank you for the suggestions, you both brought up some good points.

Demicoq

Ok figured it out. Here is the solution.(one way to solve that is.......)

DECLARE @domain varchar(80)

DECLARE @domainid int

Select @domain = '7'

--Get the domainid of the domain that is being passed in.

SELECT...

Any luck with this question J.P.?

Quick note: Here is the modified script to go with the script you provided me with last week.

DECLARE @domain varchar(80)

set @domain = '12' --This guy happens to have a parent...

This is close but what I need it do is always find the highest level in the hierarchy where the type is = 1. It just so happens that Type...

Hi JP

Using the solution for finding levels I am able to go up the tree to find the grand parent of the id I provide. So far I have three...

Thank you very much for your help on this JP. Your solution "fits the bill".

Demicoq

Thank you for your response JP, I believe this will get me closer to what I was looking for, a thousand thanks.

To give you a little more background, what I...

Yikes!!!! Would describe my first reaction to seeing this tribute to Ronald Reagan. From the African American perspective, Reagan was hardly a president I could hardly get behind and support....

This method works as well but I can't get it to work within a cursor. Any ideas on placement?

I get an error stating:

Invalid length parameter passed to the substring...

Ended up finding out the solution. Use Ltrim, which works only for leading spaces but by using replace with an empty string. Ltrim is able to kick into action by...

Ended up figuring it out myself. Changes are in red.

WHILE  @counter <= @Max_srch_id

BEGIN

  Select @cscd_srch_string = @cscd_srch_string+srch_val+Char(9)

   from ##srch_val

   JOIN srch_elmt_assoc on srch_val_id = srea_sche_id

   Where srch_val_id in (Select srch_val_id from ##Srch_val...

Here is the whole script for what will be the calling procedure. Area of interest is in red. This might clear things up so I cn get a reply.

DECLARE @counter   INT

DECLARE...