ok. let's start over 🙂

the object of my task is to do the following:

get all records that were not modified.

if 2 files or more have the same name we are...

thnx for the help but that didn't work

insert into MyTable (file_desc, is_modified) values ('a.txt',0)

insert into MyTable (file_desc, is_modified) values ('a.txt',1)

insert into MyTable (file_desc, is_modified) values ('b.txt',0)

insert into MyTable...

sorry this is the correct code

CREATE TABLE [dbo].[MyTable]

(

[rec_index] INT IDENTITY(1,1) PRIMARY KEY CLUSTERED,

file_desc...

ok, i added this code fro creating and inserting values to the table

CREATE TABLE [dbo].[MyTable]

(

[rec_index] INT IDENTITY(1,1) PRIMARY KEY CLUSTERED,

...

CREATE TABLE [dbo].[MyTable]

(

rec_index INT IDENTITY(1,1) PRIMARY KEY CLUSTERED,

file_desc nvarchar(50),

is_modified bit

)

this is my table.

now...

This is very simple to do. How about setting up a little sample data to test the code against? One of the links in my sig will show you how...

thx for the reply.

wasn't familiar with the BOL option.

🙂