Im a mssql rookie but have an issue I have a table called draft DRAFT TABLE ---------- [draft_id] [int] IDENTITY(1,1) NOT NULL, [year] [numeric](18, 0) NULL, [round] [numeric](18, 0) NULL, [pick] [numeric](18, 0) NULL, [team_id] [int] NULL, [owner_id] [int] NULL, [manager_id] [int] NULL, [type] [varchar](50) NULL, [player_id] [int] NULL, I am wanting to create a query that will give me a matrix of sorts to view what team id has each pick rounds down the left and picks across the top. I have been looking at various examples but most are aggregate functions and I just dont seem to be able to put the pieces together. Any help would be appreciated. Thx, Bill
dynamic pivot is the way forward. Yes, you may not be doing a classic aggregate (SUM, COUNT), but if you've only got one row of data then what's the harm in using MAX or SUM? Sorry - not got the brainpower to write the query for you right now, but I'm sure someone will be along soon who's more awake / less full of lurgi.