Here is your answer.

WITH RowNums AS( -- This is to get values for calculations of the first and last values

SELECT v.pid, v.ListValues,

ROW_NUMBER() OVER(ORDER BY v.pid) rn,

COUNT(*) OVER()...

ITU_dk2012 (10/19/2015)

---

Thanks for your help though. This is not a homework assignment. I can't post confidential data so I just posted some sample data to get an idea. I think...

Now, one last thing, based on the sample data what is the expected results? This gives us something to check against and allows you to verify both your assumptions...

ITU_dk2012 (10/19/2015)

---

@Lynn Pettis, and @Alvin Ramard,

If you both are experts in T-SQL Programming it doesn't mean that you should mock or make fun of other people who are just learning...

Eric M Russell (10/19/2015)

---

What % of rows are you deleting and how often? If > 25%, then you probably want to go ahead and just drop all indexes and then...

Run the following:

select date_time_txt, try_parse(date_time_txt as datetime2) testConvert

from hourly

where try_parse(date_time_txt as datetime2) is null;

Any results returned?

Well, here's the problem. We can't see what you see from here. We have no idea what the process is that is extracting the data from Teradata. ...

ITU_dk2012 (10/19/2015)

---

Hello Luis,

Your solution works fine. Now I need pull more columns from another table by joining it with the table which contains the list of values. For example I...

Jeff Moden (10/18/2015)

---

Kristen-173977 (10/18/2015)

---

If deleting, say, 90% of the table then worth considering "copying" the 10% to be retained into a new temporary table, and dropping old table / renaming...

latingntlman (10/19/2015)

---

Hello all,

I'm having a similar issue but the exit code is "12" while the expected was "0". I'm completely stuck and not sure what it means or where...

The key here, is yes we have ideas, but we'd like to see some effort on your part instead of just expecting us to give you an answer that you...

Go here: http://www.sqlservercentral.com/blogs/lynnpettis/2009/03/25/some-common-date-routines/

Here is the update query initially post in a slightly more readable format:

UPDATE SERVICE_REQUEST

SET SERVICE_REQUEST_STATUS = 'PrintedOnPullReport'

,LAST_PRINTED_ON_REPORT_DATE = '2015-10-15 00:00:00'

,LAST_MOD_DATE_TIME = '2015-10-15 06:10:03.223'

,LAST_MODIFIER = 60417

,PRINT_REQUEST_ID = 69432

FROM SERVICE_REQUEST AS CollateralGroupRequest02

CROSS...

Start here: https://msdn.microsoft.com/en-us/library/ms190273(v=sql.110).aspx.

Not sure how the DTA is going to help with a deadlock issue. Have you captured the deadlock graph to see where the deadlock(s) are occurring?