You're welcome and Happy Friday to you too!

;WITH OrderedRows AS (

SELECT Last_Name, First_NAme, Department, Email, phone, Sid,

rn = ROW_NUMBER() OVER(PARTITION BY Last_Name, First_NAme, Department, Email, phone, Sid ORDER BY (SELECT NULL))

FROM MyTable

)

DELETE FROM...

How long do they take to run?

How long does a potentially SARGable SELECT MAX(CONVERT(smalldatetime, CAST(MonthValue AS varchar) + '/01/' +

...

gcresse (4/15/2013)

---

I have a challenge that I was hoping to solve using the new SQL Server 2012 running balance capabilities, but it's a bit more complicated than I realized. ...

Heh fantastic! That's quite an achievement!

Awesome! Well done Jason!

Wayne, is that you too?

Easier and Correcter 😉

SELECT [firstname] = value

FROM test

WHERE key = 'firstname'

ashuthinks (4/17/2013)

---

Hi,

I want to use group by on one column which is having many entries

table_a

Name price

AAA 12

BBB...

baabhu (4/17/2013)

---

ChrisM@Work (4/15/2013)

---

That looks ok to me, other than the joins to the temp table not being optimized. You don't really need the temp table anyway:

SET @RowsDeleted = 1000;

WHILE @RowsDeleted...

Thank you very much Gary - duly updated.

balde (4/16/2013)

---

Ever since discovering a use for APPLY for the first time approximately 2 years ago, I've found I use it almost everywhere these days.

To the extent where I start...

Is this code generated by a tool?

akberali67 (2/8/2013)

---

Finally ran out of system memory after 1.5 hours. I dont know what to do, this stuff is making me crazy.

Msg 701, Level 17, State 123, Line 3

There is...

drew.allen (2/8/2013)

---

No, but the syntax was...

GilaMonster (1/29/2013)

---

ChrisM@Work (1/29/2013)

---

How many rows in the table? How many rows are you returning? If you are returning more than say 25%* of the rows in the table, SQL Server...