Actually, come to think about it, at this point, non will be different. At this point, I just need to know, which course has been schedule, but hasn't been...

That is very close. If I set all three units intro, recorded, edit_av, sd_transc, and md_bounced to 0, then it should return. If any of those are set...

Chris,

Thank you very much for your help. I wasn't trying to tell you to hunt for the data or anything, I thought that I had posted a detailed response...

I had posted my table structure. I...

Here is sample data from the SNP_media table:

INSERT INTO SNP_media

(crsunit_id

, intro

, recorded

, [time]

, md_bounced)

VALUES

('1'

, '1'

, '1'

, '16 min'

, '1')

INSERT INTO SNP_media

(crsunit_id

, intro

, recorded

, [time]

, md_bounced)

VALUES

('2'

, '0'

, '1'

, '24 min'

, '1')

INSERT...

That still isn't working. Here is the table structure of the three tables that I'm joining together:

/****** Object: Table [dbo].[SNP_crs] Script Date: 01/24/2010 15:05:24 ******/

SET...

Completely understand; however, with the economy, there is no training money this year!

GOD BLESS YOU ALL!!! It finally works!!! This is the code that I used, thanks to Gail!!!

declare @unitid varchar(16),

...

Sorry, I was selecting D1.RowNum at the top and then D1.RowNo at the bottom; however, when I fixed that, I still have the same results. Once again, I'm so...

Ok, so when I do that, then I get all those no column was specified. I'm very sorry to be such trouble. I'm trying to learn and get...

Sorry, I didn't see the from sys.tables, let me try that!

This project is almost becoming more trouble than its worth, but the boss wants it done. So, I added the SELECT 1 to my order by statement and now...

Well, I'm trying to run just the query to see the results, prior to doing the insertation; however, I'm getting an error that says" Msg 5308, Level 16, State 1,...

The application will never be entering these records at the same time this query is going to run. Basically, I'm going to create this as a stored procedure that...

Oh, how I wish I could do that. The way I'm entering these records isn't the normal process, there is an application that normally enters these records. I'm...