Would you be able to explain this query for me? I hate to just copy and paste without understanding the code. Also, can this be applied to other calculations such...

Thanx.

Thanx.

Thanx. I think this will work.

It's been one of those days but, yes, this does look good.

The results of this query show weeks ending for 5/14, 5/21, 5/28. None of these are Fridays. Also, there seem to be multiples. Any thoughts?

I was expecting to get a row for each Friday since the beginning of the data. Here is an example. I ran each of these weeks separately.

WeekEndingCount

5/13/2016 ...

I need to get a value for each week, ending with Friday, for the date range.

Thanx.

create table #Test

(

ResultValue varchar(30)

)

insert into #Test(ResultValue) values('1.1')

insert into #Test(ResultValue) values('110.1')

insert into #Test(ResultValue) values('90.9')

insert into #Test(ResultValue) values('0.9')

insert into #Test(ResultValue) values('Unable to Calculate')

insert into #Test(ResultValue) values('Unable to Calculate')

insert into #Test(ResultValue) values('1.2')

insert into...

Yes. I only used * to save on typing. I never use it in practice.

Thanx again.

Thanx.

declare @StartDate datetime,

@EndDate datetime;

set @StartDate='2016-09-01';

set @EndDate='2016-09-30';

--Get inpatient VisitID's to look up

selectHRVD.SourceID,

HRVD.VisitID,

PADQ.*

from livefdb.dbo.HimRec_VisitData HRVD

inner join livefdb.dbo.PcsAssmntData_Queries PADQ

on HRVD.SourceID=PADQ.SourceID

and PADQ.PcsAssmntDataID = HRVD.VisitID + '{A^GEN.ADMPART2}'

where HRVD.SourceID='BRO'

and HRVD.VisitType_MisRegTypeID='IN'

and HRVD.RegistrationDateTime>=@StartDate and HRVD.RegistrationDateTime<dateadd(day, 1,...

Would this be the best way? Replace the ???? with left(PADQ.PcsAssmntDataID,21)?

declare @StartDate datetime,

@EndDate datetime

set @StartDate='2016-09-01'

set @EndDate='2016-09-30'

--Get inpatient VisitID's to look up

selectHRVD.SourceID,

HRVD.VisitID,

PADQ.*

from livefdb.dbo.HimRec_VisitData HRVD

inner join livefdb.dbo.PcsAssmntData_Queries PADQ

on HRVD.SourceID=PADQ.SourceID

and HRVD.VisitID=left(PADQ.PcsAssmntDataID,21)

where HRVD.SourceID='BRO'

and...

like this? What would replace the ???? in the where clause?

declare @StartDate datetime,

@EndDate datetime

set @StartDate='2016-09-01'

set @EndDate='2016-09-30'

--Get inpatient VisitID's to look up

selectHRVD.SourceID,

HRVD.VisitID,

PADQ.*

from livefdb.dbo.HimRec_VisitData HRVD

inner join livefdb.dbo.PcsAssmntData_Queries PADQ

on HRVD.SourceID=PADQ.SourceID

and HRVD.VisitID=PADQ.????

where HRVD.SourceID='BRO'

and...

Pardon my ignorance but, how do I pass the values? Here is what I have so far. The first query will get me the VisitID's. The second query is what...