>
> SELECT ID,
> IF ImageURL6 IS NOT NULL
> BEGIN
> SET @numPhotos = 6
> END
> IF ImageURL5 IS NOT NULL
> BEGIN
> SET @numPhotos = 5
> END
>
> ...
>
> ELSE
> BEGIN
> SET @numPhotos = 0
> END
>
> FROM cdmdatafeed
In SQL it would be:
SELECT
ID,
CASE
WHEN ImageURL6 IS NOT NULL
THEN numPhotos = 6
WHEN ImageURL5 IS NOT NULL
THEN numPhotos = 5
WHEN ImageURL4 IS NOT NULL
THEN numPhotos = 4
WHEN ImageURL3 IS NOT NULL
THEN numPhotos = 3
WHEN ImageURL2 IS NOT NULL
THEN numPhotos = 2
WHEN ImageURL1 IS NOT NULL
THEN numPhotos = 1
ELSE
THEN numPhotos = 0
END AS numPhotos
FROM
cdmdatafeed
Jochem
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
