DECLARE @total_col VARCHAR(MAX) DECLARE @result NVARCHAR(MAX) SET @total_col='' SELECT @total_col = @total_col + QUOTENAME(item) + ',' FROM items SET @result=LEFT(@total_col, (LEN(@total_col)-1)) ...
PowerPivot with SQL Server 2008 R2 One of the prime-time features of Microsoft SQL Server 2008 R2 is provided by the “Project Gemini” technology known as PowerPivot for “Self Service BI”. Working with ...
Creates a small database table called dog. This table, dog, has been normalized to 3NF. Two new tables have been added, breedLookup and colorLookup. Creates a new table dog_expanded that joins dog, ...
This has been driving me crazy. Can anyone help me understand how I can dynamically create a sort of calendar view for a promotional schedule? I can't seem to get anything to work My table ...
Choose a SQL Server trial, edition, tool, or connector that best meets your data and workload needs. Accelerate AI development with SQL Server 2025, the AI-ready enterprise database with best-in-class ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results
Feedback