zxcvb12 发表于 2016-10-29 10:39:12

sql server mdx

FROM ( SELECT strtoset( "[日期]..&["+cstr(Year(@starttime))+"-"+right("0"+cstr(Month(@starttime)),2)+"-"+right("0"+cstr(Day(@starttime)),2)+"T00:00:00] : [日期]..&["+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
页: [1]
查看完整版本: sql server mdx