Viewing 15 posts - 376 through 390 (of 1,246 total)
JesseBizInt (12/12/2016)
----------------------------------------------------
December 12, 2016 at 11:41 am
I would bet this is the type of situation where the script is easy and fast to run and the fix is complex to where they keep putting it off...
----------------------------------------------------
December 9, 2016 at 7:20 pm
exec sp_executesql N'select TherapyAdmin_ID, VisitObservation_ID, 1 as RowVersionNumber from hcs.AdminObservation
where TherapyAdmin_ID in (select TherapyAdmin_ID from hcs.PatientOrder,hcs.TherapyAdmin where PatientOrder.Order_ID=TherapyAdmin.Order_ID
and PatientOrder.PatientVisit_ID=@Parameter1) order by VisitObservation_ID',N'@Parameter1 bigint',@Parameter1=264377212
Do you have any index on...
----------------------------------------------------
December 9, 2016 at 6:56 pm
spidey73 (12/6/2016)
----------------------------------------------------
December 9, 2016 at 6:34 pm
Referring to the article on the calendar table, you could add a [month] column that would makes this easy for you.
You would create the field and update it by...
----------------------------------------------------
December 9, 2016 at 3:57 pm
points back to the source/staging table
Just does not come across to me as a good idea. That should be defined and referred to in your ETL process.
----------------------------------------------------
December 9, 2016 at 10:53 am
I think it is a good idea to keep the business ID along with your surrogate key definitely. As far as the source, that sounds to me more for auditing...
----------------------------------------------------
December 9, 2016 at 10:52 am
I am also assuming that the odoReading (mileage) increases with time , we are talking about vehicle miles correct?
----------------------------------------------------
December 6, 2016 at 7:33 pm
I think you may have to keep track of the vehicle as well?
If you dont mind doing it the old fashion way (pre Lag() and Lead() ) here is a...
----------------------------------------------------
December 6, 2016 at 7:32 pm
You can also opt to display your results to TEXT (rather than the default grid). The nature of a cell is such that the value takes priority over the...
----------------------------------------------------
December 6, 2016 at 7:18 pm
It makes sense to me to have these functions in their own database so as to keep a consistent definition of them in one central spot. Keeps you from having...
----------------------------------------------------
December 6, 2016 at 7:09 pm
See if this is helpful to you .
https://msdn.microsoft.com/en-us/library/ms186329.aspx
The article has an example that makes use of a audit table. I have to wonder if you are not concerned about...
----------------------------------------------------
December 6, 2016 at 6:58 pm
The problem may be that you are also creating a table inside the inner stored procedure ( with the same name I presume). In these cases each object is local...
----------------------------------------------------
December 5, 2016 at 3:51 pm
I only want to include the Doctor groups that have >11 discharges.
Do you mean across the whole twelve months or just 11 or less in any one month?
One...
----------------------------------------------------
December 2, 2016 at 4:05 pm
Partha Mandayam (11/30/2016)
Not really. Many undocumented procedures work fine and are really useful.
Depends on what you mean by working fine. You are stepping into the unknown and items like what...
----------------------------------------------------
November 30, 2016 at 12:16 pm
Viewing 15 posts - 376 through 390 (of 1,246 total)