tudorn (1/6/2013)

---

Hi Sean,

Sorry I did not replied to you earlier.

The two posts/links that you recommended were very good and helped me a lot to create the reports I needed.

Thank you...

You're welcome Ram.

But just to keep you thinking.....how is your on performance??

The following is the edited version of my query which gets you the results :

Declare @table Table(ClockID...

dwain.c (1/23/2013)

---

vinu512 (1/23/2013)

---

Umm guyz.....This is my try at the requirement......Is this close enough??.....I used the tally CTE to create dynamic sql for the nested replace statements :

Declare @string Varchar(max),...

Umm guyz.....This is my try at the requirement......Is this close enough??.....I used the tally CTE to create dynamic sql for the nested replace statements :

Declare @string Varchar(max), @sql Varchar(MAX)...

I think this is what you are looking for :

Declare @table Table(ClockID Int, EmployeeID int, punchTime DateTime, punchType Bit)

Insert into @table

Select 8,769,'2013-01-22 14:26:35.590',1

Union ALL

Select 9,769,'2013-01-22 14:46:59.363',0

Union...

The following link would get you the answer to that question :

Difference between Database and Database Instance

Hi...its good that you spent time on explaining you requirement...but I am still having problems with understanding it, as there isn't any sample data to see what you are actually...

Hello again guys.....how are you doing?

The query is working perfectly fine. I have implemented the query and tested it for a tree having sub trees till the eighth level.

Peter,...

Thank You very much Peter. 🙂 Your solution is working very well....Let me do some more testing and will get back if something's missing.

Thank you Dwain for all your...

I modified your query a little....just to see the levels and the root columns and removed the dates as follows:

;WITH ModuleHieararchy AS (

SELECT SModuleId, ModuleId,...

Hi Dwain,

I don't think your query would work if I change the data a little.

Try your query with this new data:

Insert Into ES_SubModuleMaster

Select 1,1,'Academic',2013-01-01 00:00:00.0002013-01-04 00:00:00.000Start0

Union...

Hi Anthony,

Thanks for the reply........the data I posted earlier is actually the order in which the tree is supposed to be ordered. I was thinking that I could get...

The above solution still wasn't complete....it wasn't getting the sub trees randomly and not in any particular order....I...

Thanks Guys....

I got it to work using the following Recursive query :

;With RCTE

As

(

Select SModuleId,ModuleId,SMName,

Convert(char(11),SDate,106)as SDate, Convert(char(11), SDate, 103) as ddmmyyyySDate,

Convert(char(11),EDate,106) as EDate, Convert(char(11), EDate, 103) ...

SQL006 (1/14/2013)

---

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

...