Hi guys,  thanks for all the help.   I fiddled around with it and the query is "working"...meaning it is giving me no errors, but it is not returning any data. ...

Remi,

Oh ok,

This query(combination of queries) is for an ASP webpage.  The page will display information from the schoolrequest, diaryentry, and academicoffice tables.  The schoolrequest table has 3 columns that contain...

I'm not sure exactly what you wanted, but here's the sql script to create the table:

CREATE TABLE [dbo].[diaryentry] (

 [DEid] [decimal](5, 0) NULL ,

 [DEentryTypeID] [varchar] (6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

 [DEkeyValue] [decimal](4,...

Wow, I think that works for at least some of the queries! 

  But that still leaves me with the last query

(SELECT * FROM diaryentry WHERE diaryentry.DEkeyValue=10

AND diaryentry.DEdeletedDate IS NULL)

...how...

I just used that so I can keep writing AND queries(because 1 will always equal 1)....I guess it does seem like a strange way to approach it.

Yeah, I figured that out Remi. Thanks for your quick responses....

Thank you Ten Centuries(cool name btw)...but the reason I need the above code is because I am using the #temptable as part of a larger query.  Specifically....

SELECT...