April 24, 2009 at 9:00 am
SQL 2005
I have 2 columns (rate and QTY) that I use to create a total column. How can I display just the total column in my results view?
Thank you
April 24, 2009 at 9:49 am
What are you doing now to show the results view? If you write a query in a query window, you can select the columns you want to show and leave out the columns you don't want to see.
My guess is you are using the Open Table/View functionality - which you really should not do since it is broken and has been removed from SSMS 2008.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
April 24, 2009 at 11:07 am
here is the part of the script that I am trying:
when I run the script and view the results in the view grid I would like to only see "Budget Amount" but im not sure how to restrict what show in the view. I currently see Itemprice, Budgetquantity and Budget Amount
(ri.itemprice*riq.budgetquantity)as 'Budget Amount'
Thank you
April 24, 2009 at 11:11 am
It might be as simple as removing the columns from the SELECT list.:-)
(If I read your question properly).
The code would help.
---------------------------------------------
[font="Verdana"]Nothing is impossible.
It is just a matter of time and money.[/font]
April 24, 2009 at 11:14 am
How are you showing the results view? Is that in some application that you have, or is this in SSMS? If this is in SSMS - and you are right-clicking and selecting open I suggest that you don't access the view this way.
You should open a new query window and type in the following:
SELECT {list of columns you want to see}
FROM YourView
WHERE {some filtering criteria to limit the data returned}
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
April 24, 2009 at 11:17 am
Yes..you are correct....thats a big duh on my part. Thank you
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply