In the example above, the columns are State_PK, StateName I want ALL rows, ALL columns; name for the display value, key for the where clause in the next (and more...

SELECT * FROM can be acceptable and a normal requirement (think data warehousing, integration and application services). A common example is selects all states and provinces to generate a...

Yes they are and no they are not.

Technically, yes, the questions have been dumbing down over the past several years. We need to balance this with the way information...

laddu4700 (9/16/2010)

---

Actually I need to export the data to excel file. Some the coulumns data have NULL values.

I have used ISNULL function and wrote a below T-SQL statement, but...

No, it is not a data warehouse. I don't think that it even meets any definition I can find of a data mart.