SELECT *, CAST(COUNT(sales) OVER(PARTITION BY e.customerId) AS BIT)

FROM #example e

Drew

Do not EVER do this. I believe that there are only two...

You're setting your @startdate twice, so the @enddate is NULL.

Drew

Setting Up Your SQL Server Agent Correctly.[/url] Especially pay attention to the section What service account to use.

Drew

Jacob Wilkins (5/26/2016)

---

drew.allen (5/26/2016)

---

Well, the documentation for nchar and nvarchar still says that the the value can be any number from 1 to 4000 or max, and 5000 is clearly...

Well, the documentation for nchar and nvarchar still says that the the value can be any number from 1 to 4000 or max, and 5000 is clearly not in that...

Not the creator name, the account the job is running under. If I remember correctly, by default, this is a SQL account which HAS NO ACCESS TO NETWORK DRIVES....

Lowell (5/26/2016)

---

something like this gets the desired code name, but which would you want with multiple matches?

SELECT row_number() over(partition By T2.code_name ORDER BY T2.code) AS RW,T2.code_name As DesiredCodeName,T1.*

FROM dbo.table1 T1

...

John Mitchell-245523 (5/26/2016)

---

DesNorton (5/25/2016)

---

If you need an editable "computed column" ...

Create a standard column [NICKNAME]

Create an INSERT trigger that sets [NICKNAME] = [LASTNAME] + ' ' + [FIRSTNAME]

Then the column...

Sturev (5/25/2016)

---

Thanks Drew! In this case we don't want the orphans; I know, not ideal...

Also, the reason that you are getting NULLs is that the following code is looking for cases where the CompanyName field is equal to the literal strings 'CompanyPrevName1' and 'CompanyPrevName2'....

Try the following:

; WITH chi_nm AS (

SELECT *, ROW_NUMBER() OVER(PARTITION BY chi.CompanyID, LEFT(chi.PreviousCompanyName, 3) ORDER BY chi.NameYear DESC) AS rn

FROM (

VALUES

(1,'Kay Enterprises',2015),

(1,'The Kay INC',2014),

(1,'Kay INC',2013),

(1,'Kay Group',2012),

(2,'RIDGE',2015),

(2,'The RIDGE PARTNERS',2014),

(2,'Medical Company of...

Here is another approach. This has the advantage that it accounts for orphaned records.

SELECT

ROW_NUMBER() OVER(ORDER BY a1.AFFILIATIONID) NewRecordID,

a1.ENTITYID AS FromRecordID,

a2.ENTITYID ToRecordID

FROM #a a1

LEFT OUTER JOIN #a a2

ON a1.AFFILIATIONID =...

I believe the following will work in SQL2008. I don't have a SQL2008 test environment handy to test.

;

WITH pd AS (

SELECT

pd.PatientNumber,

pd.DCDispCode,

pd.DCDate,

MAX(CASE WHEN pd.DCDispCode = '20' THEN pd.DCDate END) OVER(PARTITION...

Brandie Tarvin (5/24/2016)

---

So today I learned that it is possible to create an infinite loop in SQL. With a CURSOR no less.

What an interesting day it's been already. @=)

Apparently FETCH...