Viewing 15 posts - 1,441 through 1,455 (of 8,731 total)
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
Something like this might work. It's untested due to lack of sample data.Declare @FDate DateTime, @TDate DateTime Select @FDate = min(Q.Refdate) from OJDT Q where...
March 17, 2017 at 1:53 pm
Viewing 15 posts - 1,441 through 1,455 (of 8,731 total)