Take a look at the blog from Aaron Bertrand where he builds a dynamic PIVOT solution:

http://www.mssqltips.com/sqlservertip/2783/script-to-create-dynamic-pivot-queries-in-sql-server/

I'm sorry, I didn't understood you wanted all the results in one set. To get this you need to add an OR statement to the WHERE clause;

select *

from cte_select

WHERE

(rownr >=...

You have changed the WHERE clause to a...

PIVOT will give you the results for each ID in one single row:

if OBJECT_ID('tempdb..#temp') is not null

drop table #temp

create table #temp (id int, characteristic varchar(15), value nvarchar(15))

insert into#temp

select 1, 'color',...

The top performer would have rownr =...

Your provided sample code is probably a bit different from your actual data. The values 'D09' and 'D13' in your sample code are put in the column "Firstname". In you...

This indicates an issue with permissions. Are you able to execute the package manually? Check all permissions of the service-account...

This is the code if you want only the row for a...

Will this do the trick?

select

ROW_NUMBER() over (order by count(ReviewedBy) desc) as rownr

, ShortAbbr

, firstname

, surname

, count(ReviewedBy)

from dbo.Users

inner join dbo.ProspectLead

on firstname = ReviewedBy

group by ShortAbbr

, firstname

, surname

order by

count(ReviewedBy) desc

You could wrap...

You can use the import/export wizard to create a SSIS package (or create a SSIS from scratch).

You can use the BCP command http://msdn.microsoft.com/en-us/library/aa337544.aspx to load the file from the commandprompt.

Could you provide some sample data ("create table" and "insert" statements) and state the desired output using this sample data. That way we can help you better and there would...

If you don't know that, then you would be shooting in the dark :exclamation:. When you alter security rights you need...

This will give you the results:

select a.ItemID, a.ItemName, a.Qty - b.Qty as current_inventory

FROM Inventory AS a

LEFT JOIN Sales AS b

ON a.ItemID = b.ItemID

When there could be more rows in Sales...

The cluster part of a clustered SQL installation is determined by the Windows cluster group. So if a node crashes, you can evict the node in Windows. No additional work...

This query gives you the date of the last FULL backup of each database or gives you the commandline to perform a FULL backup. Adjust this commandline in the query...