In an empty database run the following and let us know if this is what you are looking to achieve.

CREATE TABLE dbo.[Queue]

(

QueueId INT NOT NULL PRIMARY KEY...

TheGreenShepherd (6/12/2014)

---

Ok, let me give the whole picture.

I have three tables - Queue, Tasks, and QueueTaskLink

CREATE TABLE Queue

(

QueueId INT NOT NULL PRIMARY KEY IDENTITY(1,1),

MaximumQueueLength...

I am not sure what you are trying to accomplish. The query you posted doesn't appear to be what you are asking about, or I just don't understand the...

Modified the dateadd just in case you have jobs that run an hour or more:

select

sjh.job_id,

CONVERT(varchar(20), CAST(CAST(sjh.run_date as char(8)) as date),110) run_date,

...

How about this (sorry, but I didn't work with your query):

select

*,

cast(cast(run_date as varchar) + ' ' + stuff(stuff(right('000000' + cast(run_time as varchar),6),5,0,':'),3,0,':')...

I have to agree with Alan.B, I have worked with TEKSystems in the past and they are a good company to work with as a contractor. The two associates...

Yes.

If you move a subset of the data to a test database with tables created as they are in production, can you reproduce the issue?

Not really. Could be if I slept in transient...

And the results from the query SELECT @@VERSION?

First, I reformatted your code:

DECLARE @ID varchar(12)

DECLARE @Volume int, @Paid int, @Denied int

DECLARE @PaidAmount money, @DeniedAmount money

DECLARE @CID varchar(12), @CStatus varchar(2), @amt_paid money

SET @Volume = 0

SET @Paid = 0

SET...

Looking at the code you posted, I have no idea where to start. There actually isn't much to work with.

You can start by reading these articles:

http://www.sqlservercentral.com/articles/T-SQL/66097/

http://www.sqlservercentral.com/articles/T-SQL/66494/

Please do not post in multiple threads as this will simply frustrate those who want to help and fragment any responses you may get.

Please post response here

Could you post the actual (and entire) error message you are getting? Also, what is the result of this query:

SELECT @@VERSION

Reformatted your code to read it easier:

select

A.C1,

Max(DateDiff(D, Coalesce (Date_Physician_Reviewed,Date_Nurse_Reviewed,CODER_RVWD_DT),Getdate())),

'MN QA REPORT - PASSED RECONSIDERATION REPAYMENT'

from

...