Hi good Sir

thanks for doing the string split function. i would like to kindly ask if you have a sample code for my scenario below;

Column 1 = ID

Column 2 =...

thank you sir. can i ask you one last favor?

can you tell me how to construct a dynamic where clause statement

(@columnname = @columnvalue)

thank you very much

N.O.E.L.

I am constructing a dynamic sql statement that's why i am using a Coalesce function in sql. i was trying to achieve the following

set @id = '1','2'

set @name = null

select...

i would like to kindly ask if we can incorporate a Coalesce Function inside a where in clause ?

Thanks

I'm using this code sequence but i still get all the results i need instead of the ones i have selected in the report manager

/*****************************************************/

set ANSI_NULLS ON

set QUOTED_IDENTIFIER ON

go

ALTER Proc...