"There are only 10 types of people in the world: those that understand binary, and those that dont."

That's my all time favorite... with the colt 45 - original point and...

Just don't select the data if you don't need it. Why would you want to do that?

(I would also suggest having the user create a Number table outside the SP to speed things up....).

Did you actually read the thing????

I'll think about posting it

# is visible only to the connection who created it and is dropped when the connection ends or when explicitly dropped.

## is visible by anyone on the server. It...

You need something like this :

IF Object_id('fnSplit_Set') > 0

DROP FUNCTION dbo.fnSplit_Set

GO

IF Object_id('Numbers') > 0

DROP TABLE dbo.Numbers

GO

CREATE TABLE dbo.Numbers (PkNumber int identity(1,1), dude bit null, CONSTRAINT Pk_Number PRIMARY KEY CLUSTERED...

Select case dtL1.One when '1' then 1 else 0 end as One, Case dtL1.Two when '-2' then -2 else 2 end as Two from

(Select case 1 when 1 then '1'...

Maybe this can help :

Dynamic Search Conditions in T-SQL

Can the user change its regional settings?

That's what he wants to avoid... I can imagine that case statement becoming verrrrrryyy long .

You're not missing anything... Maybe I'll send some coffee to aj .

Well maybe you can do it with 1 or 2 derived table :

Select case dtL1.One when '1' then 1 else 0 end as One, Case dtL1.Two when '-2' then...

oh sorry. You can't do this :

location = 'blad',

case when location...

The column doesn't exists at this point of the select.

I was reffering to that syntax that I thaught didn't work :

Declare @var as varchar(8000)

set @var = ''

Select @var = @var + name + ', ' from dbo.SysObjects where...

That'll work. But the next where condition will be executed later so the column will exist for that statement even if it doesn't exists in any of the tables...

And what's the DDL, sample data and expected results?