{"id":24350,"date":"2023-05-22T22:43:24","date_gmt":"2023-05-22T19:13:24","guid":{"rendered":"https:\/\/nabfollower.com\/blog\/dynamic-sql-pivot-94a\/"},"modified":"2023-05-22T22:43:24","modified_gmt":"2023-05-22T19:13:24","slug":"dynamic-sql-pivot-94a","status":"publish","type":"post","link":"https:\/\/nabfollower.com\/blog\/dynamic-sql-pivot-94a\/","title":{"rendered":"\u0646\u062d\u0648\u0647 \u0686\u0631\u062e\u0634 \u062f\u0627\u062f\u0647 \u0647\u0627 \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 Dynamic SQL \u062f\u0631 SQL Server"},"content":{"rendered":"
\n

SQL Server PIVOT<\/code> \u0639\u0645\u0644\u06af\u0631 \u0632\u0645\u0627\u0646\u06cc \u0645\u0641\u06cc\u062f \u0627\u0633\u062a \u06a9\u0647 \u0647\u0645\u0647 \u0645\u0642\u0627\u062f\u06cc\u0631\u06cc \u0631\u0627 \u06a9\u0647 \u0628\u0627\u06cc\u062f \u0628\u0647 \u0633\u062a\u0648\u0646 \u062a\u0628\u062f\u06cc\u0644 \u0634\u0648\u0646\u062f \u0631\u0627 \u0628\u062f\u0627\u0646\u06cc\u062f. \u0627\u0645\u0627 \u0627\u06af\u0631 \u0646\u0645\u06cc \u062f\u0627\u0646\u06cc\u062f \u062f\u0642\u06cc\u0642\u0627\u064b \u062f\u0631 \u062c\u062f\u0648\u0644 \u0686\u06cc\u0633\u062a. \u0686\u06af\u0648\u0646\u0647 \u0633\u0637\u0631\u0647\u0627 \u0631\u0627 \u0628\u0647 \u0633\u062a\u0648\u0646 \u062a\u0628\u062f\u06cc\u0644 \u06a9\u0646\u06cc\u0645\u061f<\/p>\n

SQL \u067e\u0648\u06cc\u0627 \u0645\u06cc \u062a\u0648\u0627\u0646\u062f \u0628\u0647 \u0622\u0646 \u06a9\u0645\u06a9 \u06a9\u0646\u062f. \u0628\u06cc\u0627\u06cc\u06cc\u062f \u0622\u0646 \u0631\u0627 \u062f\u0631 \u0645\u062b\u0627\u0644 \u0633\u0627\u062f\u0647 \u0628\u0631\u0631\u0633\u06cc \u06a9\u0646\u06cc\u0645. \u06cc\u06a9 \u0645\u06cc\u0632 \u0648\u062c\u0648\u062f \u062f\u0627\u0631\u062f Goods<\/code>. \u062a\u0639\u062f\u0627\u062f \u0645\u0648\u0627\u062f \u063a\u0630\u0627\u06cc\u06cc \u0648 \u0641\u0631\u0648\u0634\u06af\u0627\u0647 \u0647\u0627 \u0645\u06cc \u062a\u0648\u0627\u0646\u062f \u0646\u0627\u0645\u062d\u062f\u0648\u062f \u0628\u0627\u0634\u062f. \u0627\u06af\u0631 \u0647\u0645\u06cc\u0634\u0647 \u0641\u0642\u0637 3 \u0641\u0631\u0648\u0634\u06af\u0627\u0647 \u0648 3 \u0645\u0627\u062f\u0647 \u063a\u0630\u0627\u06cc\u06cc \u062f\u0627\u0634\u062a\u060c \u0645\u06cc \u062a\u0648\u0627\u0646\u0633\u062a\u06cc\u0645 \u0627\u0632 \u0627\u0633\u062a\u0627\u0646\u062f\u0627\u0631\u062f \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u0645 PIVOT<\/code>.<\/p>\n

\n\n\n\n\n\n\n\n\n\n\n\n\n\n
\u0641\u0631\u0648\u0634\u06af\u0627\u0647<\/th>\n\u063a\u0630\u0627<\/th>\n\u0645\u06cc\u0632\u0627\u0646<\/th>\n<\/tr>\n<\/thead>\n
\u0641\u0631\u0648\u0634\u06af\u0627\u0647 1<\/td>\n\u0633\u06cc\u0628 \u0632\u0645\u06cc\u0646\u06cc<\/td>\n50<\/td>\n<\/tr>\n
\u0641\u0631\u0648\u0634\u06af\u0627\u0647 5<\/td>\n\u0633\u06cc\u0628 \u0632\u0645\u06cc\u0646\u06cc<\/td>\n150<\/td>\n<\/tr>\n
\u0641\u0631\u0648\u0634\u06af\u0627\u0647 12<\/td>\n\u0633\u06cc\u0628 \u0632\u0645\u06cc\u0646\u06cc<\/td>\n300<\/td>\n<\/tr>\n
\u0641\u0631\u0648\u0634\u06af\u0627\u0647 1<\/td>\n\u06af\u0648\u062c\u0647 \u0641\u0631\u0646\u06af\u06cc<\/td>\n220<\/td>\n<\/tr>\n
\u0641\u0631\u0648\u0634\u06af\u0627\u0647 5<\/td>\n\u06af\u0648\u062c\u0647 \u0641\u0631\u0646\u06af\u06cc<\/td>\n180<\/td>\n<\/tr>\n
\u0641\u0631\u0648\u0634\u06af\u0627\u0647 12<\/td>\n\u06af\u0648\u062c\u0647 \u0641\u0631\u0646\u06af\u06cc<\/td>\n60<\/td>\n<\/tr>\n
\u0641\u0631\u0648\u0634\u06af\u0627\u0647 1<\/td>\n\u062e\u06cc\u0627\u0631<\/td>\n500<\/td>\n<\/tr>\n
\u0641\u0631\u0648\u0634\u06af\u0627\u0647 5<\/td>\n\u062e\u06cc\u0627\u0631<\/td>\n10<\/td>\n<\/tr>\n
\u0641\u0631\u0648\u0634\u06af\u0627\u0647 12<\/td>\n\u062e\u06cc\u0627\u0631<\/td>\n90<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

\u0628\u0646\u0627\u0628\u0631\u0627\u06cc\u0646 \u0628\u0627\u06cc\u062f \u0645\u0648\u0627\u062f \u063a\u0630\u0627\u06cc\u06cc \u0631\u0627 \u0628\u0647 \u0633\u062a\u0648\u0646 \u062a\u0628\u062f\u06cc\u0644 \u06a9\u0646\u06cc\u0645. \u0646\u062a\u06cc\u062c\u0647 \u0628\u0627\u06cc\u062f \u0628\u0647 \u0627\u06cc\u0646 \u0635\u0648\u0631\u062a \u0628\u0627\u0634\u062f:<\/p>\n

\n\n\n\n\n\n\n\n
\u0641\u0631\u0648\u0634\u06af\u0627\u0647<\/th>\n\u0633\u06cc\u0628 \u0632\u0645\u06cc\u0646\u06cc<\/th>\n\u06af\u0648\u062c\u0647 \u0641\u0631\u0646\u06af\u06cc<\/th>\n\u062e\u06cc\u0627\u0631<\/th>\n<\/tr>\n<\/thead>\n
\u0641\u0631\u0648\u0634\u06af\u0627\u0647 1<\/td>\n50<\/td>\n220<\/td>\n500<\/td>\n<\/tr>\n
\u0641\u0631\u0648\u0634\u06af\u0627\u0647 5<\/td>\n150<\/td>\n180<\/td>\n10<\/td>\n<\/tr>\n
\u0641\u0631\u0648\u0634\u06af\u0627\u0647 12<\/td>\n30<\/td>\n60<\/td>\n90<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

\u0628\u06cc\u0627\u06cc\u06cc\u062f \u06cc\u06a9 \u062c\u062f\u0648\u0644 \u0627\u06cc\u062c\u0627\u062f \u06a9\u0646\u06cc\u0645 \u0648 \u062f\u0627\u062f\u0647 \u0647\u0627\u06cc \u062e\u0648\u062f \u0631\u0627 \u0648\u0627\u0631\u062f \u06a9\u0646\u06cc\u0645:<\/p>\n

\n
CREATE<\/span> TABLE<\/span> Goods<\/span>([<\/span>Store<\/span>]<\/span> VARCHAR<\/span>(<\/span>255<\/span>),<\/span> [<\/span>Food<\/span>]<\/span> VARCHAR<\/span>(<\/span>255<\/span>),<\/span> [<\/span>Amount<\/span>]<\/span> INT<\/span>);<\/span>\n\nINSERT<\/span> INTO<\/span> Goods<\/span>(<\/span>Store<\/span>,<\/span> Food<\/span>,<\/span> Amount<\/span>)<\/span>\nVALUES<\/span>\n(<\/span>'Store 1'<\/span>,<\/span> 'potato'<\/span>,<\/span> 50<\/span>),<\/span>\n(<\/span>'Store 5'<\/span>,<\/span> 'potato'<\/span>,<\/span> 150<\/span>),<\/span>\n(<\/span>'Store 12'<\/span>,<\/span> 'potato'<\/span>,<\/span> 300<\/span>),<\/span>\n(<\/span>'Store 1'<\/span>,<\/span> 'tomato'<\/span>,<\/span> 220<\/span>),<\/span>\n(<\/span>'Store 5'<\/span>,<\/span> 'tomato'<\/span>,<\/span> 180<\/span>),<\/span>\n(<\/span>'Store 12'<\/span>,<\/span> 'tomato'<\/span>,<\/span> 60<\/span>),<\/span>\n(<\/span>'Store 1'<\/span>,<\/span> 'cucumber'<\/span>,<\/span> 500<\/span>),<\/span>\n(<\/span>'Store 5'<\/span>,<\/span> 'cucumber'<\/span>,<\/span> 10<\/span>),<\/span>\n(<\/span>'Store 12'<\/span>,<\/span> 'cucumber'<\/span>,<\/span> 90<\/span>);<\/span>\n\nGO<\/span>\n<\/code><\/pre>\n
\n
\n    \u0648\u0627\u0631\u062f \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0634\u0648\u06cc\u062f<\/title>\n    \n<\/svg><\/p>\n
    \u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    \n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n
\u0628\u0631\u0627\u06cc \u0645\u062d\u0627\u0633\u0628\u0627\u062a \u0628\u0647 \u062f\u0648 \u062c\u062f\u0648\u0644 \u0645\u0648\u0642\u062a \u0646\u06cc\u0627\u0632 \u062f\u0627\u0631\u06cc\u0645:<\/p>\n
\n
\/*for turning rows into columns*\/<\/span>\nIF<\/span> OBJECT_ID<\/span>(<\/span>'tempdb..#tmp'<\/span>)<\/span> IS<\/span> NOT<\/span> NULL<\/span>\n    DROP<\/span> TABLE<\/span> #<\/span>tmp<\/span> \nCREATE<\/span> TABLE<\/span> #<\/span>tmp<\/span>(<\/span>Store<\/span> VARCHAR<\/span>(<\/span>255<\/span>),<\/span> Food<\/span> VARCHAR<\/span>(<\/span>255<\/span>))<\/span>\nGO<\/span>\n\/*for final result*\/<\/span>\nIF<\/span> OBJECT_ID<\/span>(<\/span>'tempdb..#result'<\/span>)<\/span> IS<\/span> NOT<\/span> NULL<\/span>\n    DROP<\/span> TABLE<\/span> #<\/span>result<\/span>\nGO<\/span>\n<\/code><\/pre>\n
\n
\n    \u0648\u0627\u0631\u062f \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0634\u0648\u06cc\u062f<\/title>\n    \n<\/svg><\/p>\n
    \u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    \n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n
\u0633\u0647 \u0645\u062a\u063a\u06cc\u0631:<\/p>\n
\n
DECLARE<\/span> @<\/span>sql<\/span> NVARCHAR<\/span>(<\/span>MAX<\/span>)<\/span> =<\/span> ''<\/span> \/*dynamic string*\/<\/span>\n        ,<\/span> @<\/span>columns<\/span> NVARCHAR<\/span>(<\/span>MAX<\/span>)<\/span> =<\/span> STUFF<\/span>(<\/span>ISNULL<\/span>((<\/span>SELECT<\/span> DISTINCT<\/span> ', ['<\/span>+<\/span> Food<\/span> +<\/span>'] INT'<\/span>\n                                                FROM<\/span> Goods<\/span>\n                                                FOR<\/span> XML<\/span> PATH<\/span>(<\/span>''<\/span>)),<\/span>''<\/span>),<\/span>1<\/span>,<\/span>2<\/span>,<\/span>''<\/span>)<\/span> \/*column names for the final result table*\/<\/span>\n        ,<\/span> @<\/span>summary<\/span> NVARCHAR<\/span>(<\/span>MAX<\/span>)<\/span> =<\/span> STUFF<\/span>(<\/span>ISNULL<\/span>((<\/span>SELECT<\/span> DISTINCT<\/span> ', SUM(['<\/span>+<\/span> Food<\/span> +<\/span>']) AS ['<\/span>+<\/span> Food<\/span> +<\/span>']'<\/span>\n                                                FROM<\/span> Goods<\/span>\n                                                FOR<\/span> XML<\/span> PATH<\/span>(<\/span>''<\/span>)),<\/span>''<\/span>),<\/span>1<\/span>,<\/span>2<\/span>,<\/span>''<\/span>)<\/span> \/*summing amount*\/<\/span>\n\nSELECT<\/span> @<\/span>columns<\/span> AS<\/span> [<\/span>columns<\/span>],<\/span> @<\/span>summary<\/span> AS<\/span> [<\/span>summary<\/span>];<\/span>\n<\/code><\/pre>\n
\n
\n    \u0648\u0627\u0631\u062f \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0634\u0648\u06cc\u062f<\/title>\n    \n<\/svg><\/p>\n
    \u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    \n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n
\"\u0645\u062d\u062a\u0648\u0627\u06cc<\/p>\n
\u062d\u0627\u0644\u0627 \u0628\u06cc\u0627\u06cc\u06cc\u062f \u0627\u0642\u0644\u0627\u0645 \u063a\u0630\u0627\u06cc\u06cc \u0631\u0627 \u0628\u0647 \u0633\u062a\u0648\u0646 \u062a\u0628\u062f\u06cc\u0644 \u06a9\u0646\u06cc\u0645 \u0648 \u0622\u0646 \u0631\u0627 \u0627\u06cc\u0645\u0646 \u06a9\u0646\u06cc\u0645 #tmp<\/code> \u062c\u062f\u0648\u0644<\/p>\n
\n
INSERT<\/span> INTO<\/span> #<\/span>tmp<\/span> \nSELECT<\/span> DISTINCT<\/span> Store<\/span>,<\/span> \nREPLACE<\/span>(<\/span>STUFF<\/span>(<\/span>ISNULL<\/span>((<\/span>SELECT<\/span> DISTINCT<\/span> ', 0 AS ['<\/span>+<\/span> Food<\/span> +<\/span>']'<\/span>\n            FROM<\/span> Goods<\/span> rw<\/span>\n            FOR<\/span> XML<\/span> PATH<\/span>(<\/span>''<\/span>)),<\/span>''<\/span>),<\/span>1<\/span>,<\/span>2<\/span>,<\/span>''<\/span>),<\/span>'0 AS ['<\/span>+<\/span> Food<\/span> +<\/span>']'<\/span>,<\/span> CAST<\/span>(<\/span>org<\/span>.<\/span>Amount<\/span> AS<\/span> VARCHAR<\/span>)<\/span> +<\/span> ' AS ['<\/span>+<\/span>org<\/span>.<\/span>Food<\/span>+<\/span>']'<\/span>)<\/span>\nFROM<\/span> Goods<\/span> org<\/span>;<\/span>\n\nSELECT<\/span> *<\/span> FROM<\/span> #<\/span>tmp<\/span>;<\/span>\n<\/code><\/pre>\n
\n
\n    \u0648\u0627\u0631\u062f \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0634\u0648\u06cc\u062f<\/title>\n    \n<\/svg><\/p>\n
    \u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    \n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n
\"#tmp\"<\/p>\n
\u0648 \u0627\u06a9\u0646\u0648\u0646 \u0628\u0627\u06cc\u062f \u0627\u0632 \u0633\u062a\u0648\u0646 Food \u062e\u0648\u062f \u0633\u062a\u0648\u0646 \u0647\u0627\u06cc\u06cc \u0627\u06cc\u062c\u0627\u062f \u06a9\u0646\u06cc\u0645.  \u0628\u0631\u0627\u06cc \u0627\u06cc\u0646 \u0645\u0646\u0638\u0648\u0631 \u0627\u0632 SQL \u067e\u0648\u06cc\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u062e\u0648\u0627\u0647\u06cc\u0645 \u06a9\u0631\u062f.<\/p>\n
\n
--create final table according to number of columns from @columns and insert data from #tmp<\/span>\nSET<\/span> @<\/span>sql<\/span> =<\/span> N<\/span>'create table #result(food varchar(255),'<\/span>+@<\/span>columns<\/span>+<\/span>'); '<\/span>+<\/span>CHAR<\/span>(<\/span>10<\/span>)<\/span>+<\/span>\n            'insert into #result '<\/span>+<\/span>CHAR<\/span>(<\/span>10<\/span>);<\/span>\n\nSELECT<\/span> @<\/span>sql<\/span> =<\/span> @<\/span>sql<\/span> +<\/span> N<\/span>'select <\/span>''<\/span>'<\/span>+<\/span>Store<\/span>+<\/span>'<\/span>''<\/span> as Store, '<\/span>+<\/span>Food<\/span>+<\/span>' union all '<\/span>+<\/span>CHAR<\/span>(<\/span>10<\/span>)<\/span> FROM<\/span> #<\/span>tmp<\/span>;<\/span>\n\n--remove last 'union all'<\/span>\nSET<\/span> @<\/span>sql<\/span> =<\/span> REVERSE<\/span>(<\/span>STUFF<\/span>(<\/span>REVERSE<\/span>(<\/span>@<\/span>sql<\/span>),<\/span>1<\/span>,<\/span>11<\/span>,<\/span>''<\/span>));<\/span>\n\nSET<\/span> @<\/span>sql<\/span> =<\/span> @<\/span>sql<\/span> +<\/span> N<\/span>'select food, '<\/span>+@<\/span>summary<\/span>+<\/span>' from #result group by food'<\/span>;<\/span>\n\nEXEC<\/span> sp_executesql<\/span> @<\/span>sql<\/span>;<\/span>\n<\/code><\/pre>\n
\n
\n    \u0648\u0627\u0631\u062f \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0634\u0648\u06cc\u062f<\/title>\n    \n<\/svg><\/p>\n
    \u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    \n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n
\u0646\u062a\u06cc\u062c\u0647 \u06cc sp_executesql<\/code> \u0631\u0648\u06cc\u0647 \u062e\u0648\u0627\u0647\u062f \u0628\u0648\u062f<\/p>\n
\"\u0646\u062a\u06cc\u062c\u0647<\/p>\n
\u062f\u0631 \u0635\u0648\u0631\u062a \u0646\u06cc\u0627\u0632 \u0628\u0647 \u062d\u0641\u0638 \u0622\u0646\u060c \u0645\u06cc \u062a\u0648\u0627\u0646\u06cc\u062f \u06cc\u06a9 \u062c\u062f\u0648\u0644 \u0627\u0636\u0627\u0641\u06cc \u0627\u06cc\u062c\u0627\u062f \u06a9\u0646\u06cc\u062f \u0648 \u062f\u0627\u062f\u0647 \u0647\u0627 \u0631\u0627 \u062f\u0631 \u0622\u0646 \u0648\u0627\u0631\u062f \u06a9\u0646\u06cc\u062f.  \u0645\u062b\u0644\u0627:<\/p>\n
\n
SET<\/span> @<\/span>sql<\/span> =<\/span> @<\/span>sql<\/span> +<\/span> N<\/span>'create table final_result(food varchar(255),'<\/span>+@<\/span>columns<\/span>+<\/span>');'<\/span>+<\/span>CHAR<\/span>(<\/span>10<\/span>)<\/span>+<\/span>\n                    'insert into final_result'<\/span>+<\/span>CHAR<\/span>(<\/span>10<\/span>)<\/span>+<\/span>\n                    'select food, '<\/span>+@<\/span>summary<\/span>+<\/span>' from #result group by food'<\/span>;<\/span>\n\nEXEC<\/span> sp_executesql<\/span> @<\/span>sql<\/span>;<\/span>\n\nSELECT<\/span>*<\/span> FROM<\/span> final_result<\/span>;<\/span>\n<\/code><\/pre>\n
\n
\n    \u0648\u0627\u0631\u062f \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0634\u0648\u06cc\u062f<\/title>\n    \n<\/svg><\/p>\n
    \u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    \n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n
\"\u0646\u062a\u06cc\u062c\u0647<\/p>\n
\u0647\u0645\u0686\u0646\u06cc\u0646 \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u06cc\u062f \u0647\u0646\u06af\u0627\u0645 \u0686\u0631\u062e\u0634 \u062f\u0627\u062f\u0647\u200c\u0647\u0627\u060c \u0633\u062a\u0648\u0646\u200c\u0647\u0627\u06cc \u0627\u0636\u0627\u0641\u06cc \u0645\u0627\u0646\u0646\u062f \u0645\u0642\u062f\u0627\u0631 \u06a9\u0644\u060c \u062a\u0639\u062f\u0627\u062f \u06a9\u0644 \u062f\u0631 \u0633\u062a\u0648\u0646\u200c\u0647\u0627 \u06cc\u0627 \u0631\u062f\u06cc\u0641\u200c\u0647\u0627 \u0627\u0636\u0627\u0641\u0647 \u06a9\u0646\u06cc\u062f.  \u0627\u06cc\u0646 \u06cc\u06a9 \u0631\u0648\u06cc\u06a9\u0631\u062f \u06a9\u0627\u0645\u0644\u0627 \u0627\u0646\u0639\u0637\u0627\u0641 \u067e\u0630\u06cc\u0631 \u0627\u0633\u062a.<\/p>\n
\u062a\u0648\u062c\u0647 \u062f\u0627\u0634\u062a\u0647 \u0628\u0627\u0634\u06cc\u062f<\/em>: \u0627\u06af\u0631 \u0646\u0633\u062e\u0647 SQL \u0634\u0645\u0627 \u0628\u0627\u0644\u0627\u062a\u0631 \u0627\u0632 2017 \u0628\u0627\u0634\u062f\u060c \u0627\u0645\u06a9\u0627\u0646 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0648\u062c\u0648\u062f \u062f\u0627\u0631\u062f STRING_AGG()<\/code> \u062a\u0627\u0628\u0639 \u0628\u0631\u0627\u06cc \u0633\u0627\u062f\u0647 \u06a9\u0631\u062f\u0646 STUFF\/XML<\/code> \u0628\u06cc\u0627\u0646\u06cc\u0647.<\/p>\n
\u0644\u0637\u0641\u0627\u064b \u0627\u06af\u0631 \u0627\u0632 \u0631\u0648\u0634 \u062f\u06cc\u06af\u0631\u06cc \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc \u06a9\u0646\u06cc\u062f\u060c \u062f\u0631 \u0646\u0638\u0631\u0627\u062a \u0632\u06cc\u0631 \u0628\u0647 \u0645\u0646 \u0627\u0637\u0644\u0627\u0639 \u062f\u0647\u06cc\u062f.  \u062c\u0627\u0644\u0628 \u0627\u0633\u062a \u06a9\u0647 \u0686\u06cc\u0632 \u062c\u062f\u06cc\u062f\u06cc \u0631\u0627 \u0627\u0645\u062a\u062d\u0627\u0646 \u06a9\u0646\u06cc\u062f.<\/p>\n<\/p><\/div>\n","protected":false},"excerpt":{"rendered":"
SQL Server PIVOT \u0639\u0645\u0644\u06af\u0631 \u0632\u0645\u0627\u0646\u06cc \u0645\u0641\u06cc\u062f \u0627\u0633\u062a \u06a9\u0647 \u0647\u0645\u0647 \u0645\u0642\u0627\u062f\u06cc\u0631\u06cc \u0631\u0627 \u06a9\u0647 \u0628\u0627\u06cc\u062f \u0628\u0647 \u0633\u062a\u0648\u0646 \u062a\u0628\u062f\u06cc\u0644 \u0634\u0648\u0646\u062f \u0631\u0627 \u0628\u062f\u0627\u0646\u06cc\u062f. \u0627\u0645\u0627 \u0627\u06af\u0631 \u0646\u0645\u06cc \u062f\u0627\u0646\u06cc\u062f \u062f\u0642\u06cc\u0642\u0627\u064b \u062f\u0631 \u062c\u062f\u0648\u0644 \u0686\u06cc\u0633\u062a. \u0686\u06af\u0648\u0646\u0647 \u0633\u0637\u0631\u0647\u0627 \u0631\u0627 \u0628\u0647 \u0633\u062a\u0648\u0646 \u062a\u0628\u062f\u06cc\u0644 \u06a9\u0646\u06cc\u0645\u061f SQL \u067e\u0648\u06cc\u0627 \u0645\u06cc \u062a\u0648\u0627\u0646\u062f \u0628\u0647 \u0622\u0646 \u06a9\u0645\u06a9 \u06a9\u0646\u062f. \u0628\u06cc\u0627\u06cc\u06cc\u062f \u0622\u0646 \u0631\u0627 \u062f\u0631 \u0645\u062b\u0627\u0644 \u0633\u0627\u062f\u0647 \u0628\u0631\u0631\u0633\u06cc \u06a9\u0646\u06cc\u0645. \u06cc\u06a9 \u0645\u06cc\u0632 \u0648\u062c\u0648\u062f \u062f\u0627\u0631\u062f Goods. …<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"fifu_image_url":"","fifu_image_alt":"","footnotes":""},"categories":[339],"tags":[],"class_list":["post-24350","post","type-post","status-publish","format-standard","hentry","category-dev"],"_links":{"self":[{"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/posts\/24350","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/comments?post=24350"}],"version-history":[{"count":0,"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/posts\/24350\/revisions"}],"wp:attachment":[{"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/media?parent=24350"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/categories?post=24350"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/tags?post=24350"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}