Oh thank you very much! I now see exactly what your talking about and of what your query is stating. The problem I have is I know functions of the...

So I went and updated my query a bit. Am I on the right track?

CREATE TABLE tCAR

(

CAR_ID int Primary Key Not Null IDENTITY(1,1)

...

I cant incorporate that extra 'where' in my where clause

CREATE TABLE [dbo].[tlkOrigDept]

(

[orig_dept_id] [int] IDENTITY(1,1) NOT NULL,

[orig_dept_name] [varchar](50) NOT NULL,

[created_user_id] [int] NOT NULL,

[created_date] [datetime] NOT NULL,

[abbreviation] [varchar](2) NULL,

CONSTRAINT [PK_tlkOrigDept] PRIMARY KEY CLUSTERED

Table tlkOrigDept

orig_dept_id ...

The reason is because I want all Funded contracts that are IN SERVICE. Not all funded contracts in total. Only the ones in service I want. inside the tlkOrigDept...

Oh okay, so for the Where Clause do you know how to integrate the orig_dept_id with the c.funded_Date? This is a little confusing for me because I already added the...

To better explain the case statement calculates funded contracts from the tcontract table. So I want all the funded contracts that are in Service which is in the tlkorigdept table....

So I am running this query, Thanks Sqlrnnr.

But I am getting no result. Is there something wrong in my updated query?

Create PROC [dbo].[spAdminFundedDateee]

As

Begin

SELECT ...

Thank you Luis, I managed to update it but is there a way for me to not put a parameter in the Stored procedure. Because by "Begin" SQL is stating...