Select only column name from an sql query

Question

As an example I have this query here

SELECT DISTINCT convert(varchar(10), PickupDate ,105) AS [Pickup dates]
FROM info.dbo.A_Query_Detail AS D
INNER JOIN info.dbo.A_Query_Header AS ACQ on ACQ.ID = D.Header_ID
WHERE D.HeaderID = @HeaderID 
AND ACQ.PriceType = 'Pickup'
GROUP BY 
Adrid, convert(varchar(10), PickupDate ,105)

What I want to get here is only the column name without it conflicts with the above query. So my result would be something like: "Column_Date" or Pickup dates as stated above. I have red something about sys.tables but I can't seem to make it work with the above code.

I don't really get your question, you'll have one column, called [Pickup dates] and it will be VarChar(10). — Jodrell
– Jodrell, Commented Nov 13, 2014 at 12:34
This is not volatile data, its predictable unless you use *. — Jodrell
– Jodrell, Commented Nov 13, 2014 at 12:42

Gordon Linoff · Accepted Answer · 2014-11-13 12:30:50Z

3

If you want a list of columns, sometimes I use a temporary view:

create view _MyView as <your query here>

Then you can do:

select *
from information_schema.columns
where table_name = '_MyView'

You can get the column names and types by doing this.

Then you can do:

drop view _MyView

(And, of course, the view name should not conflict with anything else.)

answered Nov 13, 2014 at 12:30

Gordon Linoff

1.3m62 gold badges706 silver badges857 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

pancake Over a year ago

Thank you gordon I will try this and get back to you!

Jodrell Over a year ago

@MishMish, if you have to specify <your query here>, why not do my answer? stackoverflow.com/a/26909275/659190

pancake Over a year ago

@Jodrell your answer is also good but have not tried it, actually the whole solution need to be changed anyways, It's more advanced then I thought I might upload a new question for help later. It's a bit complicated :-)

Community · Accepted Answer · 2017-05-23 12:12:43Z

1

try this,

SELECT 'Pickup dates' AS [ColumnName];

this is like @Gordon Linoff's answer but doesn't carry the overhead of creating a view.

edited May 23, 2017 at 12:12

CommunityBot

11 silver badge

answered Nov 13, 2014 at 12:48

Jodrell

35.9k6 gold badges94 silver badges131 bronze badges

Collectives™ on Stack Overflow

Select only column name from an sql query

2 Answers 2

3 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related