brekher (3/7/2008)

---

Hi,

On the server that I would change it on, I would want all system views procs, etc.. to see the date returned. Thats why I am looking into changing...

Let's just say that messing with getdate() will likely get all sorts of system functions/views to start falling apart. If nothing else - this might be your time to...

brekher (3/7/2008)

---

Hi,

To avoid changing over 100,000 lines of code I need to change the getdate() function itself within SQL server. Can someone please point me in the right direction as...

Ratheesh.K.Nair (3/7/2008)

---

Thanks All,

The problem is that after reviewing the codes they said that EXISTS and TOP...

hmm - the twist that changes the problem around:)

I'd modify Jeff's script a little, to bring over the date as well.

drop table #tmptable

SELECT CAST(pd.TodayID AS INT) AS TodayID,pd.PreviousDayID,pd.PatientID,1 AS Parm,[date]...

That's actually kind of funny to me. ...

DBADave (3/7/2008)

---

I want to make sure I am on the same page, or at least in the same book :). In your last replay you referred to attaching an...

No - a virtual LUN is an aggregation of several "physical LUN's". Physical LUN (more or less) = tied to a single physical RAID group.

It's the same thought as a...

With 2005, it can get interesting licensing-wise with virtualization (Virtual Server, VMWARE, etc..). The cliff notes version is:

- if you're using Enterprise edition AND you've licensed ENTERPRISE edition...

Brandie Tarvin (3/7/2008)

---

Amen to...

Considering their purpose is to limit data from coming back - they're going to cause the query to be "harder", more work, etc... But that's the definition of what...

could you explain what leads you to believe that it's "not working"? What are you getting or not getting that you were expecting? Give us some specific examples...

You will find that you're going to need to do that outside of a function. Exec isn't allowed in a function.

In the same...

I came across this from what is currently one of my favorite comic strips....I kind of hope this is true for Gary - I think he'd enjoy it this way....

http://www.xkcd.com/393/%5B/url%5D