From the course: Complete Guide to Advanced SQL Server

Unlock this course with a free trial

Join today to access over 25,300 courses taught by industry experts.

Solution: Import and process data

Solution: Import and process data - SQL Server Tutorial

From the course: Complete Guide to Advanced SQL Server

Start my 1-month free trial Buy for my team

Solution: Import and process data

“

I hope you are able to output a data frame with two columns that show the Celsius and the equivalent Fahrenheit measurements from the Warehouse's cold room. Let's take a look at how I would go about solving the problem. First, I would go into the database and take a look at the tables folder, and we'll just take a quick look at the table that we're concerned with. This one here, Warehouse.ColdRoom Temperatures and the column that we need is this one here called temperature. Let's go ahead and start up a new query. And I'm going to fill in my standard Python template here. So execute the stored procedure, and then we have our language parameter, and set that to Python. Then we have the script parameter. And I'll leave that blank for now. And then we have our input data1 parameter. And that's going to be equal to and an open parentheses. And now we can type in the select statement that's going to pull out the temperature data from the warehouse cold room temperatures data table. So…

Contents