Duplicate post, please post all responses here.

michael vessey (6/8/2012)

---

try the following

declare @mydate datetime

set @mydate=GETDATE()

SELECT dateadd(dd,4,CONVERT(VARCHAR(25),DATEADD(dd,-(DAY(DATEADD(mm,1,@mydate))-1),DATEADD(mm,1,@mydate)),101) )

see Pinal Dave's blog post on these

http://blog.sqlauthority.com/2007/05/13/sql-server-query-to-find-first-and-last-day-of-current-month/

edit: the other suggestions are better than mine - i did a cut an...

Lynn Pettis (6/8/2012)

---

krypto69 (6/8/2012)

---

Is it possible to have this query do a distinct count of each orglevel?

SELECT

----DATEPART(YEAR, e.eecDateOfLastHire) as 'Year of Hire',

--EEPDATEOFBIRTH,

(select distinct count E.EecOrgLvl2) as 'county',

CmpCompanyCode as 'Company...

krypto69 (6/8/2012)

---

Is it possible to have this query do a distinct count of each orglevel?

SELECT

----DATEPART(YEAR, e.eecDateOfLastHire) as 'Year of Hire',

--EEPDATEOFBIRTH,

(select distinct count E.EecOrgLvl2) as 'county',

CmpCompanyCode as 'Company Code',

E.EecOrgLvl2 as...

BaldingLoopMan (6/8/2012)

---

I'm going to delete about 8 million recs from a table who has 27 milllion records. I had planned on looping and doing the delete 1000 at a time....

michael vessey (6/8/2012)

---

yes, but it's not without pre-requisite actions - you must follow these...

dwilliscp (6/8/2012)

---

I can not seem to figure out what I did wrong.. this does not return any records...( trying to build a statement that will get the 5th day of...

Koen Verbeeck (6/8/2012)

---

Because once in a while, you get replies like these:

Koen,

You rock! It worked for me! The solution I have found by following the link you provided, http://www.sqlservercentral.com/articles/Integration+Services+(SSIS)/65112/, totally...

First, if I remember correctly from previous threads, you said the data in the text columns was dirty, requiring you to do the ltrim(rtrim()) tricks in your comparisions.

With this, the...

Something like this?

USE [Sandbox]

GO

/****** Object: UserDefinedFunction [dbo].[itvf_FormatTimeHHMM] Script Date: 06/07/2012 15:30:53 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE FUNCTION dbo.itvfn_FormatTimeHHMM (

@TimeInMinutes INT

)

RETURNS TABLE WITH...

As quickly as a trigger can send a message to a queue for SB, if you are more familiar with SB then that is the direction I would go.

Well, I don't know anything about CDC and only a little about SB. I would think SB might be a bit easier to implement having used it to handle...

There is also the other part of Disaster Recovery, how much is the company willing to spend, how much are they willing to lose (data wise), how quickly do they...

So, we are talking about cached data in the application. Have you looked at Query Notification?

You also have define Disaster. It can be considered a disaster if a harddrive fails, or switch dies, a server crashes. A disaster does not have to mean...