Look at the function FLOOR()

*facepalm* This is not pretty.

As to your first comment, your first post was at ~1:30 AM, and the next at ~5:45 AM for me. I was asleep while...

Link saved, thank...

paul.knibbs (6/28/2011)

---

10Gb data in SQL Express 2008...

repicurus (6/29/2011)

---

I gave NO legal advice whatsoever - I'm honestly not sure how you could derived such a conclusion.

There was NO action taken that would result in any legal standing;...

Jeff Moden (6/28/2011)

---

Craig Farrell (6/28/2011)

---

Here's where that concept gets caught. Yes, YOU as a DBA may own your server's code. I know many, including myself depending on the environment, who...

paul.knibbs (6/28/2011)

---

I have a 64-bit R2 Express install on my PC here. Just checked it out, and found the following files:

License_SqlBrowser.txt

license_SQLCMD.txt

License_SQLNCLI_ENU.txt (one of these in both Program Files (x86) and...

Ninja's_RGR'us (6/28/2011)

---

paul.knibbs (6/28/2011)

---

10Gb data in SQL Express...

Please see the first link in my signature for the best way to setup a sample DDL/dataset and to show what results you're looking for from that dataset.

It's much easier...

Hey Jeff. 🙂

I'd hoped you'd swing by. I really didn't want to utterly derail the other thread and something like this can take on a life of its...

It's precisely the right word when you've got 3-4 DBAs supporting 80 developers. They cannot own anything, which is why...

george sibbald (6/27/2011)

---

the thread won't die whilst the no. of characters in a 'tweet' is limited.

Or so I believe. I have never 'tweeted' myself and feel silly just using...

george sibbald (6/27/2011)

---

Craig Farrell (6/27/2011)

---

george sibbald (6/27/2011)

---

I think you have to accept that in most shops devs will own the code but not the environment (and certainly not production). The...

mtillman-921105 (6/27/2011)

---

Craig Farrell (6/27/2011)

---

mtillman-921105 (6/27/2011)

---

I've never tweeted, but I already have a follower somehow! Here's one of their delightful insights:

So my nose ring hole got reallly small cause i've...

mtillman-921105 (6/27/2011)

---

I've never tweeted, but I already have a follower somehow! Here's one of their delightful insights:

So my nose ring hole got reallly small cause i've been having a...