Hello Jan Van der Eecken,

Thanks for reply...

Actually already tried your suggested query when i begin with one new module. Actually the flow is like that - the end user select...

Hi Girish,

First-of-all thanks for reply..

Actually i use SQL Server 2000. so i can not use Table variable.

any ways, i use temporary table using yr solution. 🙂

Again thank u....

Hi,

Here is my table structure:

CREATE TABLE [dbo].[tblSubDomainOld](

[id] [int] NOT NULL,

[SubDomain] [varchar](500) NOT NULL,

[Query] [varchar](5000) NOT NULL,

[hostfrom] [varchar](500) NULL,

[chkloginhost] [varchar](50) NULL,

[status] [bit] NULL,

[AsQuery] [varchar](5000) NULL,

[UserId] [varchar](200) NULL,

[Password] [varchar](200) NULL,

[EmailId] [varchar](500) NULL,

[ContactUs]...

Hi GilaMonster,

This is perfect answer...I got it 🙂

Yes, its in the Option menu...

Thank u very much...

Hi,

Thanks for replying...

Here is the Error message that i got when i m changing the identity column to "Yes" and save the changes.

Saving changes is not permitted. The changes...

[font="Arial"]Hi,

I had read yr script and also implement it.

but can u explain me what is the benefit of timestamp column??

Thanks in advance..[/font]