|
|
|
FoodMart , conversion to string .Simple question from "chainik".
|
|||
|---|---|---|---|
|
#18+
Hi to all, i am very interesting in following At FoodMart , Time dimension.I need to do concat of 2 columns "the_month" and "the_year" type of them is "SmallInteger" from table "time_by_day". I try following (at WinSQL) Select "the_year" + ' ' + "the_month" From "time_by_day" Have a good day .Ella. ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 12.01.2003, 16:05 |
|
||
|
FoodMart , conversion to string .Simple question from "chainik".
|
|||
|---|---|---|---|
|
#18+
Hi Ella. I do not specialize in OLAP. But can be so: Select Convert (varchar (10), the_year) + ' '+ Convert (varchar (10), the_month) as ym From time_by_day I wish success. ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 13.01.2003, 18:49 |
|
||
|
|
start [/forum/topic.php?desktop=1&fid=45&tid=1682567]: |
0ms |
get settings: |
7ms |
get forum list: |
19ms |
check forum access: |
2ms |
check topic access: |
2ms |
track hit: |
27ms |
get topic data: |
9ms |
get forum data: |
2ms |
get page messages: |
42ms |
get tp. blocked users: |
1ms |
| others: | 228ms |
| total: | 339ms |
| 0 / 0 |
