Your formula seems correct but you don't have number or calls made or received, instead you have duration of them. Check your data and post again.:-)

It's not that difficult, you can do it this way or with 5 UPDATEs, one for each condition.

UPDATE m SET

Category1 = CASE WHEN ( Score > 0.0 AND Score...

It's really easy, just follow the instructions on this article:

http://www.sqlservercentral.com/articles/comma+separated+list/71700/

For a coded answer, please provide DDL and sample data in the form of insert statements.

GilaMonster (10/25/2013)

Insert into...

Maybe you could look on this great article from Jeff Moden. It might help you on your solution. It might not give you the exact query but if you understand...

LAG value can go any rows back. That's the second parameter of the function. Check example C on the LAG documentation.

In the risk of hijacking this thread, I have to partially disagree with Mr. Zimmerman.

SELECT...INTO... statements aren't bad for performance. Actually, with good coding habits they can be a lot...

If you're really using SQL Server 2012, you should take a look at the LAG function.

For better answers, please take Sean's advice.

What exactly? Are you sure it wasn't helped by the buffer cache?

This might help you.

WITH BillingGroups AS(

SELECT BillingGroupNumber,

row_number() over (order by BillingGroupNumber) as RowNum

FROM Sap.DetailsImport

)

INSERT INTO [ReceiptRepository].[Lkup].[BillingGroups]

SELECT BillingGroupNumber,

'Company' + CAST(RowNum AS varchar(10)),

'Y',

'TeraByteMe',

GETDATE(),

TeraByteMe,

GETDATE(),

'2006-01-01...

If you're running the package on BIDS, there's an execution results tab with that information.

If you don't know coding, why would you want to do it with a script task if a data flow is the appropriate task for your situation?

There's none, it was just an example on how to do things correctly 😀

Just a couple of ideas to test for performance, but might not be an improvement.

declare@Denominator2 int,

@StartDate datetime,

@EndDate datetime

set @StartDate='2013-02-01'

set @EndDate='2013-09-30'

select @Denominator2= count(*)

FROM

(

select a.MRN

...

If this is homework and want to impress your instructor, you should take a look at this article.

http://www.sqlservercentral.com/articles/T-SQL/91724/