randmatt (11/7/2013)

---

One more try -

WITH DirectReports AS

(

SELECT

e.ManagerID

,e.EmployeeID

,e.Title

,0 AS LEVEL

,cast(e.ManagerID AS varchar(MAX)) AS [path]

FROM dbo.MyEmployees AS e

WHERE ManagerID IS NULL

UNION ALL

SELECT

e.ManagerID

,e.EmployeeID

,e.Title

,LEVEL + 1...

randal.matthew (11/7/2013)

---

If I understand the question - this should get you a path - you may want to modify the ordering etc.

WITH DirectReports AS

(

SELECT

e.ManagerID

,e.EmployeeID

,e.Title

,0 AS LEVEL...

thanks for the clarification.

Is is...

this is the message i'm getting The text for object 'procname' is encrypted.

We are handling this from frontend ..if any error comes we rollback and divide the number of rows and insert it...so this process will go on until all the...

Erland Sommarskog (9/2/2013)

---

Unfortunately, this is one of the drawbacks with working set-based. If you insert rows one a time, finding the bad data is trivial. But that is of course...

finally got it ..its a silly mistake...i am always trying to run the application by right clicking Run as Administrator..i tried directly and it takes mixed mode authentication

Hi simon, i tried both solution...still it is not working.

yes..sa user is disabled and when i check the authentication mode it is WINDOWS

Great article, looking forward to the next article

Thanks gail for the reply..let me go through the article

I am planning to pass the condition as a table value parameter, each row...

Thanks a lot eugene..this is what i actually want

dwain.c (3/11/2013)

---

I have a question about group #2. Shouldn't it actually be two groups:

Group unit

1 ...

thanks chris for the reply

can you tell me the use of SELECT TOP 1 n=1 ....i never use this

CREATE TABLE #Test

(

ProductID int,

MainMasterFeatureID int,

--MasterFeatureValue Varchar(100),

ChilFeatureName varchar(100),

ParentFeatureName varchar(100)

)

--Inserting Sample Data

INSERT INTO #Test

SELECT 40,1,'Pack','Type'

UNION ALL

SELECT 40,0,'Laminate','Technology'

UNION ALL

SELECT 40,11,'Yes','Coated'

UNION ALL

SELECT 52,1,'Roll','Type'

UNION ALL

SELECT 52,11,'NO','Coated'

CREATE TABLE #tProduct

(

...