There is nowhere near enough information here to provide anything resembling an answer. What type of...

Perfect.

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.

That is a great phrase Joe!!! Relevant to both SQL and marriage. 😛

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

PFlorenzano-641896 (10/12/2012)

---

Hello,

Here is my situation; I have a stored procedure that will be executed 'ad-hoc' as a report. The stored procedure has several temp tables being executed and does...