You want something like this:

-- Setup test table

create table #TestData (

LogKeyID int,

CreateDate datetime,

OrgKeyID int,

...

Just so you...

Simplest answer, it depends. Most likely, yes, if done correctly. Hard to tell you with just the info provided.

I'm not sure what you are asking here. OTAP makes no sense to me.

To be honest, there really isn't enough information in your post to provide a decent answer. Could you provide us with a clearer explaination of what it is you...

Yep, been there, done that.

PeopleSoft requires using Latin1_General_BIN as its collation.

Jon.Morisi (11/20/2012)

---

Did you ever figure this out? I'm looking at the same thing and it looks like you need to select the Windows collation designator and sort order radio...

Who said I didn't need a QB? I got beat by a QB. Had NFL Soldiers QB just MADE his projection, I would have won, but no, he...

Rechecked what you posted, sorry,...

Eugene Elutin (11/20/2012)

---

Another one from Lynn Pettis, for some reason he couldn't post it himself...

declare @email varchar(100) = 'Doe.John@CompanyABC.com'

SELECT

SUBSTRING(@email, 1, CHARINDEX('.', @email) - 1),

...

jgenovese (11/20/2012)

---

All:

This was literally a "switch-flip" -- the query run time doubled exactly right after I made the changes noted in my original post

(note: on that day I rebuilt...

The title of...

Ratheesh.K.Nair (11/20/2012)

---

In the procedure they are deleting values before a particular date.

Values are deleted from a master table and inserting into a another table.

Smaller chunks in the sense changing the...

If you want to see some more date calculations, look here:

http://www.sqlservercentral.com/blogs/lynnpettis/2009/03/25/some-common-date-routines/

Simple:

declare @ThisDate datetime;

set @ThisDate = getdate();

select @ThisDate, dateadd(qq, datediff(qq, 0, @ThisDate), -1);

set @ThisDate = '20120507';

select @ThisDate, dateadd(qq, datediff(qq, 0, @ThisDate), -1);