How about something like this?

Declare @Table Table (OrderNo int, [LineNo] int, Product varchar(50), Result varchar(50))

Insert Into @Table

Select 1,1, 'ABC', NULL UNION ALL

Select 1,2, 'XYZ', 'Requires Review' UNION ALL

Select 2,1, 'FooBar',...

There are a couple of ways you can do this. Here is one example.

Declare @Table Table (id int, color varchar(10))

Insert Into @Table

Select 1, 'red' UNION ALL

Select 1, 'blue' UNION...

Based off your example you could run a query like this. However, this would pull back all the data from both tables and as you said the data is...

The EXCEPT and INTERSECT operators can also help you compare data between two different queries. They provide a pretty easy way to compare data.

http://msdn.microsoft.com/en-us/library/ms188055.aspx

GilaMonster (4/25/2009)

---

Ken Simmons (4/24/2009)

---

You may be able to use a third party transaction log reader to track it down. I have used Apex Log Reader in the past to...

This article will help you identify the long running jobs. Although, you should probably do some more troubleshooting and look for any blocking before restarting SQL Server. You really...

You may be able to use a third party transaction log reader to track it down. I have used Apex Log Reader in the past to find out who...

Your table has a defualt defined that will never work. What a default will do is if you do not specify a value for a column (which you are...

If the hex column is nchar(10), something else must be going on to cause the error message. For example, the code below works in the scenario described. Do...

Service Pack 2 in the @@Version query is referring to the Operating System not SQL.

Do you mean the databases are attached to a SQL Server 2008 instance using 80 as the compatability level? I have never tried this if that is the case,...

You can use the built in reports. They kind of resemble the TaskPad view from SQL 2000. Right Click the database, Select Reports -> Standard Reports -> Disk...

You can use the generate scripts wizard. Here is an article that describes how to do it.

http://www.devx.com/dbzone/Article/40531

The data being passed in must not match for some reason (spaces or something). You may want to try to do an LTRIM on the prefix to make sure...

I don't see you converting those in your function. Did you post a trimmed down version? If not, you need to add those to the case statement.