bpowers (4/3/2013)

---

I built a staging table and I am writing the last execution time of the sp to that table. How do I now use the execution time in the...

Actually, the TVF being used is an in-line TVF.

And this rewrite of the function should work like the one Chris provided in-line in his code.

CREATE function [dbo].[woccsr_ts_amt] (

@wo_id varchar(24),

@cc_id varchar(24),

...

Something like this:

SELECT top 250000

x1.wo_ref AS [z13031322175522447287ca90],

sum(wta.approved_ts_amount) AS [z13031322175522447289ca90]

FROM

dbo.wo AS x1

INNER JOIN dbo.wocc AS...

I'm curious, how do most of you like your dihydrogen monoxide, straight or flavored?

rajarshi_ghosh_05 (4/2/2013)

---

DiverKas (4/2/2013)

---

rajarshi_ghosh_05 (4/2/2013)

---

Guys, No luck. DBAs are not going to give me the permission to create table in tempdb so I come up with an idea to put both...

skb 44459 (4/2/2013)

---

DECLARE @tempOutput TABLE (

vend_num NVARCHAR(7) NULL ,

name ...

Can't find anything, yet, directly from Microsoft but I did find this:

.NET Framework 4.0 is separate and independent from .NET Framework 2.0/3.0/3.5 (all one framework. 2.0 is the base, full,...

This is the key part when I read the article I pointed you to:

In general, you should not uninstall any versions of the .NET Framework that are installed on your...

umarrizwan (4/2/2013)

---

issue is with varchar value 'z' in data ('2013-10-29 22:59:00Z) and you are converting it to datetime or datetime2.

you can convert it after removing that value from data.

use this.

SELECT...

This may help: http://msdn.microsoft.com/en-us/library/bb822049.aspx

The following runs without error on my system. I had to correct some errors in the code provided.

You will want to run the following in a sandbox database first...

Sean Lange (4/2/2013)

---

Jeff Moden (4/1/2013)

---

Heh... I...

opc.three (4/1/2013)

---

Lynn's numbers seem off to me. I got ~10s for your method and ~50ms for Lynns. But Lynn's numbers make it...

Actually, we can probably show you how to do this without using...