Luis Cazares (7/26/2016)

---

Just a small correction to J Livingston's query to avoid scanning the whole table.

SELECT

Custmer,

location,

SUM(CASE WHEN [Date]...

maybe?....though my YTD is different than yours ?!?

SET DATEFORMAT DMY

CREATE TABLE #yourtable(

Custmer INTEGER NOT NULL

,Date ...

join Details to Names twice.....once for CEO. second for Manager

seems you havent figured it out yet ..so...

maybe ??

WITH cte AS (

SELECT NAME,

VALUE,

ROW_NUMBER() OVER(PARTITION BY NAME ORDER BY (SELECT NULL)) rn

FROM...

randy.moodispaugh (7/20/2016)

---

Yes, I'm good with the DB Mail. I'm just playing through the different kinds of logic I would need to create an automated rotation of the DBA On...

Muhanned Maayeh-445298 (7/19/2016)

---

J Livingston SQL (7/19/2016)

---

If you have "different conditions" then why...

amirtharaj.j (7/19/2016)

---

Hi,

I have 2 tables. Please see the attached screen shot for data. I need to join these 2 tables with

schoolID and pick top 3 students of each school...

If you have "different conditions" then why did you not post them...

maybe, as a start?

WITH CTE AS(

SELECT ShiftID, UserID, StartTime AS tm

FROM Shifts

UNION...

JaybeeSQL (7/19/2016)

---

No that just returns a single date, and one I (would) need to embed...

maybe?

DECLARE @f1 AS VARCHAR(100)= 'The Double Cross (01/Mar/13)';

SELECT CAST(LEFT(RIGHT(RTRIM(@F1), 10), 9) AS DATE);

please read this and then repost.

https://spaghettidba.com/2015/04/24/how-to-post-a-t-sql-question-on-a-public-forum/

and why have you got duplicate identical rows in the student table?

why use something that is "prettty quick" when you can...

Ed Wagner (7/14/2016)

---

Like Jeff said, there are a lot of those functions out there that are lacking in performance. I haven't tested the function you posted, but just knowing...