That was going to be my exact question.... or is...

May I ask why you are using CTEs in this manner when you could just use the tables themselves?

Or, put the CTE with the select that is calling it:

With ProductName(ProductID, Description)
AS
(

    SELECT ProductID, ProductName
    FROM dbo.Products

)INSERT INTO ProductName ...

• This reply was modified 6 years ago by Lynn Pettis.

To add to what Grant has stated, I agree that "new" voices are a bonus on any forum but I have seen some "new" people come in with some...

Should setup the place holder for the SSCFFL 2020 season.  I will be back!

This is much simpler and does not require the use of REVERSE: SELECT LEFT(RIGHT(@Text,12),8);

Simple and to the point.  I would put a comment with it to explain what is being so that someone with less SQL knowledge...

I took the time to look at the posing on ZipRecruiter and to me it seems rather vague as to what you are looking for in a candidate.  I have...

• This reply was modified 6 years, 1 months ago by Lynn Pettis.

You could also put it in a zip file and upload that to the site.

Another option is to use dynamic SQL. For any input parameters that are null the AND clause could be removed. For example, if @PatientID were null you could remove...

First, this is a catch all query.  If either of the variables @PatientID or @CareProviderID are null you want to return all rows of data for PatientID and/or CareProviderID.

There is...

Would help if you posted the actual execution plan, not a picture of the graphic.  There isn't a lot of information available from the picture.  Also seeing the code would...

A question to be answered is this: How wide is each row of data?  This will impact the number of rows of data in each data page.  The fewer rows...

Given that the table had no index at all, I didn't think in this case that making the clus index unique was necessary, particularly to the extent...

Lynn Pettis, the difference in genetic structure between humans and chimps is around 4%. The pickyness of evolution is what gave rise to humans. One error in one line...