just for your help mate..

this is the solution 🙂

where

(ISNULL(@status, 0) = 0 AND cpa.UseAccountNumber IS NULL)OR

(@status = 1 AND cpa.UseAccountNumber...

it doesnt work. But its ok I will manage this in code. 🙂

Alter procedure [dbo].[Application]

@forename varchar(50),

@surname varchar(50),

@status int,

@origin int,

@pagenumber int,

@pagesize int,

@sortexpression varchar(32),

@sortorder varchar(4)

as

if @pagenumber < 1

begin

...

sorry for being a mess.

ok someting like this

Alter procedure [dbo].[Application]

@forename varchar(50),

@surname varchar(50),

@status int,

@origin int,

@pagenumber int,

@pagesize int,

@sortexpression varchar(32),

...

when I write status = @status it complains Invalid column name 'Status'.

Thanks for your reply. I figured that out but how to I filter my result with @status parameter in the where clause?

you are write. I have changed the code now 🙂

I have an application where a user can upload the file to a directory. Coz the requirment of the user was only one upload first. I did the upload in...

create table mytable (id int identity(1,1), PersonID int, Unit varchar(10))

insert into mytable values (1,'Che')

insert into mytable values (1,'Mat')

insert into mytable values (1,'Phy')

insert into mytable values (2,'Che2')

insert into mytable values (2,'Mat2')

insert...

thanks i used the comma seperation and worked out the code in c# to get the desired result :).

i can't do it like that..

create table mytable (id int identity(1,1), PersonID int, Unit varchar(10))

insert into mytable values (1,'Che')

insert into mytable values (1,'Mat')

insert into mytable values (1,'Phy')

insert into mytable values...

Thanks for your reply, however i think i did not explain my self correctly.

I need multiple row in one column..

so instead of having seperate rows for UNITS column I just...

cool thanks 🙂

i figured it out myself

if exists(select pid from abc where fid = @fid and pid <> @pid)

begin

if exists (select pid from abc where pid = @pid and fid =...