Do you mean you don't want to show [Row Id] etc? If so, you can just remove the columns from the main select list (but not from the derived...

You could use a number table to create all month/years in the required range, then join to it with your data & set the nulls to zero.

How about this:

IF OBJECT_ID('tbl_FFIEC101') IS NOT NULL

DROP TABLE tbl_FFIEC101;

CREATE TABLE tbl_FFIEC101

(

[ID] Int,

[CFR ID] Varchar(20),

[Reporting Period End Date] DateTime,

[Data Source] Varchar(30),

[FDW Interface Name] Varchar(30),

[Adjustment Type] Varchar(30)

);

INSERT tbl_FFIEC101 VALUES ( 1, '100',...

Is this any help?

http://www.sqlservercentral.com/Forums/Topic1050299-1550-1.aspx#bm1051487