Marcster
08-22-2013, 10:28 AM
Hi,
Is it possible to convert an Excel formula to SQL Server Calculated Column for the below formula?:
=IF(H6=197,"Option1",IF(H6=200,"Option2",IF(H6=199,"Option3","Unknown")))
So the result would be like:
H6
Option1
Option2
Option1
Unknown
The Option1 etc does not exist on SQL Server, but field H6 does (as a number) so I manipulate the data in Excel. If the above can be done via a script that'll save me time.
Thanks
Is it possible to convert an Excel formula to SQL Server Calculated Column for the below formula?:
=IF(H6=197,"Option1",IF(H6=200,"Option2",IF(H6=199,"Option3","Unknown")))
So the result would be like:
H6
Option1
Option2
Option1
Unknown
The Option1 etc does not exist on SQL Server, but field H6 does (as a number) so I manipulate the data in Excel. If the above can be done via a script that'll save me time.
Thanks