Hi

  The reason i was working on some alternate value is 'NULL' breaks the boolean logic.

 X & Y are NULL then,

 We have (x=y) evaluate to false, now

 (X!=Y)...

Hi

Ohh..Sorry..I haven't seen that part..Anyway Logic Jesper suggested is also good.   

Hi ,

Try this logic..

 Select ID, Startdate, EndDate

 From PerodPossible PP inner join  PeriodUsed PU

 on  pp.ID != PU.ID  and

 PP.Startdate  not between PU.startdate and PU.Enddate  and

 PP.EndDate  not between...

Hi All

This seems to be very much simple than expected...  

alter table xyz add rownum bigint null

DECLARE @a BIGINT

SET...

Hey

   Thanks for solution, This is working for me but it takes long time (41 sec to insert into temp table on 3Gb, 3 GHZ machine, and then join...

Hey Jeff

 I have similar requirement, so as to generate rows from 1 to n to an existing table but the new column to added shall not be with Identity property Any...

go though this document.

 http://vyaskn.tripod.com/passing_arrays_to_stored_procedures.htm 

Regards

shrikant  

Hi

  In trace Properties Select "Show all Coumns" Check Box, DataBaseId and DataBaseName are  column no 15 and 16.

Regards

Shrikant    

Hey.

  Which version you are using..Anyway try this ... In the management Studio.. Go tools->Options--Enviornment Tab->General. there is check box "Hide System Objects in Object Explorer" . Ensure that yoh have not checked...

Yes, I did some r&d on the same. its Common Table Expression (CTE) a new feature in Yukon. As far as documentations says this gives better results than Select .....

Thankx

Hey

   Can u summerize what you have done and ur observations on it ? I am little confused

Regards

Shrikant