Jeff Moden (1/8/2016)

---

sql_only (1/8/2016)

---

Jeff Moden (1/8/2016)

---

sql_only (1/8/2016)

---

I want to import data to my database via bcp like this

bcp mydb.dbo.mytable in 'C:\_value_.txt' -S mypc\instancename -T

But the error I keep getting is...

Jeff Moden (1/8/2016)

---

sql_only (1/8/2016)

---

I want to import data to my database via bcp like this

bcp mydb.dbo.mytable in 'C:\_value_.txt' -S mypc\instancename -T

But the error I keep getting is unable to open...

I want to import data to my database via bcp like this

bcp mydb.dbo.mytable in 'C:\_value_.txt' -S mypc\instancename -T

But the error I keep getting is unable to open BCP host data...

Phil Parkin (1/6/2016)

---

sql_only (1/6/2016)

---

Yes you're right.

I have had to settle...

Yes you're right.

I have had to settle with 2 though,...

was missing DECIMAL(18,16)...

DECLARE @tb_correlation TABLE (cl_time DATETIME,cl_first DECIMAL,cl_second DECIMAL)

--insert your data

;WITH te_correlation

AS

(

SELECT cl_time,

POWER(RANK() OVER (ORDER BY cl_first)-RANK() OVER (ORDER BY cl_second),2) AS corr

FROM @tb_correlation

ORDER BY cl_time

OFFSET 0 ROWS

)

SELECT

cl_time,

SUM(corr) --apply windowing here

FROM...

Hugo Kornelis (1/5/2016)

---

I am sorry to hear that the CLR aggregate does not support the newer windowing extensions. But you are right that this invalidates the idead and that it...

It turns out that even if this UDA is assembled, it can only be used with partition by in the over clause.

Will seek a strictly sql solution, no longer need...

It is a pity SQL Server has no inbuilt aggregate functions for correlation. 😉 I have to build one from scratch.

My function takes two columns so I will need to...

TheSQLGuru (1/3/2016)

---

Scalar UDFs are HORRIBLY HORRIBLY BAD!!! Take the logic out and either inline it in your SELECT or make it an INLINE Table Valued Function and go with that....

Okay thanks, no wonder there is nothing online about this

Thank you...

How would I use CROSS APPLY in this case?