Try this:
SELECT IM_SERIALNO, IM_ITEMCODE, 'VALUE' AS @PRICENAME, IM_TAX
FROM ITEM_MASTER
WHERE IM_COMPANYCODE = @COMPANYCODE AND IM_BRANCHCODE =@BRANCHCODE
but i'm afraid about results...
'VALUE' AS @PRICENAME
gives you:
@PRICENAME -column name<br />
VALUE -row <br />
VALUE -row <br />
VALUE<br />
VALUE<br />
Is it OK?
[EDIT]
The following 'query' shows how to use variables
DECLARE @PRICENAME VARCHAR(50)
DECLARE @COMPANYCODE VARCHAR(50)
DECLARE @BRANCHCODE VARCHAR(50)
SET @PRICENAME ='BlaBlaBla'
SET @COMPANYCODE ='UV2UV2UV2'
SET @BRANCHCODE ='q57438954rh8o9f'
SELECT @PRICENAME AS 'PriceName' , @COMPANYCODE AS 'CompanyCode' , @BRANCHCODE AS 'SomeCode'
Result:
PriceName CompanyCode SomeCode<br />
BlaBlaBla UV2UV2UV2 q57438954rh8o9f<br />
To select dynamic column, use:
IF @PRICENAME = 'SomeValue'
BEGIN
SELECT [Columns1] ....
END
ELSE
BEGIN
SELECT [Column2] ...
END
You can use a
OBJECT_NAME[
^] command to return the name of column too.
[/EDIT]