WHERE CONVERT(VARCHAR,MyDateColumn,101) =

CONVERT(VARCHAR,DATEADD(dd,-1,GETDATE()),101)

It sounds like you need a left join. A left join will return all...

If restoring the Master resolved your issue, then you have setting that is different between instances. The Master database stores all system information for an instance. The meta data...

This link should help you.

http://ryanfarley.com/blog/archive/2005/02/14/1685.aspx

Unfortunately, I think the stored procedure will have to be modified. I would open the stored procedure and do a search for 'EXCL'. There may be 100s of lines,...

Sounds like you have an implict conversion that SQL 2000 did not mind, but 2005 is throwing a fit. SQL 2005 is a lot more strict that 2000 when...

Just putting a solution that is new to SQL 2005. It works the same way as not in, except nulls do not throw it off.

select id

from tblA

except

select...

I would like to also add that some of the best practice you can get is by helping others solve problems on sites such as SQL Server Central. Solving...

A pretty good source is w3schools. This site offers lots of differnent tutorials and practices, with easy to understand examples.

http://www.w3schools.com/sql/default.asp

Unfortunately, you cannot use the XML method or row number method in 2000. You should use a simple select statement to concatenate the string from you.

SET NOCOUNT ON

GO

create table...

Did you change the quotes? Post your code, as it stands now.

Your quotes are messed up. You have to put 2 single quotes around items the need to be in quotes. E.g. select ''adam''.

try this. I cant test...

Rbarryyoung,

Thanks for the reply :). My post wasnt meant to pick at your or say you were wrong. I misinterpreted your post by thinking that you were saying...

You can use XML to concatenate the results from the subquery. All you have to do is structure your subquery to look like the following.

You should keep...

This is somewhat true, system views should be used in most cases. The old school method to query tables you...