You made changes to your update statements to merge them into one, but got lost with some logic.

Update Asgnmnt

Set DateAcknow =@ClosedDate,

TimeAcknow=@ClosedTime,

WhoAcknow =@ClosedBy,

DateResolv = @ClosedDate,

TimeResolv = @ClosedTime,

WhoResolv = @ClosedBy

Where CallId =...

Do you have an index on Time_Created?

DATEDIFF will only execute once for the whole query, so it's probable not your problem.

By the way, you might be wanting to use DATEADD(day,...

Just to be clear. There are 2 datetime formats that won't be affected by SET DATEFORMAT.

One for dates only: 'yyyymmdd'

And one for datetime values: 'yyyy-mm-ddThh:mi:ss.sss'

Both comply with ISO 8601 formats...

I'm not sure if it's a better solution but it's an alternative that you could test.

SELECTDISTINCT

[FirstName]

,[LastName]

,[Team]

,[TransactionID]

,FIRST_VALUE([Price]) over (partition by firstname, Transactionid order by price desc) Price

FROM [Test].[dbo].[Team]

It depends on what you're inserting. Does all the information needs to be available at the same time? You could do inserts on batches to prevent long times during blocking.

If...

And just to give a second option.

WITH X(TotalAllCustomersOnFile,TotalConsumersWithValidEmail,TotalConsumersWithValidEmailAndOptedIn) AS

(SELECT * FROM (VALUES ('2,500', '1,750', '1,500')) AS X(TotalAllCustomersOnFile,TotalConsumersWithValidEmail,TotalConsumersWithValidEmailAndOptedIn)

)

SELECT

XY.Audience

,XY.Totals

FROM X

UNPIVOT

( Totals...

Aren't you using a staging table to prevent problems?

2 things:

If you only have the DELETE and the SET inside your transaction, you don't need an explicit transaction.

If you're going to use explicit transactions, you should use TRY...CATCH blocks...

DonlSimpson (4/29/2015)

---

Luis Cazares (4/29/2015)

---

chgn01 (4/29/2015)

---

How about use ISNULL?

-- Q3

SELECT

*

FROM

#abc a

...

chgn01 (4/29/2015)

---

How about use ISNULL?

-- Q3

SELECT

*

FROM

#abc a

...

This is the FOR XML version that Lynn previously commented.

You can find more information in here: http://www.sqlservercentral.com/articles/comma+separated+list/71700/

DECLARE @strSQL Varchar(MAX) = '';

WITH FinalDBleverluser(dbname, username) AS (

Select

dbname,

...

r_slot (4/28/2015)

---

Hello Luis,

I am not feeling offended, just appreciating your remarks. What you are saying is that I should use varchar(40) instead of nvarchar(max). Normally I do that but in...

Lynn, I'm curious.

What where you expecting to do with the Years and Tally CTEs? I'm sure that you included them for your tests, but I'd love to know what...

Hi there,

I'm not sure if you're clear on the purpose of stored procedures and functions. If you're used to common programming languages, you'll find out that stored procedures are very...

As that's a local temp table, couldn't you avoid inserting those rows in the first place? You would save time inserting and deleting.