> Dear expert
>
> MS SQL SERVER 2008
>
> NEED TO CREATE A STORED PROCEDURE .
>
> The stored procedure does further analysis as follows
>
>
>
> Name Gender
> --------------
> Ivy Girl
> Jon Girl
> Peter Boy
> Andy Boy
>
>
> Expected Outcome
>
>
> Name Gender G_girl G_boy
> -------------------------------
> Ivy Girl Girl
> Jon Girl Girl
> Peter Boy Boy
> Andy Boy Boy
>
>
> Please do the necessary analysis using a select statement in ms sql server 2008.
>
>
> Thanks
SELECT Name, Gender, if(Gender = 'Girl', 'Girl','') AS G_girl, if(Gender = 'Boy', 'Boy','') as G_boy FROM .... In Mariadb you could have a View in your database - no need for stored procedure. Probably the same in SQL 2008.