连接日期变量 mdx

发布于 2024-10-05 22:02:37 字数 578 浏览 1 评论 0原文

大家好，很抱歉再次打扰一个可怕的问题

，我有以下 mdx，我需要格式化日期 YYYYMMDD 但我遇到了麻烦，因为无论我如何表达它，它都不会在存储过程中编译，或者如果它执行生成的 mdx不行。

这是我到目前为止使用 sqlserver 2000 的代码。

set @CONSULTA = 'select [' +CONVERT(VARCHAR(8), @fecha, 112)+ '] AS [' +YYYYMMDD+ '], A.* 
    from (SELECT
    isnull(CAST("[Measures].[Cajas Dia]" As float(18,6)),2) As cajas_dia,
    isnull(CAST("[Measures].[P Redondeadas]" As int),2) As pz_redondeo
          FROM openrowset(''MSOLAP'',''DATASOURCE=XXXX; Initial Catalog=XXXX; User Id=XXX;Password=XXX;'', '+ '''' + @MDX +''''+')) as A

原文

Hello guys sorry to bother again with a horrible question

I have the following mdx and I need to format the date YYYYMMDD but I am having trouble as no matter how I phrase it it wont compile on the store procedure, or if it does the resulting mdx is no good.

Heres the code I have so far, using sqlserver 2000.

set @CONSULTA = 'select [' +CONVERT(VARCHAR(8), @fecha, 112)+ '] AS [' +YYYYMMDD+ '], A.* 
    from (SELECT
    isnull(CAST("[Measures].[Cajas Dia]" As float(18,6)),2) As cajas_dia,
    isnull(CAST("[Measures].[P Redondeadas]" As int),2) As pz_redondeo
          FROM openrowset(''MSOLAP'',''DATASOURCE=XXXX; Initial Catalog=XXXX; User Id=XXX;Password=XXX;'', '+ '''' + @MDX +''''+')) as A

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

病女 2024-10-12 22:02:37

我认为您希望在 CONVERT。也不知道为什么你的查询中的方括号括起来。

CONVERT(VARCHAR(8), @fecha, 112)

I think you'd want to use style 112 instead of 122 on the CONVERT. Also not sure why you have square brackets around that in your query.

CONVERT(VARCHAR(8), @fecha, 112)

回复收藏 0 原文

网白 2024-10-12 22:02:37

这是你需要的吗？

没有样式 122，我假设您正在尝试将日期作为文字返回，并将该列别名为 YYYYMMDD？

set @CONSULTA = 'select ''' +CONVERT(VARCHAR(8), @fecha, 112)+ ''' AS [YYYYMMDD], A.* 
    from (SELECT
    isnull(CAST("[Measures].[Cajas Dia]" As float(18,6)),2) As cajas_dia,
    isnull(CAST("[Measures].[P Redondeadas]" As int),2) As pz_redondeo
          FROM openrowset(''MSOLAP'',''DATASOURCE=XXXX; Initial Catalog=OLAP_HDZ; User Id=XXX;Password=XXX;'', '+ '''' + @MDX +''''+')) as A'

Is this what you need?

There is no style 122 and I assume you are trying to bring the date back as a literal and alias that column as YYYYMMDD?

set @CONSULTA = 'select ''' +CONVERT(VARCHAR(8), @fecha, 112)+ ''' AS [YYYYMMDD], A.* 
    from (SELECT
    isnull(CAST("[Measures].[Cajas Dia]" As float(18,6)),2) As cajas_dia,
    isnull(CAST("[Measures].[P Redondeadas]" As int),2) As pz_redondeo
          FROM openrowset(''MSOLAP'',''DATASOURCE=XXXX; Initial Catalog=OLAP_HDZ; User Id=XXX;Password=XXX;'', '+ '''' + @MDX +''''+')) as A'

回复收藏 0 原文

~没有更多了~