Once a PIVOT is used SQL Prompt will no longer respond

Provides intelligent code completion for SQL Server editors.

Moderators: David Atkinson, Anu Deshpande, Luke Jefferson, Paul Stephenson

Once a PIVOT is used SQL Prompt will no longer respond

Postby sbenson » Fri Aug 27, 2010 7:40 pm

Example

SELECT [A],[B],[C],[G],[P],[Q],[R],[U],[Z],[N]
FROM
(
SELECT ISNULL(iie.ovr_ma_pricing_lookup_status,'N') as ovr_ma_pricing_lookup_status, count(*) as records
FROM ItemMaestroProdDSS_8_27_2010_12_54_49_557.dbo.Input_Items ii
JOIN ItemMaestroProdDSS_8_27_2010_12_54_49_557.dbo.Input_Items_Extended iie ON ii.id = iie.input_item_id
WHERE ii.job_id = 3435
GROUP BY iie.ovr_ma_pricing_lookup_status
) AS source
PIVOT
(
SUM(records)
FOR ovr_ma_pricing_lookup_status IN ([A],[B],[C],[G],[P],[Q],[R],[U],[Z],[N])
) as pvt

If Ihit ctrl-space, all suggestions come up but there are no tables, just snippets.
sbenson
 
Posts: 11
Joined: Tue Jun 09, 2009 8:57 pm

Return to SQL Prompt 5 EAP

Who is online

Users browsing this forum: No registered users and 0 guests