thanks george sibbald for your information

thanks Alan Burstein,Gail Shaw for you feedback , my point was the same query will perform differently when i execute that in local pc and in server , i will...

Thanks beside sharing the folder and adding protection the problem was i initialized the secondary database manually and the restore state with set to restore with recovery .

solution:

change the restore...

thanks for your feed back jeff, since i already implemented the first solution provided when i received the code in my project just wanted to change that rather then...

ChrisM@Work (1/3/2014)

---

DECLARE @Result TABLE (Serial nvarchar(10),Title varchar(20))

INSERT INTO @Result

SELECT '1.1','a' UNION ALL

SELECT '1.2.1','b' UNION ALL

SELECT '1.2.2','C' UNION ALL

SELECT '1.2.3.4','G' UNION ALL

SELECT '1.11','B' UNION ALL

SELECT '1.2.33.4.5','Extra row' UNION ALL

SELECT '2.3','B' UNION...

thanks jeff for your reply , i will check this

thanks Michael Valentine Jones for you solution if you could find time please change your solution to example i provided above.

thank you very much chris for providing the solution.

yeah jeff as already answered to my similar query in here .

http://www.sqlservercentral.com/Forums/Topic1194903-338-1.aspx#bm1196064

but i can not reproduce in this example.

i think 5 element will be enough .

i tried this...

thanks chris for your reply . i need a recursive way to deal with serial hierarchy.

the problem is the serial can be like this.

DECLARE @Result TABLE (Serial nvarchar(10),Title varchar(20))

INSERT INTO...

thank you very much Sony Francis @EY,Eugene Elutin,dwain.c for your feedback.

the solution is to convert the column to varchar and run that inside subquery, hope it will help some one else with similar problem, now one more thing here left...

i have changed the my input and output and add date and comments to make it clear, for multiple entry with in a month it shall take the last entry.

declare...

the rule here is we have month no here.

1. check secondmonth amount

2. sum(second month amount) > sum(first month amount)

3. get the difference

4. difference is greater then sum(first month amount)...

Just the bold part i didn't get does it depend on number of levels or any other thing and the conversion of hierarchypath to binary why it is required?

WITH

cteSplit...