declare @datetime table

(EmpID int ,

WrkdTime datetime

);

insert into @datetime

select '12','2010-09-01 10:06:00.000' union all select '12','2010-09-01 10:11:00.000' union all

select '12','2010-09-01 10:16:00.000' union all select '12','2010-09-01 12:11:00.000' union all

select '12','2010-09-02 10:00:00.000' union...

declare @tbl table

(

ID int ,

NAME varchar(max),

STATE varchar(max),

[E.MAIL] varchar(max)

);

insert into @tbl

select 1,'JAMES',NULL, NULL union all

select 1, NULL ,'CA', NULL union all

select 1 ,NULL, NULL ,'abc@hotmail.com' union all

select 2,'steve',NULL,...

declare @tbl table

(

ID int ,

NAME varchar(max),

STATE varchar(max),

[E.MAIL] varchar(max)

);

insert into @tbl

select 1,'JAMES',NULL, NULL union all

select 1, NULL ,'CA', NULL union all

select 1 ,NULL, NULL ,'abc@hotmail.com' union all

select 2,'steve',NULL,...

create procedure usp_Returnadd(@Address varchar(max))as

begin

insert into tbl

select newid(),@Address

WHERE not EXISTS

(

SELECT * FROM Tbl ...

declare @products table

(

price int identity(1,1) primary key,

product varchar(30)

);

INSERT into @products

Select 'toy' union all

Select 'toy' union all

Select 'toy' union all

Select 'toy' union all

Select 'game' union all

Select 'game' union...