That's it, Remi!  Glad I could help....  

Actually, we have found the flexibility of using this table extremely helpful - especially for odd...

     SELECT * FROM EmptyHalf

UNION

     SELECT * FROM BetterHalf

(assuming you are a guy asking a woman...) 

My vote is for sswords: "It's my parity, and I'll cry if I want to."    (I may change my footnote). 

  Sorry. 

I actually use one like that at work.  Once I get into the office I will look for it... (Remi, it...

I think this is it.  [Now, tell me what I did wrong in posting the link ]. 

IF EXISTS( SELECT * FROM dbo.sysobjects...

I would search this site.  You will find numerous answers just in the Discussion section. 

Here is one possible solution: <A HREF="http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=18554" target = "new">Possible Solution</A>

Remi also has a...

I have no way of testing this, but I did notice that DateTimeStamp, comment, and Weight are not selected within sub-select X.

Do you have Indexes on all these tables you LEFT OUTER JOIN?  Also, would it be quicker to make these LEFT OUTER JOINs their own Views as those are already...

Let me see if understand this.  Table 1 (which is the Primary table) has no record in it.  Table 2 (which is the Foreign Key table) has a record in it. ...

I'll be switched - I thought you did that.  Sorry for the confusion.

Agreed!  But with Newbies, it sometimes takes a little longer.  And sometimes, (more than I would want) "senior moments" happen to me too... 

But over all, you are right and...

In the Newbies section, that is a bit more acceptable.  But I've done that myself in the TSQL section and that is "clobber" time....  TGIF!!! 

Do you have a folder called Joe_LeninL?  Or is this just the name of the file within the folder Data?  You may need to drop the extra \' + @DbName...

You lost me on this posting.  Do you want to go from SQL Server to Sybase or from Sybase to SQL Server? 

Could you post the entire code?  [both the...

Me too.  I was trying to find out if this was a one to many relationship and where the problems might arise during an update... I should have been more...