The solution depends heavily on exactly how the data is stored.   If your customers table has one row for each app it's associated with, that's one solution, whereas if your...

Most of the data tables I've seen with pricing information are first based on a specific item.   In most cases, the database will have an ITEM table, that has a...

Seems like you'll have to use that Excel method.   Perhaps you can make the leftmost cell in the "parameter table" a drop down with all your servers as drop-down values?

To be honest, we've given you the same suggestion any number...

Add File isn't what you need.   Attachment is.

First, we really need to know what database version you are working with, as this is a SQL Server 2016 section of this forum.   We also need to know more...

I was presuming that the SQL code you posted originally, which contained a number of latitude and longitude values, was the polygon representing the boundaries of your location.   If that's...

Here you go:
--============SQL===================
DECLARE @cols    AS NVARCHAR (MAX),
        @query AS NVARCHAR (MAX);

SELECT    @cols = STUFF((    SELECT    ',' + QUOTENAME(LEFT(DATENAME(MONTH,[Month]),3) + '-' + RIGHT(DATENAME(year,[Month]),2))
                        FROM    ForeCastData...[Data$]
                        WHERE    [Status] = 'Order'
                            AND MONTH([Month]) >=...

Joe,

That kind of solution is dependent on the data always being structured with exactly the same number of elements per unique category.   While it works for what was...

Stripping out tags of that nature is fraught with all kinds of potential "gotchas".   Especially when at least one of them is in the category of "improperly formed".   However, if...