0 - 3 of 3 tags for rows to columns

HI,
I NEED TO DO A ROWCOUNT ON ALL TABLES ON A GIVEN DATABASE. I CAN EASILY DO THIS IN SQL USING A PIVOT TABLE.

CAN SOMEONE HELP?

THIS IS WHAT I HAVE:
LETS SAY THIS IS (TABLE_COUNTS)

TABLENAMES ROWCOUNTS
TABLE1 500
TABLE2 200
TABLE3 800
TABLE4 499

Hi Guys

 

I'm facing a difficulty in achieving the below scenario

 

Scenario :

Table A is the table i'm having

( The column ID2 has only 4 distinct values -- A,B,C,D )

 

Hello experts

We are designing a dimension of ITEMS (in a Point of sales DWH) as a table with Name-Value Pairs i.e. ITEM attributes stored as ROWS instead of COLUMNS.This ITEM table is joined to a fact table containing SALES $ and QUANTITY.