http://blogs.conchango.com/jamiethomson/archive/2006/08/24/4400.aspx

See last post here

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=54384

select min(type) from test?

Your code is also flawed!

What will do you when more than one record is updated at a time?

CREATE TRIGGER [dbo.CHECK_LINE_DEPT_Ins] ON [dbo].[CHECK_LINE]

FOR INSERT NOT...

If the column is Primary Key and other tables references it, no.

otherwise

ALTER TABLE Table1 DROP COLUMN

See http://www.sommarskog.se and read about "passing arrays".

Jeff was objecting to this you wrote

the recordnr has price more than a

and in this recordnr the recordline should be at least b?

What is a and

that would be

insert table1

exec mysp1

I think now is the time to provide some proper sample data and your expected output...

Clustered index has nothing to do with uniqueness.

I suggest you read about indexes in Books Online, just to refresh your knowledge a little.

insert table1 (col1, col, col3)

select 40000 + col1, col2 / 2.0, col3

from table1

where col4 < 33123

Do you have a clustered index on clientname?

Use LEFT JOIN instead of INNER JOIN.

You could try to post complete query, so we don't have to play guessing games.

SELECT

p.KPAIDS_NO,

p.FirstName,

p.LastName,

dbo.fnYearsApart(p