thank you very much. i was also thinking about adding unique constraint. can i do while database is online line in production or we need to be offline.

thank

sagar

table structure is like this:

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING ON

GO

CREATE TABLE [dbo].[tblProjectMembers](

[ProjectMemberId] [int] IDENTITY(1,1) NOT NULL,

[ProjectId] [int] NOT NULL,

[ProjectMemberUserID] [int] NULL,

[JobTypeID] [int] NULL,

[Description] [varchar](500) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_tblProjectMembers_Description] ...

thank you very very much it is big support..

thanks again to all, i will post later later for my query and informatinon till then

happy great great weekend

sagar

Hi, It is seems to be very help full to trouble the issue.. i really thanks for that.

i also have have another question.. code is right below the text. what...

Thanks Everybody...

Sagar

code looks like below... also have another question as well... there are lots of temp table inside stored proc.. i was thinking of removing temp table and using table...