Your data structure for this is going to cause you nothing but grief. How do you know what the "root" of the task is?

This is a running total type of...

Ahmed_07 (10/9/2012)

---

okay hear me out... first 🙂

I Wanted to create a view with Order By clause so that the view to be ORDERED when I 'll use SELECT * query...

As previously suggested you should run a trace to see what actually hits your server.

Also, you did such a great job protecting yourself from sql injection EXCEPT for the querystring....

Is that a table? In your original post you did not mention that table.

And fwiw you...

Oh holy cow of embarrassment....You are on a 64bit machine and trying to setup a DSN to a 32bit machine right? The DSN utility on a 64bit machine creates a...

vinay.varaala (10/8/2012)

---

leave about that

in below query how to pick up only product code 'C'

select 1, 'UNLEADED', 'ABD00C', 'C', 'ULOOPPM', 5532.00 union all

select 2, 'UNLEADED', 'ABD00H', 'H', 'ULOOPPM',...

Is this a report? If so, a calculated field would be easier.

If not, there are a few ways to deal with this. They all involve the basic premise of:

select...

vinay.varaala (10/8/2012)

---

I had one more table called Cost_PID in that one column having Cost I joined this with Product.

SELECT

p.Prd_ID,

p.[Product_name]

...

vinay.varaala (10/8/2012)

---

alright

I will explain it clearly from that first table unleaded product I want to sum up based on codetype like c,h and l.

output should be in 3...

Yes at that point all the data is on the client. Run a trace while running that code. It will not run a new query when you read the next...

Hi and welcome to SSC. What you have posted as desired output looks more like a report then the results of query. You have column group headers and column names....

From what you have posted nobody can offer much help. The description is pretty vague and there is nothing to work with. Please see the first link in my signature...

Don't shrink tempdb. You are asking for problems doing that. You can end up causing yourself all sorts of problems.

Here is one link that refers to the issues.

http://support.microsoft.com/kb/307487

http://sirsql.net/blog/2011/5/18/dont-shrink-tempdb.html

Search around for...

Now for the mechanism you suggested to work robustly it would depend on the sql server client being able to verify back to the server that it has received the...

You have...