hello there, god bless your efforts..I have a simple enquiry as new sql learner. How are CTEs different from temporary tables? Thanks for taking care of this.
Great question. There are many differences but the biggest difference is that the CTE has to be used in the current query scope (re-execute the CTE code everytime you want to include those results). The temp table will exist for the entire duration of your session and does not need to be re-executed everytime you want to reference its results.
Do you perhaps know how to reverse this, i have a row with all the emails linked to the project in one cell separated by a ; i need to have all those emails listed each in a row and the project they dealt with
Try to experiment with the PARSENAME function in TSQL. The limitation may be that you need to know the project with the max number of emails, so you can repeat the PARSENAME function that many times. www.mssqltips.com/sqlservertip/6321/split-delimited-string-into-columns-in-sql-server-with-parsename/
Great video. One suggestion... please consider either lowering or omitting the background music because I found it a bit distracting. Thank you, Anthony.