var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: When then to create mult columns
I have a colm day and colm sales, I would like to have a column for each day of week i think i can use when then but not sure how
select case when datepart(...) then ... end as mondie_sales
, case when datepart(...) then ... end as toosdie_sales
You're asking how to transform your day rows to a week row with one column for each day? If so, take a look at the PIVOT function (SQL Server 2005 only).
What's a "colm day"? Is that meant to be a "calm day"?
Originally Posted by mikezx10
I have no clue what you are talking about.