You will have to dissect the procedure as...

Raymond.Pietrzak (5/30/2014)

---

I was able to write my query against the VarChar(4000) data type. This worked.

Update [WBPROD].[dbo].[TASK_SCHEDULE]

Set TSKSCD_DESCRIPTION = Replace(TSKSCD_DESCRIPTION, '<timezoneId>0</timezoneId><timezone>America/New_York</timezone>', '<timezoneId>1</timezoneId><timezone>America/Chicago</timezone>')

Update [WBPROD].[dbo].[TASK_SCHEDULE]

Set TSKSCD_DESCRIPTION = Replace(TSKSCD_DESCRIPTION,

...

Since this is a 2012 thread, how about the window functions?

😎

create table #sampledata

(

userId int,

BaseYear int,

TotalSales float

)

insert into #sampledata

select 1,2008,25000 union

select 1,2009,22500 union

select 1,2010,23400 union

select 1,2011,26700 union

select 1,2012,25200 union

select 2,2008,25050...

I have found that one should generally (as much as I dislike generalization) avoid AUTO_GRID.

😎

samalex (5/29/2014)

---

Everyone has their own style of writing code and doing things, but there are some pet peeves I've developed over the years, especially when I review other people's code,...

Sean Lange (5/29/2014)

---

samalex (5/29/2014)

---

Wow, I agree with literally 100% of what you guys have entered, including 'sprocs'. We have a few non-DBA's who use this verbiage, and it always makes...

Ouch..... good thing that my title is no longer a "developer" :-P:-P

adhiman (5/29/2014)

---

I am running a query on SQL 2012 Server with the Resource governer setup for my account to have Max DOP option set to 1.

The query still runs...

Sean Lange (5/29/2014)

---

My code does two very important things. First, it only updates the rows that need to be updated instead of updating them all. Secondly it references the alias...

Forgive me for being slow here and slightly off the topic, but how can a single session, multiple batch thingy create multiple instances of a temporary table with the same...

:-DThat is how we learn!:-D

😎

tshad (5/29/2014)

---

I have a situation where I want to update a column if and only if it is null.

UPDATE Employee

SET VEmployeeID = CASE WHEN E.VEmployeeID IS NULL

...

GilaMonster (5/29/2014)

---

It's because batches are parsed as a whole, then executed. When the parser hits the second create for that table it fails. It works with the debug break because...

Cannot say much without knowing more about the table structures, first guess would be this part of the join

😎

dbo.TCDaily.TCDay = dbo.EmpList.EmpID

wolfkillj (5/29/2014)

---

Eirikur Eiriksson (5/29/2014)

---

wolfkillj (5/29/2014)

---

Except that the requirement was...