louise_8
asked on
sql - query returning no column name when name is specified
Hi
The following query is returning no column name when then name 'iOutDistributionid' is specified
niether
select *,@iDistributionid as 'iOutDistributionid' from #tmpDistribution
nor
select *,@iDistributionid as [iOutDistributionid] from #tmpDistribution
work
the data ie @iDistributionid is in each row ok
eg
customerid [no colomn name]
1 1
2 1
The following query is returning no column name when then name 'iOutDistributionid' is specified
niether
select *,@iDistributionid as 'iOutDistributionid' from #tmpDistribution
nor
select *,@iDistributionid as [iOutDistributionid] from #tmpDistribution
work
the data ie @iDistributionid is in each row ok
eg
customerid [no colomn name]
1 1
2 1
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
thanks
ASKER