English 中文(简体)
从2005年KLQ号服务器与PIVOT的电离层中提取记录
原标题:Trouble creating a recordset from a SQL Server 2005 query with PIVOT

这里是我储存的原产地的输出代码:

SELECT  *
FROM 
(
    select q.ccypair, q.vega, t.label 
    from #parallel q 
    LEFT JOIN TPRR_vega_weights t ON q.Tenor = t.Tenor
) a
PIVOT 
(
    Sum(Vega)  
    for a.label in ([t1],[t2],[t3],[t4],[t5],[t6],[t7],[t8],[t9],[t10],[t11],[t12],[t13],[t14],[t15],[t16],[t17],[t18])
)p
order by ccypair

页: 1 ADODB. 当我试图在Excel VBA(I)上打开记录时,我用一辆面包车从X点中挑选了该代码,并且是罚款。

任何想法?

最佳回答

归根结底,这是造成这一问题的用药,它只是未能在所储存的假装上SET NOCOUNT。

问题回答

我认为,ADO没有如何正确处理假发言。 如果你在使用美国食品安全局时,我会说使用过转盘,不需要,或者在《食品安全法》中选择。

您是否能够把你的q言放在一个储存程序中,并称之为所储存的程序? 这种方法只能用所交数据。





相关问题
import of excel in SQL imports NULL lines

I have a stored procedure that imports differently formatted workbooks into a database table, does work on them then drops the table. Here is the populating query. SELECT IDENTITY(INT,1,1) AS ID ...

Connecting to Oracle 10g with ODBC from Excel VBA

The following code works. the connection opens fine but recordset.recordCount always returns -1 when there is data in the table. ANd If I try to call any methods/properties on recordset it crashes ...

Excel date to Unix timestamp

Does anyone know how to convert an Excel date to a correct Unix timestamp?

C# GemBox Excel Import Error

I am trying to import an excel file into a data table using GemBox and I keep getting this error: Invalid data value when extracting to DataTable at SourceRowIndex: 1, and SourceColumnIndex: 1. As ...

Importing from excel "applications" using SSIS

I am looking for any tips or resources on importing from excel into a SQL database, but specifically when the information is NOT in column and row format. I am currently doing some pre-development ...

热门标签