SQL Query with Order by Strings

Question

dim Symbol_Val as string

I put my preference in entering the stocks according to my order in symbol_val

For example

Symbol val="stock1,stock2,stock3,stock4,stock5,stock6,stock7,stock8,stock9"

Then I execute the query

"Select Symbol, trade_date , sec_close,volume from stockPrice WHERE symbol in (" & Symbol_Val & ") and NO_OF_RECORDS= (SELECT max(no_of_records) FROM stockPrice_Alert) ORDER BY" & Symbol_Val

When I execute the query I am not getting the records as per my preference can anyone tell me what the query is required to be execute in SQL?

Gordon Linoff · Accepted Answer · 2015-10-08 11:29:50Z

1

One method is to use charindex() to find the value. A simplistic method is:

Select Symbol, trade_date, sec_close, volume
from stockPrice
where symbol in (" & Symbol_Val & ") and NO_OF_RECORDS = (SELECT max(no_of_records) FROM stockPrice_Alert)
order by charindex(Symbol_Val, val)

It is better to take the delimiters into account:

order by charindex(','+Symbol_Val+',', ','+val+',')

answered Oct 8, 2015 at 11:29

Gordon Linoff

1.3m62 gold badges706 silver badges857 bronze badges

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

1 Comment

SYED Over a year ago

This charindex function is not recognized by sql 6

Collectives™ on Stack Overflow

SQL Query with Order by Strings

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related