Viewing 15 posts - 196 through 210 (of 431 total)
Thanx. The value that the % is replacing is called a VisitID. If I was able to "supply" that value, is there a way that I could pass it to...
September 29, 2016 at 5:28 am
To be honest, I got hung up on the other solution. Luis's works out fine.
Thanx.
September 23, 2016 at 5:40 am
Look at MRN=271379. This is what I need to get as results for each record in #NoShow. However, if there is no future appointment for a particular patient then, column...
September 23, 2016 at 4:31 am
The results should look like this..........
MRNNoShowDateNextAppt
8763876/29/20154/29/2016
8763876/15/2016
8763877/21/2016
8596571/11/20161/15/2016
8705832/19/20166/1/2016
8769036/16/20166/29/2016
8919036/6/20167/14/2016
8176159/9/2016
8134158/6/20158/21/2015
8812794/27/2016
8750662/12/20163/24/2016
8750641/29/20164/5/2016
8750642/5/20164/5/2016
8750643/31/20164/5/2016
8760471/14/20161/21/2016
8760472/1/2016
8760475/25/2016
85913212/9/2015
7907319/7/2016
8726524/1/20154/7/2015
8726527/21/2016
8726528/4/2016
8155505/4/2016
8780476/4/20158/4/2015
3503468/5/2016
8831216/16/2016
8820735/11/2016
8742618/26/201510/9/2015
8742611/7/2016
September 23, 2016 at 4:26 am
For each record in #NoShow I'd like to get the record in #FutureAppts the is the next with a date greater than the No show record
September 22, 2016 at 9:57 am
Thanx but, in the meantime I came up with this solution..............................
alter function dbo.fnWeight(@VisitID varchar(100))
RETURNS float as
BEGIN
DECLARE @Return float
set @VisitID=@VisitID + '{A^VS.WEIGHT}'
select @Return=cast(replace(left(PADQ.QueryValue,charindex('|',PADQ.QueryValue)-1),'{','') as float)/1000
from livefdb.dbo.PcsAssmntData_Queries PADQ
inner join (selectSourceID,
PcsAssmntDataID,
max(IdentifierID) as IdentifierID
from...
July 27, 2016 at 6:30 am
Rather than using a linked server, I ran the query directly on "SH-SQL01". I got this error. This server must be an earlier version. I'll use TW + PROVID, instead....
July 19, 2016 at 4:17 am
If I run the query as below, I don't get the error.
select *
from [SH-SQL01].DataWarehouse.dbo.formatIDX_Providers
July 19, 2016 at 4:09 am
formatIDX_Providers is a view. If I run the query without the where clause, I still get the error.
July 19, 2016 at 4:05 am
How do I get a new page for each record? Where can I place informational text boxes that will print on each new page?
July 15, 2016 at 9:59 am
Viewing 15 posts - 196 through 210 (of 431 total)