http://msdn.microsoft.com/en-us/library/ms181154%28v=sql.105%29.aspx

prathibha_aviator (10/15/2012)

---

For the same data Provide the SQL statement that would return every CustomerName and the count of orders they have ever placed.

I have tried using the below code

select...

Take a look at Grant's article here. http://www.sqlservercentral.com/articles/Backup+%2f+Restore/recoverytoapointintime/1914/%5B/url%5D

That should have an answer for you.

You can't see it in SSMS. The most it will return is 65k. If you need more text you need to use another application.

--edit--

Just realized you are asking about...

Thanks for the ddl and sample data. I assume that the status column in cropresults should be a datatype int?

Can you explain the logic for the output? It seems that...

Or even better, change the column type so you don't have to continually fight the fact that you are storing numbers in a character column.

See if this article can help. http://blogs.msdn.com/b/sql_protocols/archive/2005/12/22/506607.aspx

The best thing you can do is to Dispose of the connection object as soon as you are done with it. This can be handled in code a number of...

Your calculation seems have changed since your first post?

21 20 5 6 10 Task 1.5.1.1.1

I am trying to create a recurive function.

Calculation starts from the bottom

(5*6)+10 = 40

it goes...

OK one more time, can you post this as inserts to a temp table so I can actually read it? And again what are the values you would pass in...

Can you post the table with the intermediate amounts? It is very unclear what you are trying to do here. Given the procedure you created what would be the values...

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...