Relative Content

Tag Archive for sqlsql-serversubquerysql-insertuser-defined-functions

INSERT INTO SELECT subquery that uses a udf so that it returns 1 value

I’m attempting to create a new table but altering some of the data from my old table using the INSERT INTO SELECT statement. I’m trying to take a field with numbers and letters and pull out the numbers and multiply those number based on whether the number represented days, hours, or minutes and insert the result into my new table.