Give some other table name as the alias for the nested table (lets say tli2)

U mean to say this is also giving the same error?

SELECT c.claimnumber AS claimnumber,

tli1.UpdateTime as TranLineItemUT,

FROM...

Not sure if I am overlooking this, the last 'ON' cluase is,

ON c.ID = t1.ClaimID

Dont you think it should be tli1 instead of t1 in t1.ClaimID?

Ohh sorry, you cant...

Just to add to what Ian is saying, T-SQL supports two join syntaxes, SQL-89(with comma) and SQL-92(ANSI-SQL-92 compliant) (Inner Join). I think both of them are supported in SQL SRVR...

Thanks Winash, that was really helpful.

I assume...

winash (8/21/2009)

---

I haven't really seen the database field being empty for T-SQL job steps. Even if you create a job via T-SQL commands and don't provide the @database value I...

Do you have any unique key for the table?

hi,

I got what you are trying to achieve. I am not sure if I can give any solution to the problem with your approach, but a small suggestion in...

Hi ,

Just a wild guess, did not try reproducing it.

I think since we dont have that 'Set NoCount ON', after every select the message about the number of rows...

Yeah, it could be the reason that your RID entry with minimum date is getting filtered out because of that criteria and third table join.

P.S:Moreover if not in this...

IS there any unique id between Tomato soup- chicken, green salad-Fish, and Medit salad-Ribs?

Yes, you should be able to install it. I think there is some concept called side by side execution where you can run both 2000 and 2005

Hi,

Sorry not a solution.. in case if it rings any bell to anyone who looks at this post..

BOL defn of default schema on SQL Server 2000 and SQL Server...

Hi,

Just a thought at a very higher level..

select '(5) - ' , * from tv

by default, tv will be searched under 'dbo' schema if we dont mention the...

Hi Koneru,

U gotta give table definitions if any, data insertion scripts (test data),the query you are writing, the ouptput and the desired output.. for any kind of help here....

florian.reischl (3/7/2009)

---

Hi Mohit

No, they are not always same. If you use a LEFT JOIN the criteria within the JOIN part will only be used to restrict the right side.

I extended...