shilpi2
asked on
Syntax sql2
Hi Experts,
what is wrong with this syntax?
DECLARE @RealStartDate DATETIME
DECLARE @RealEndDate DATETIME
SET @RealStartDate = (
SELECT MIN(VRD.ValueDate)
FROM IDX_ValuationRiskDaily VRD
WHERE
VRD.ValueDate>= @Start_Date
AND VRD.ValueDate< @End_Date
AND VRD.PortfolioID = @PortfolioID)
IF @RealStartDate IS NULL THEN
@RealStartDate = @Start_Date
END IF
Thanks
what is wrong with this syntax?
DECLARE @RealStartDate DATETIME
DECLARE @RealEndDate DATETIME
SET @RealStartDate = (
SELECT MIN(VRD.ValueDate)
FROM IDX_ValuationRiskDaily VRD
WHERE
VRD.ValueDate>= @Start_Date
AND VRD.ValueDate< @End_Date
AND VRD.PortfolioID = @PortfolioID)
IF @RealStartDate IS NULL THEN
@RealStartDate = @Start_Date
END IF
Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
too slow!
Whoops, drop the last )