How to make this select query execute?
select xyz,(exec dbo.GetCount 2)as abc from A
......................................................
dbo.GetCount is a storeproc which return a single value. I want to execute proc in a select query.
Is it possible? If not then please suggest me some another option.