Cannot call methods on bigint.

See more:

SQL

.NET

server

wat does dis error mean.I have a procedure executing t-sql statement and when I execute the procedure I got this error.
I have a method being called in the select list I tried commenting it and executing but still I am getting the error.
My proc is some what like this.

create proc test
(
@a char(1),
@b char(1),
@c char(1)
)
as
declare @sql varchar(max)
set @sql='select p.col1,p.col2 from('
if(@a=1)
begin
set @sql+='select col1 ,col2 from a union '
end
if(@b=1)
begin
set @sql+='select col1 ,col2 from b union '
end
if(@c=1)
begin
set @sql+='select col1,col2 from c'
end
set @sql+=')p'