Well, SSDT for Visual Studio 2022 is out as well, so...

Why are you trying to install SSDT 2017? That won't work with SQL Server 2019.

So as mentioned, why not pivot your data in the...

Of course it won't, the data was inserted into a table, not returned to...

Try this

SET @query
    = N'select * into #FinalResult from

(select Name, ' + @cols
      + N' from (select name,quantity,itemname...

Presumably, then, dtkey is a foreign key to a Calendar table, so why not JOIN to said calendar table and then do WHERE CalendarTableDateColumn > ??

I don't see how the above has any relevance to SQL Server. it feels more like you've posted your homework question into the topic, if i am honest.

What is it...

Okay, this is VERY weird. My last post, when I hit submit, errored out with "Are you sure you want to do that?"

And when I hit submit again, it...

Honestly, I would create your entire statement on the fly and use conditional aggregation, not the restrictive PIVOT operator, then you'll find this much easier. Also the syntax SELECT @Variable...

• This reply was modified 3 years, 4 months ago by Thom A.

from or T0 OR is a reserved keyword, if your table is really called or then you need to delimit identify it (or better yet, rename it to something...

For question 2, you likely want a windowed AVG with an ORDER BY clause in the PARTITION BY. Without sample data, or expected results, it's difficult to know.

For question one,...

Couple of initial questions, why do you INSERT the rows from your parameter  @ezy_SMSNotificationItemDetailsType into a user defined table variable @SMSDetailTable? Why not just use the contents of @ezy_SMSNotificationItemDetailsType? Why...

Correction, SSRS for VS2022 is available. There is no VS 2022 release (yet) for SSIS and SSAS; you need to continue to use VS 2019 (which

SSDT was available since the launch of VS 2022; the SSAS, SSIS and SSRS extensions are not. Since 2016 (iirc) SSDT has simply...

This is just a habit of...