Viewing 15 posts - 1,441 through 1,455 (of 8,731 total)
This should be the equivalent to the original query using EXISTS instead of IN.SELECT
ap.AdminProduct_ID
,ap.RowVersionNumber
,ap.TherapyAdmin_ID
,ap.PackagedProduct_ID
,ap.AdminRecordMethod
,ap.ActionCode
March 27, 2017 at 9:32 am
March 27, 2017 at 9:10 am
A different solution is to use views or derived tables instead of CTEs.
March 24, 2017 at 2:58 pm
This seems to be part of the problem from the following thread: https://www.sqlservercentral.com/Forums/1866309/Question-on-Outer-and-Inner-Cursor
March 23, 2017 at 1:38 pm
No , My logic is different, I understand his example -
But i have taken that...
March 23, 2017 at 1:31 pm
I have a procedure where it has a Cursor now, I am planning to create...
March 23, 2017 at 11:42 am
March 22, 2017 at 2:48 pm
March 22, 2017 at 1:30 pm
March 22, 2017 at 1:17 pm
March 22, 2017 at 7:10 am
Thanks for the post . But the condtion
E.MgrID = H.EmpID
will not work...
March 20, 2017 at 12:17 pm
There's no need for a CTE.
SELECT Store_grp, Store,
CASE
WHEN Value1Aggr = 'MAX' THEN MAX(Value1)
WHEN Value1Aggr = 'MIN' THEN...
March 20, 2017 at 11:50 am
Here's an option that might work better than a rCTE. This article was written from experience on a problem very similar to what you're describing.
It uses a loop, but...
March 20, 2017 at 10:57 am
Viewing 15 posts - 1,441 through 1,455 (of 8,731 total)