This will also "truncate" the time portion of a datetime value to midnight:

select dateadd(dd, datediff(dd, 0, getdate()), 0)

imSQrLy (7/20/2009)

---

I originally got my MCDBA on 2000 along with my MCSE and MCSA on 2000 OS. I certainly was experienced with Windows and would not have considered myself a...

This is one of the DMV's that you could use. You'll need to figure out exactly how at the moment as I need to head out to work.

sys.dm_db_partition_stats

At this point, then, I suggest you talk to you DBA's as it looks like you are going to need their assistance to accomplish this task since the transaction log...

It is getting late, so what I'm going to do right now is point you in a general direction and let you run with it a bit. You are...

You need to break it down into batches, and run t-log backups between inserts. Is there a common primary key or unique between the two tables?

Does anyone else get the feeling that some people think we are here to not only help and mentor others but to actually do their work for them with no...

Gift Peddie (7/19/2009)

---

That is very nice point get random...

Gift Peddie (7/19/2009)

---

Considering that obtaining Vendor Certifications is voluntary, I really don't think there are legal grounds for any governmental organization to make such requests. If these certifications were required...

Gift Peddie (7/18/2009)

---

... Microsoft, Cisco and now Oracle if it buys Sun knows one day Uncle Sam and EU may want some docs showing why there are so few...

You mention Novell's CNE in your editorial, and twenty years ago I had considered trying to earn that certification as the company I worked for at the time had a...

Curious, but would this work as well?

select

FiscalMonthDTTM,

left(datename(month,FiscalMonthDTTM),3) Mth,

Sum(case when TimeType='YVW Crib'

...

Here is a way to accomplish your task. First, you need the following function (or one similar):

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE function [dbo].[DelimitedSplit] (

@pString varchar(max),

...

Assuming that you are updating existing records, why not put a ModifiedDate column on the table and update that column when you update the row? Then you just have...

So, how about DDL for the table(s), sample data, expected results based on the sample data, and most importantly what you have done so far to solve your problem.

Need help...