But you keep asking the same questions. ...

You said you can't post the code for the UDF, but could you post code for the UDF with a faked process? It just has to show us how...

Hey Jeff, you have a spare high-velocity pork chop launcher you can send me?? I think I'm going to lose my halo soon and I might as well do...

Excuse me?? I have been helping, as have several others. We are trying to get you to think critically about the things...

I have taken the time to rewrite your stored procedure a bit and you may want to see if it returns the same data as yours. Not having anything...

Okay, between the information you have been given on this thread and this one, you should be able to determine what you need to do at this point.

Jeff Moden (7/2/2009)

---

Lynn Pettis (7/2/2009)

---

Jeff,

Pretty sure I'm the first one SSC to use the Base 10. I just thought it reduced the number of cross joins to generate a...

scott_lotus (7/2/2009)

---

Thanks for the reply. Been chatting to a SQL contact at an ISP and he also mentioend NOLOCK (see below). taking into account what everyone has said in this...

Jay Tucker (7/2/2009)

---

Lynn,

The CONVERT function just wasn't doing anything, so I went back to what I usually use, which is DATEADD. I had forgotten that it was failing only...

Jeff,

Pretty sure I'm the first one SSC to use the Base 10. I just thought it reduced the number of cross joins to generate a large number of values....

Is this what you are trying to get?

select

aht.Asset_ID,

aht.To_User,

aht.To_Status,

convert(varchar(10),aht.Change_Date, 101) as Change_Date

from

...

I'm sorry, I don't know what you mean by UNIX format. When you select a datetime column from a SQL database, it displays a datetime value. I am...

I think part of the reason is that anyone can get the certification. Years ago when Novell began the...

Steve Jones - Editor (7/1/2009)

---

Perhaps not a great attitude, but that's not how I read it. Seems more like a cultural "terseness" that I see from many newbies in non-English...

Hey Barry,

What ever happened to the little green dude that was breathing down your neck a while ago?? 😉