I think one problem one can have with this solution is Excel's limit of 65,535 records.

this is very useful, however i would like to adapt it to a subquery. shown below with bad syntax. any hints? thanks

SELECT

[HQID]

, ID

, [Description]

,[ItemLookupCode]

,[SupplierID]

,(select Suppliername from Supplier s where s.ID...

Well the if/then or Case method is fine.

I was just curious about the EXISTS() function. Aparrently the ways in which you can use it are limited by sql syntax....

Michael Earl (9/27/2007)

---

Your check constraint is being evaluated after the data is put into the table, so the function is returning 1 because you have added the record. Make...

/*

almost! although that IS brilliant code. i can say that because i don't understand it 😉

I believe I have not defined the challenge clearly enough. let me retrace the steps:

*/

--the...

Garsh, spoke too soon. Back to the drawing board...

--add a couple more test records

insert into sbssm.eventsegment (StartTime, EndTime, Activity_ID, Location_code) values

('2007-09-24 15:00','2007-09-24 16:00',2,'PL3')

insert into sbssm.eventsegment (StartTime, EndTime, Activity_ID, Location_code) values

('2007-09-24 18:00','2007-09-24 19:00',2,'PL')

GO

-- EUREKA! this seems to do the...