Lokesh Vij (1/17/2013)

---

I knew there was a discussion on similar question recently, still got the answer wrong 🙂

Whilst, I was trying to look at the queries executed in estimated execution...

It does work in R2 ; I have used openrowset in my project for adhoc insertions..

I think this...

Result set is all integer , because of Population_A INT, I should have added that as float.

with float , result set would be

MONTHNO SUM_COL

1 ...

Dehqon D. (1/16/2013)

---

The result is same with my previous query, I think I couldn't explain it right. By requirement for the column remaining it had to sum up all previous...

block 5753 (1/16/2013)

---

As a bit of additional info, intellisense picks up the function correctly.

But still getting:

select dbo.RAT(' ',' hey there dudes',1)

Msg 4121, Level 16, State 1, Line 1

Cannot find either...

+1

good question ..thanks...

ShineBoy (1/16/2013)

---

I've made use of a CLR to do this, very fast, did pay about $US 300 for the DLL's but that paid for itself many times over. If you're...

Lokesh Vij (1/15/2013)

---

humm... Try this out then

Execute this first:

EXEC master.dbo.sp_MSset_oledb_prop N'Microsoft.ACE.OLEDB.12.0', N'AllowInProcess', 1

GO

EXEC master.dbo.sp_MSset_oledb_prop N'Microsoft.ACE.OLEDB.12.0', N'DynamicParameters', 1

GO

Then try to execute your query with this change:

SELECT * FROM OPENROWSET('Microsoft.ACE.OLEDB.12.0',

'Excel 8.0;Database=C:\Users\sathiyanr\Desktop\dynamic.xlsx',

'SELECT *...

for missing explanation ; I think Funtion is designed to return a value . When error handling is allowed , suppose an exception is raised , the return value is...

I got it right for wrong reasons ;

Learned something.. thanks for the question..

+1

Thanks for the question..

easy one to start the day .. the brackets made it easy ..

I missed it completely 🙁

. no regret , learned something .

Also, I am glad to see that on aswering the question, equation for right and wrong is 0% and...

I...