sql server mdx

 FROM ( SELECT strtoset( "[日期].[Full Date Key].&["+cstr(Year(@starttime))+"-"+right("0"+cstr(Month(@starttime)),2)+"-"+right("0"+cstr(Day(@starttime)),2)+"T00:00:00] : [日期].[Full Date Key].&["+cstr(Year(@endtime))+"-"+right("0"+cstr(Month(@endtime)),2)+"-"+right("0"+cstr(Day(@endtime)),2)+"T00:00:00]"  ) ON COLUMNS
FROM ( SELECT ( {strtoset(@startcity)} ) ON COLUMNS
FROM ( SELECT ( { strtoset(@producttype) } ) ON COLUMNS
FROM ( SELECT ( {strtoset(@destinationcategory) } ) ON COLUMNS
FROM ( SELECT ( { strtoset(@destination) } ) ON COLUMNS
posted @ 2011-08-11 12:09  野三坡  阅读(208)  评论(0编辑  收藏  举报