declare @lyn bit
set @lyn=0
create view vew_mst_led as
select  @lyn as YES_NO ,cled_name,cled_code,nled_type,nled_bal from mst_led 

quote:

---

Originally posted by visakh16

you can use variable inside view like this. you need to include value as a constant or use procedure instead.

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

---

create proc vew_mst_led 
@lyn bit=0
as
select  @lyn as YES_NO ,cled_name,cled_code,nled_type,nled_bal 
from mst_led 
go

quote:

---

Originally posted by visakh16

you need to write it as a procedure if you want to use variables like this

create proc vew_mst_led 
@lyn bit=0
as
select  @lyn as YES_NO ,cled_name,cled_code,nled_type,nled_bal 
from mst_led 
go

Thanx sir.

But wud it be a 'view'. I wish to use VIEW for different purspose.

Please
------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

---

quote:

---

Originally posted by visakh16

you cant have a variable inside view. view is just a virtual table with definition. you cant make it interactive by adding variables etc.
for that you've to use procedures like what i've shown.
Who suggested you to use view for above scenario?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Thanx sir.
There was a confusion with Temp Table VS. View. I was taking view table as tmp.
Sorry for troubl.

Very very thanx for your reply to make me understand.

Nice.

Hope 2 c again.

---