CirquedeSQLeil (4/7/2010)

---

TheSQLGuru (4/7/2010)

---

And...

Steve Jones - Editor (4/7/2010)

---

Rob Schripsema (4/7/2010)

---

You mean, if I stick around here long enough, I could be in high demand for dates, parties and other social events, too? ...

Wait... Parties?

WHY WAS I NOT TOLD OF THIS. I LOVE PARTIES. :crazy:

Well, Ok. Actually I just love beer... but you know what you normally have at...

See if this will work for you.

http://phelabaum.com/archive/2010/02/tally-table-delimited-list-to-table/

Edit: Sorry, just read that a bit closer, my function might be too hard to adapt.

The last time I got an invalid namespace error was when I was trying to install a 32 bit app on a 64 bit machine. May not apply, but...

That's what my thought was as well, at least to cover the difference in 4s vs. 690ms. I'd heard that they...

Any chance you had the Actual Plan on when you were testing? I show the scalar as the fastest, but without the plan on none of them are that...

Most of the backups I've seen have had somewhere between 50-80% size reduction. That's just ballpark possible numbers though, as Jeff said, it depends on the Data.

The live data......

Thanks.

Nothing like actually having an article published that lets you see all the things that you forgot to add to it! :hehe:

This would make a great TSQL Challenge. I've been going around in circles for a couple hours now trying to figure out a way to do this in a...

You can also move the IF up a line to be before the insert statement. You'll need to add the insert again just below your else.

IE:

IF...

insert...

select...

else...

insert...

select...

That said, there's a...

This is probably not the reason, but I've never been able to find an answer as to *which* sql handle you really need to be grabbing. (There are often...

Elaine Shafer-401422 (4/7/2010)

---

I frequently use SELECT CAST(FLOOR(CAST(<yourDateHere> AS FLOAT)) AS DATETIME)

Interestingly, rounding happens near midnight. The following returns '2010-04-08 00:00:00.000':

DECLARE @Date DATETIME = '2010-04-07 23:59:59.999'

SELECT CAST(FLOOR(CAST(@Date AS...

ArkWare (4/7/2010)

---

Seth,

very nice. good explaination.

I have one question...

in the following code, isn't it returning the first of the week +/- 2 days?

SELECT DATEADD(wk, DATEDIFF(wk,0,GETDATE()), 2)

--: 2010-03-01 00:00:00.000 Start of...

ArkWare (4/7/2010)

---

mbarkell (4/7/2010)

---

On my system using the query for the first day of the week gives Monday instead of Sunday which is, of course, incorrect. Is this based on...