Eskandari (10/12/2012)

---

in a field of a table ( with nvarchar data type) we have about 10000 data,some of them are integer - from 1 to 1000- and other are string;

I...

Hi and welcome to SSC!

Unfortunately you have not provided enough information for anybody to be able to help much. We can't see your data or the results. Without something to...

LOL just a lot simpler way of getting the same thing. 😀

sqlSer12 (10/12/2012)

---

Table looks like below. For Ex. row 3, Id_task = 3, level_task=3 menas it is at level 3, id_fathertask = 2 that means, its parent is the one which...

vikingDBA (10/11/2012)

---

I know some will cringe, but here are some UDF's that I have created for this type of manipulation. When you are in a time crunch, they really...

But what have you tried? I have to agree this looks a...

This has to be one of the strangest processes I have ever seen. You have a table to record the rowcount from every table. Why? It will always be out...

Can you post what you want for desired output? Just create a temp table and hard code inserts into it. I can't understand your explanation very well and the data...

That...

I am guessing that you didn't read through the article I suggested and understand this code. You can't reference the cte by multiple statements after it is declared. You need...

Cheryl McLaughlin-385812 (10/11/2012)

---

It works too a point, but it pulls all the records. If I substitute @Ord_Nbr ='12345' the script still pulls all the records and not the record that...

where order_nbr = isnull(@Ord_nbr, 'xxxx') maybe????

This is a running total problem. Jeff has a great article about it here. http://www.sqlservercentral.com/articles/T-SQL/68467/%5B/url%5D

If you can't figure out how to put that all together post back here. In order...

Thanks for ddl and data. Makes this a lot easier.

Your data structures don't allow for anything like a join because there is nothing to tie a status to a phase....

a4apple (10/11/2012)

---

Sean Lange (10/11/2012)

---

Please help me with the sql code.

All of them are Varchars (Status and Phase even though they look like Integers).

Please don't ask me to change my Datamodel.....