Viewing 7 posts - 1 through 7 (of 7 total)
rupex2101 (4/17/2012)
Try this...
SELECT t1.PlanAccountKey, CASE t1.STRT_DATE WHEN t2.END_DATE THEN 'TRUE' ELSE 'FALSE' END AS opFROM @tblPlanAccount t1
INNER JOIN @tblPlanAccount t2
ON t1.PlanAccountKey = t2.PlanAccountKey-1
But if PlanAccountKey has gaps then Mike's solution...
April 17, 2012 at 9:27 am
Try this...
SELECT t1.PlanAccountKey, CASE t1.STRT_DATE WHEN t2.END_DATE THEN 'TRUE' ELSE 'FALSE' END AS op
FROM @tblPlanAccount t1
INNER JOIN @tblPlanAccount t2
ON t1.PlanAccountKey = t2.PlanAccountKey-1
April 17, 2012 at 9:11 am
I think this should be okay...
=Sum(First(Fields!budget.value, "CompanyLevelGroupName"))
April 5, 2012 at 10:23 am
if(@var1 > @var2) SELECT @var1 = @var2, @var2 = @var1
should work too.
April 5, 2012 at 8:42 am
Try this ...
DECLARE @var1 INT, @var2 INT
SET @var1 = 25
SET @var2 = 28
IF (@var1 > @var2)
BEGIN
SET @var2 = @var1 - @var2
...
April 5, 2012 at 8:40 am
Wildcat is right, just use 2 OUTPUT parameters instead of table.
April 3, 2012 at 1:54 pm
this should work fine...
SELECT UPPER(os.cpt4_id)
FROM #TRANS t
CROSS APPLY ( SELECT TOP 1 cpt4_id
...
April 2, 2012 at 11:53 am
Viewing 7 posts - 1 through 7 (of 7 total)