when I run installation as upgrade getting below errors , However I am a admin user.

"TITLE: SQL Server Setup failure.

------------------------------

SQL Server Setup has encountered the following error:

Access to the path...

Can you please share the steps or weblink to upgrade it

Thank you Eirikur for the optimized solution.

Thank you Twin.

yes, It will help me . I will try to write a query as per requirement.

I have written the query . Need to take care of few things as per requirement.

DECLARE @PathName VARCHAR(256)='E:\abcd\' ,

...

No where SomeCondition..

need to delete all the records without logging the individual row deletions in tranasaction log

Thanks

Thanks for the help .. Here I have added few more records to the temp table

CREATE TABLE #Source

(

Id int identity(1,1)

,categoryint

,Leaf_Node_code varchar(10) --

,Level1_Name varchar(20)

,Level2_Name varchar(20)

,Level3_Name varchar(20)

,Level4_Name varchar(20)

,Level5_Name varchar(20)

)

INSERT INTO...

Thanks for you query, but it is not giving the correct Parent_ID if I add more rows under category 2(or any) to the temp table ..

SELECT 2,'104','c','cc','ccc','cccc' , null

I...

yes FunkyDexter , you're correct .. I am looking for the solution

FunkyDexter (4/3/2013)

---

The way I'd read the requirement is as follows:-

Qty is, well, a Quantity.

Aging Stock is a...

I am a little confused by where the logic comes from. I don't quite get what you are trying to do. I don't get why you have 3 rows now...

Input rows:

days Qty [Aging Stock] priority

269 285 305 1

287 30 300 2

output:

269 285 305 1 ...

I edited the main post .

Sean Lange let me know till if it not clear .. My english is not so good

Here is the logic:

select '11003291001-----NOB30000','0V003','A00A00',269,285,305,1 union all

select '11003291001-----NOB30000','03003','A00A00',287,30,305,2

output:...

Thanks for sharing me the very worth full article

Could you help me to get the output like below :

groupid description

2 Hat

3 Mens Sweater

4 NULL (this is null because the...

Thanks Chrish , Can you give me the DelimitedSplit8K function defination