waqqas.zia (10/9/2012)

---

Thanks for the reply Sean,

Unfortunately due to data protection issues im unable to post any of my data or even samples of...

i have however found a work around,

Thanks...

No it doesn't depend. It may appear to be ordered correctly right now but there is no guarantee it will always be in the correct order. If you want ordered...

Can you post ddl (create table scritps), sample data (insert statements) and desired output based on your sample data? I think once we can see the problem and have something...

Better yet, remove it entirely. It is not a magic...

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